i agree with u that when v use Dimension object its drilling all the levels.
and for me if i have year dimension i can drill down till yyyy/month with my present code...
and if i use the columnObj.drilldown property its working properly.
ok say A and B r objects and am doing
Set B = A
if i...
thats my question drlex...am using Column.Item.Children to access the children of the column obj in my code.
but still am not getting the column's children obj if the level where it lies is above 4
drlex tanks for ur code its the one which i wanted.Its working fine
u told that i dint change to the child of each level in the dimension thats the reason it dint drill down.
so can u tell me how to do that
am writing a macro in PowerPlay to extract the hirarchy structure of a cube. The problem which am facing is that the column obj is not drilling down after 4 levels even though it can be drilled-down.
plz help me
here is the code...
Declare Function Tree_Extractor(PPCol as Object)
Sub Main()
On...
i did recurly but it dint work...
i found some other way...
I could get the column object and drill down to the lower level there by ctreating the hierarchy but the problem which am facing now is
say if "Total Copany" is dimensioin_1 & "Total Period" dimension_2 when i do...
help in powerplay
I have to compare the dimensions of 2 data cubes manually...is there a way to write a macro to extract the dimension tree hierarchy so that i can write a code to compare cubes automatically
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.