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,