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!
-
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!
-
how to create dynamic drop down list for each level of a dimension
Hi Have you tried with ADOMD.Level or ADOMD.Member object? They are objects with properties inherited of MDX. Level has : description, members ( children of them, count, collection of child,...), and its recursive Something like, Dim oCon As ADOMD.Catalog Dim oMember As ADOMD.Member Dim... -
Hierarchical Sorting Skiping Levels
Hi, I have got a "geographical" dimension with 5 levels but my query just return a report with 3 (the first and second one and the last one). I want to show a report with a 'sorted ASC' [sales values] but I can not use Order Function (with 'BASC' first level members are at the top, and... -
Array Interaction width MDX?
Hi, Does Anybody know how can I interact with and array in MDX? I have got an array with members (setToArray) and now I need to compare Array elements with "my" .CURRENTMEMBER, any idea? Thanks for all. -
How calculate percent values??
Hi again!! First of all thanks for all helps. I am going to expose my question and the solution I have found, I hope it will be uselfuness. I have a "geography" dimension and a "multilevel" report like: StateB 182400 ERROR!!! regionc 120000 100%... -
How calculate percent values??
Hi, I try again: my "geographical" dimension contains State, Zone, Area, City, Bricks. My query returns "Sales values" on columns and State>Area>Bricks on rows (not entire structure). I'm trying to show the % values for each level in relation with its previous... -
How calculate percent values??
I execute a query that returns something like : Sales per State (and per cities inside them).(I think) Toppercent is not the best function because I lost information, any idea to show "cities % values" respect its state ( it should show 100)
