This content has been marked as final. Show 4 replies
I don't see any reason why you wouldn't be able to create multiple sheets within a single workbook/analysis type that all point to the same cube. Did you run into problems with this?1 person found this helpful
Of course an alternate approach would be to just create different measure sets within the same worksheet. There are even ways to control which measures are displayed by hierarchy level.
Don't have an answer to your bonus question, but I don't believe there is a way to do what you want =( At least not in planning worksheet land. With reports, you can do whatever you like. There you can have complete control of the data via vb.
Usually clients set up one worksheet per cube to do their analysis in, but is there anything that says they can't have multiple worksheets to one cube?You can have multiple spreadsheets attached to the same cube.
Is it possible to set up multiple worksheets, each displaying a different measure set, but have them connected to a single cube?yes.
Bonus question: Linking the navigation so that if they select a specific dimension member in one worksheet, the other worksheets at the same level browse to that specific dimension member as well.Not currently. Each planning spreadsheet is independent. You can do more with VBA, but that will be a consulting activity.
Can we exclude a particular dimension while creating planning sheets.
No, because the data being displayed is for a coordinate. It does not make sense without of the axis.
You could hide the column in excel though, if you want to fix the hidden dimension to a particular member, e.g. default member, and dont want users to navigate.