TM1 Forum

Although I realise it's not the core function of the QUDEFINE statement, I'm playing about with creating private views for people which are then VUSLICE'd back into a sheet. The issue I'm having is that I can't define where the dimensions go in the view - eg, in a 4 dim cube, the first two indexed dims go in the top half of the view, third dim goes down the left and fourth dim goes across the top. 6 dim has first 4 indexed dims in top half, etc.

Am I missing a function for defining the placement of the dims in the created views? I'd like to stack two dims on the left of the view, etc...

Have got a workaround by QUEXPORT'ing it out and re-importing / formatting but it's pretty inefficient. I'd also quite like the created views that are being created to represent what people will see in the sheet and I can't do that as it requires a bit of manipulation of their private views to stack the dims correctly.

Sure I must be missing something here - any suggestions?

TIA

Why not define the views in TI where you can set subsets for each dimension, define the title dimensions and row and column dimensions and nesting order and then call the process via VBA from excel then haul out the view with VUSLICE? (maybe the only issue with this approach is that the views would be public not private, but you coudl always destroy them afterwards if you wanted.)

Yeah, that thought had occurred to me but it's a very commonly used file, view would be changing almost constantly giving potential precendence issues (although incredibly unlikely, I'd like a zero risk approach) and I want them to retain their view in TM1 privately which wouldn't happen through this method - the main view being used would be changing constantly dependent on the last person to use it rendering it unusable for this purpose.

Also, I have a funny feeling I've come across an undocumented VBA function that deals with nesting orders but can't remember if I'm imagining that or not (much in the same way as the non existant SUBIX function that I convince myself must exist every year or so).