Moving Views

[winsonlee]

I am trying to move views from a cube to another cube. Both cubes is having 5 dimensions. One of the dimension in the cube is different. Cube A is having CustomerA dimension and Cube B is having CustomerB dimension. Both the dimension is having the same N element the only different is the consolidation element. Will I be able to copy the vue file from Cube A view folder to Cube B view folder and change the dimension name on the text file from CustomerA to CustomerB ? will that work ? Would like to hear some feedback if you have any experience or done this before.


thank you.

[jim wood]

The view files themselves contain information about dimensionality and the subsets selected. The only way You could get this to work is if you have indentical dimensions or you could try hacking the view files.

[Martin Ryan]

Try it and see. The worst that will happen is that the vue files won't open, in which case you can just delete them.

[winsonlee]

I have tested out. Majority of the view structure still remain the same except that some of the element selected at the title view isn't very accurate. Like for example if Period dimension having a drop down list of Jan, feb, mar, on the actual cube mar is selected, but when i copied over to another cube it is selecting jan instead. I am not too fussy about it as it has already save me some time of creating a view as I am already having the overall structure of the view.
But just out of curiosity to find out if there is any part in the vue file that mention which element is selected. the following are the info that i found on the vue. It only mention about the dimension and the subset used. But at the subset, there are 3 elements and at the view of the actual cube it is actually selecting mar. But when it is copied over to another cube, it is actually selecting Jan.

7,Period
6,Default

[rmackenzie]

But just out of curiosity to find out if there is any part in the vue file that mention which element is selected. the following are the info that i found on the vue. It only mention about the dimension and the subset used.

The data that defines which title elements are selected is given where you find the property code 373. E.g.

Code: Select all

373,3
1
1
4

Which means - there are 3 dimensions on titles (see property code 374 for which ones); the first dimension has the 1st element of its subset selected; the second dimension has the 1st element of its subset selected; the third dimension has the 4th element of its subset selected.

It sounds to me as if the subsets you are using on the Period dimension (which are defined independently of the view and thus outside of the .vue file) are different in their content and order.

..or you could try hacking the view files.

Yes, you could do this. I guess you need to deal with the issue that you have two different customer dimensions and that the line reading 7,CustomerA should read 7,CustomerB in the other cube.

Really, it sounds as if you need to be migrating the .sub files (subsets) used in the source view along with the .vue file.