误导性的单元安全错误消息会阻止 SSAS2008 上的钻取操作

发布于 2024-11-02 13:44:33 字数 1213 浏览 3 评论 0原文

我有一个未配置单元安全性的多维数据集,并且在钻取操作时遇到间歇性问题。该多维数据集有两个度量值组:一个包含来自财务应用程序 (Oracle Financials) 的会计交易,另一个包含一组外汇汇率。 FX 转换是通过度量表达式完成的,并由多维数据集脚本强制到叶级别。这个问题发生在SSAS2008(R1)上。

scope ([functional currency].[functional currency].[all]);
    scope ([measures].[herp fx rate]);
        this = null;
    end scope;
    scope ([measures].[derp fx rate]);
        this = null;
    end scope; 
end scope;

scope (leaves ([functional currency]));    
    scope ([fx period].[period].members);  
        scope ({[measures].[Herp GBP]});    
            this = [measures].[accounted] * 
                   [measures].[Herp fx rate];    
            //fore_color (this) = 4227327;   
        end scope;    

        scope ({[measures].[Derp GBP]});    
            this = [measures].[accounted] * 
                   [measures].[Derp fx rate];    
             //fore_color (this) = 32768;  
        end scope;  
    end scope;     
end scope;  

Calculate;

立方体上有钻取操作。当我尝试钻取操作(例如,通过 SSMS 多维数据集浏览器)时,多维数据集间歇性地返回错误,其影响如下:

无法进行钻取操作 执行是因为单元安全性确实 不允许访问源数据

各种论坛帖子建议设置 IgnoreUnlatedDimension=False 将解决此问题。但是,我找不到任何文档来解释为什么会发生这种情况,并且错误消息有些无用。有人对导致此错误的原因有一个连贯的解释吗?

I have a cube with no cell security configured, and get an intermittent problem with a drillthrough action. The cube has two measure groups: One with accounting transactions from a financials application (Oracle Financials) and one with a set of FX rates. The FX conversions are done with a measure expression, and forced to leaf level by the cube script. This problem is taking place on SSAS2008 (R1).

scope ([functional currency].[functional currency].[all]);
    scope ([measures].[herp fx rate]);
        this = null;
    end scope;
    scope ([measures].[derp fx rate]);
        this = null;
    end scope; 
end scope;

scope (leaves ([functional currency]));    
    scope ([fx period].[period].members);  
        scope ({[measures].[Herp GBP]});    
            this = [measures].[accounted] * 
                   [measures].[Herp fx rate];    
            //fore_color (this) = 4227327;   
        end scope;    

        scope ({[measures].[Derp GBP]});    
            this = [measures].[accounted] * 
                   [measures].[Derp fx rate];    
             //fore_color (this) = 32768;  
        end scope;  
    end scope;     
end scope;  

Calculate;

The cube has a drillthrough action on it. When I attempt a drill through action (via the SSMS cube browser, for example) the cube intermittently returns an error to the effect of

The drillthrough operation cannot be
performed because cell security does
not allow access to the source data

Various forum postings suggest that setting IgnoreUnrelatedDimension=False will fix this. However, I can't find any documentation that explains why this happens and the error message is somewhat unhelpful. Does anybody have a coherent explanation of what is causing this error?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文