2 cubes or one?

[Jeka]

Hi Guys, would like to get your opinion if possible.

Got one cube, need to have additional fields and tables  added to the cube.
Also the current cube does not have the lowest detailed level for Dimensions (Account numbers, etc.)

Cube was created for users for AS but now we have complex requirements for Report Studio Reports!

What should i do in order to see the lowest level of accounts in the cube but keep in mind the users cannot see the lowest level.

A. Create Another cube with almost the same data but add the lowest detailed level.
B. Combine cubes (what would i do about lowest level than)
c. Your recommendations


Thank-you and  have a great weekend!
Paul

[josepherwin]

Create just 1 cube with the lowest detail, and create custom views and assign user roles on who can/cant see the lowest level.

[Ty Clabbers]

First you should think twice if you really should add the lowest level for a dimension to a cube. If you still think it should be added, you should think again. Most of the time a cube isn't the correct source where you should store the lowest level of detail.
Also, complex report studio use wont work great with a cube. I have seen some weird results with that combination.