Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing Cube

Status
Not open for further replies.
bebbo1986

bebbo1986

Programmer
Feb 12, 2008
43
DE
Hallo,
I'm using SQL Server 2008 and Excel 2002 the Add-in for SQL Server Analysis Service.
On my Server there are different Cube, in every Cube there is a dimension called Dealer with a hierachy "Total Dealers" with an entry "All".
What is now different in every Cube are the children of "All".
And my problem is that I need a list of all children (only the next level) of "All" and it should be dynamic. That means that the connection parameter in CUBECELLMEMBER is linked to a cell.
How could that be done, because CUBECELLMEMBER needs a unique name for the element, but that element name changes with every cube.

Thanks for your help and best regards,
Martin
 
Status
Not open for further replies.

Similar threads

Komal0735
  • Locked
  • Question
how to perform partial cube processing without losing data - SSAS, SSIS
Replies
0
Views
196
Komal0735
Komal0735
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
172
juanvg1972
juanvg1972
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
314
Motlatjo
Motlatjo
JP_Quinn
  • Locked
  • Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
209
JP_Quinn
JP_Quinn
skanskan
  • Locked
  • Question
Data Mining Cubes?
Replies
1
Views
179
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top