Sponsored Links


  • 1. Change in Dimension not reflected
    I am using excel to display data from an analysis services cube. One of the dimensions has a level with multiple properties. Changes in the properties are reflected in the excel when data is refreshe but when the level value changes, it does not get reflected in the excel. However, on browsing the dimension in the analysis manager, the changes are visible. Thanks in advance for all the help. Regards, Brijesh
  • 2. XMLA script generated in UNICODE but was not in a previous versio
    I have a process to deploy an olap cube database to customers where I generated an XMLA script by right clicking on the OLAP db in the object explorer and created XMLA file. I then have a routine that modified the connect string information in the XMLA script, saved it then executed it via an SSIS/DTS package from the command line. I made some changes to the OLAP cube db and had to re-generate the XMLA file from scratch. It seems it is now being saved with a double byte character set/UNICODE. This was not the case when I generated the previous XMLA script perhaps with the final CTP version of SQL Server 2005. Is this true and can I make it save the file without the double byte character set? I have found if I script it to the clip board, open notepad and paste it there it is fine, but I don't want to cut and paste everything! Thanks, Jason -- Jason
  • 3. Building Cubes from Teradata
    I am trying to connect to Teradata using a teradata odbc driver, so that I can build cubes off it. I have not been successful in doing so. Can anyone point me to the correct ODBC driver so that I can connect it to SQL 2000 on win 2003 Sp1. TIA, Shri


Postby TIZI » Fri, 25 Nov 2005 20:08:55 GMT

Help me!!!

In the cube dimensions box on the right hand side, it doesn't list the
current dimensions of the cube.

My dimensions are based on the same datasource as my cube...

This happens for all of the cubes of the same database....

In the other databases of the server it doesn't happen.

What can be happened???


...and sorry for my English

Similar Threads:

1.How to Get List of Dimensions Associated With a Cube


Is there a dynamic way to list the following through code in C-sharp/
1. List of cubes which use a particular dimension (example, dimenstion
- "Geog" - used in Sales, Profit cube)
2. List of dimensions used in a cube?

Example, Oracle OLAP had something like LISTBY. Example, LISTBY
Geography would give "sales" & "profit" - Geography dimension is one
of the dimensions on "sales" and "profit" cube.

OR Desc sales would give - sales <Time Geography Customer>.



2.MDX Query to get list of dimensions and measures

Can someone give me a quick example of an MDX query that lists
dimensions on a cube?  Also another example for determinining an MDX
query to list measures of a cube.

thanks for any and all help,


3.Obtaining a complete list of members in a dimension

What is the best way to obtain a list of distinct members in a dimension 
independent of a cube?
We need the flat list of members without their hierarchical attributes.
We also need computed members to be included in the list.
A code snippet would help.
We are using MSAS 2005 and C## 2005

4.Levels of Dimension in Filter List


In pivot table when a particular level of a dimension is dragged and dropped in the row or column areas then only that level is displayed. But when i drag and drop one level of a dimension in filter fields area, the complete dimension is displayed with the complete hierarchy
E.g. Suppose i have a supplier dimension with Industry as top level and supplier as the second level. When the supplier level is dragged and dropped into filter fields area, the complete hierarchy is displayed
Is this default behaviour of the pivot table control and if yes then is there any work around for this


5.Can I create a parent child dimension in Dimension Designer, after dimension is initially created

Good evening, all

I have  a dimension that has a parent child hierarchy in it, which
contains the primary key of the underlying data.

I also have a need for a second parent child hierarchy for this same
dimension.  Is this possible?  How do I create a p/c hierarchy
manually in dimension designer?


6. List within a List using a System.Collections.Generic.List as the Data Source

7. Dimensions Type 2 - Slowly Changing Dimensions

8. Multiple dimensions from single dimension table



Who is online

Users browsing this forum: No registered users and 53 guest