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...
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...
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.
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%...
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...
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)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.