Intersting behaviour of subset
Posted: Tue Apr 16, 2013 12:33 pm
I found interesting behaviour of subset which sometimes can be useful but alas it doesn't last long. May be somebody know how to elongate it.
So I have simple hierarchy and Cube based on it After it I create Cube with this dimension
After it I make all elements in hierarchy detail level But funny - when you look at view of Cube
you see that subset looks like hierarchy If I save that subset I see in .sub file
It looks nice for such case - when you want to show such sort of pseudo hierarchy for users
But unfortunately if you restart server all illusion is disappearing (you can see only one level elements) although .sub file is the same one.
May be the way exists to save such behaviour of subset in cases of restart servers.
So I have simple hierarchy and Cube based on it After it I create Cube with this dimension
After it I make all elements in hierarchy detail level But funny - when you look at view of Cube
you see that subset looks like hierarchy If I save that subset I see in .sub file
Code: Select all
283,100
284,Subset2
11,00000000000000
274,
18,0
275,
278,0
281,0
270,7
Regions
Region_lev1 Regions
Region1 Region_lev1
Region2 Region_lev1
Regions_lev2 Regions
Region3 Regions_lev2
Region4 Regions_lev2
But unfortunately if you restart server all illusion is disappearing (you can see only one level elements) although .sub file is the same one.
May be the way exists to save such behaviour of subset in cases of restart servers.