Intersting behaviour of subset

[EP_explorer]

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

01.JPG (5 KiB) Viewed 2622 times

After it I create Cube with this dimension

After it I make all elements in hierarchy detail level

03.JPG (4.72 KiB) Viewed 2622 times

But funny - when you look at view of Cube
you see that subset looks like hierarchy

04.JPG (22 KiB) Viewed 2622 times

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

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.

[Martin Ryan]

That's an interesting effect. My guess is that it's based on something in the .blb formatting file for the view. Does the effect still happen if you create a new view? Or does it only happen with existing views?

I would say this is a bug rather than a feature and I wouldn't expect you to be able to retain it over server restarts in the normal course of events. While I can see it might be handy in some instances I think it would generally be a bad thing rather than a good thing.

Martin

[EP_explorer]

If I save the subset I can use it in new views and it works - until I restart server of course