Page 1 of 1

Intersting behaviour of subset

Posted: Tue Apr 16, 2013 12:33 pm
by 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
01.JPG (5 KiB) Viewed 2625 times
After it I create Cube with this dimension

After it I make all elements in hierarchy detail level
03.JPG
03.JPG (4.72 KiB) Viewed 2625 times
But funny - when you look at view of Cube
you see that subset looks like hierarchy
04.JPG
04.JPG (22 KiB) Viewed 2625 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.

Re: Intersting behaviour of subset

Posted: Wed Apr 17, 2013 12:05 am
by 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

Re: Intersting behaviour of subset

Posted: Wed Apr 17, 2013 7:00 am
by EP_explorer
If I save the subset I can use it in new views and it works - until I restart server of course