我有显示投资者及其投资价值的SSASCube。 资金价值和按比例分配的份额实际上是表。 我制定了计算方法,简单多加基金价值* 的份额。 问题出现在总线上。 被称为“妇女权利行动”的一行是现在的情况。 这是我想要显示的。
Investor Fund Value Share Investor Value
Investor 1 100,000 0.4 40,000
Investor 1 200,000 0.3 60,000
Total 300,000 0.7 210,000 <== WRONG
Total 100,000 <== RIGHT
Max answer is the way to go if performance might be a problem (precalculation). It s possible to solve the prorarta using MDX Calculated members (performance might be an issue if your dimensions are big).
要进一步考虑这一解决办法,我需要一个层面,即100 000和200 000个基金价值是不同的(例如[Share])。 您能描述你们的层面?
我知道这几个月已经过去了,但我要用一份范围说明来用正确的计算来推翻这个小组。 http://www.bidn.com/ articles/mdx-and-dmx/94/mdx-scripting-with-cop- statements” rel=“no followlow”http://www.bidn.com/ articles/mdx-and-dmx/94/mdx-scripting-with-cop- / 声明> 认为该条要求的是标志,但必须是自由的。
简单明了:在您的 o光银行(在相应的事实表中)的每日生活津贴中创造新的计算领域(表达方式)。 在采取这一措施之后(SUM类组)。
I am new to OLAP. I understand the table structure and ETL process. I don t understand when data is supposed to be deleted from the fact table. Say I m creating a reporting application for events. ...
I am using IIS 6.0 on Windows 2003 in a workgroup, and have created a web which runs in its own pool to connect to a Sqlserver 2005 Analysis Services database using msmdpump.dll. I have set the pool ...
I have an application that requires analytics for different level of aggregation, and that s the OLAP workload. I want to update my database pretty frequently as well. e.g., here is what my update ...
I have an MDX query with the following calculated member: with member [Measures].[BBOX] as Count( Filter( CrossJoin([Dim Response].[Response ID].Children, [Dim Question].[Question Text]....
We have an SSAS server with a cube deployed on a server over the WAN.. We are trying to connect to the cube from Excel on various client workstations. The server is not on a domain with the clients. ...
I have this MDX query (based on the Foodmart sample database): SELECT {[Measures].[Profit]} ON COLUMNS, {CROSSJOIN([Product].[All Products].Children, [Time].[1997].Children)} ON ROWS FROM [Sales] ...
I have an analysis services cube in SQL server 2005 which I m connecting to via an excel front end. When I connect via one user its fine, but when I log on to the same machine as another user I get ...
I have defined dimension security in my OLAP cube by creating roles and assigning users to each roles. Each user in a role can only see the location they belong to. When I browse the cube using a ...