4 Replies Latest reply: Jun 8, 2011 7:46 PM by 859358 RSS

    Analysis type workbook question - multiple tabs to one cube?

    777079
      Workbooks are composed of worksheet(s), and a workbook can be associated with an Analysis type in IOP.

      In the IMP demo, the analysis type workbook is linked to multiple cubes, one worksheet per cube.

      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?

      Is it possible to set up multiple worksheets, each displaying a different measure set, but have them connected to a single cube?

      Client has an existing process which would require navigation to a specific intersection, and has no desire to put all of the measures they need on one worksheet, (they are used to one measure per worksheet and don't want to change what they do), so we're talking like a dozen worksheets here.

      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.

      Thank you.
        • 1. Re: Analysis type workbook question - multiple tabs to one cube?
          809363
          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?

          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.
          • 2. Re: Analysis type workbook question - multiple tabs to one cube?
            754537
            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.
            • 3. Re: Analysis type workbook question - multiple tabs to one cube?
              599500
              Can we exclude a particular dimension while creating planning sheets.

              regards,
              Venkat
              • 4. Re: Analysis type workbook question - multiple tabs to one cube?
                859358
                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.