Hi,
I am building a cube in the 2005 Analysis Services. I built the cube successfully when each of my dimensions referenced exactly one table. Now I want to extend that to build two dimensions based on one table. I can build the 2nd dimension but I cannot use it within the cube.
Any suggestions on how to do that?
Thanks in advance,
Aref
Any reason why you can't build 1 dimension and use it in 2 roles within your cube (eg: Date dimension in Adventure Works plays 3 roles)?hi
is there a way to create a dynamic translation for a cube ?
i have another table that translate words and i want to that the cube dimensions names and the measures name will translate by the table i have
is there a way i can do it ?
Thanks
Eyal
Hi,
AS2005 can do what you described for attribute members, but not for cube dimension names and measure names. For attribute members, in the dimension editor (in BI Development Studio), in the Translations tab, you can specify for each attribute the column (from the relational table) from which to get the translated member names. For everything else (dimension names, hierarchy names, cube dimension names, measure names etc) AS2005 allows specifying a static text per language (the translated name).
However, you can use AMO (the management object model for AS2005) to dynamically read from the relational data table and create a Translation (with the static name) for each cube dimension and measure.
If AS2005 were to support natively this scenario, on each process of the cube, you would have gotten the new translated names for cube dimensions and measures. But if you do not have frequest changes in the translations table, then it should be acceptable to create the translations manually (and only update them from time to time, not necessarily on each cube re-process).
Quick startup on AMO: http://adriandu.spaces.live.com/
To create the translated names for cube dimensions and measures, there are the CubeDimension and Measure classes, each having a collection of Translation objects; each Translation specifies the Language (as an LCID) and the Caption (the text you will read from the relational translations table).
Adrian Dumitrascu
I have a cube with a dimension 'Destination', that has the follown herarchy.
Country -> State -> City.
As measure I have Number of transactions.
When I browse the cube I can get the total transactions if I expand all the levels, but If I just want o have number of transactions by state or country the cube is no creating totals by those levels. Even in the cube when I expand all levels (including city), there are not totals by state and country. What I am missing?
You can email me to jzuluaga@.msn.com or jzuluaga@.quisqueyana.com
Thanks
Juan,
What are you using to browse the cube?
Steve
|||Check the calculations of the cube and make sure that it contains the CALCULATE command. This command is always included by default, but if it is deleted accidentally, then you will only get leaf level data as this command is what instructs the server to aggregate data up from the lowest levels up to the higher levels.
