1 Reply Latest reply on Sep 15, 2017 2:35 PM by kenbrown

    One Story, Multiple Workbooks

    Bernadine Wood

      Is it possible to create one story, or dashboard, from multiple workbooks?  I have several tables of data that I am having to join together to get different types of data.  I was hoping to create different workbooks for different types of data (ie: student vs. finance) but would like to include all of the worksheets that come out of these different workbooks into one story.  Is this possible?  I just don't want to have to join all of the tables that have this different type of data together in one workbook.  I'm not even sure that the right fields exist so that I can. 

       

      We are using ODS and Banner.

       

      Thank you!

        • 1. Re: One Story, Multiple Workbooks
          kenbrown

          I am not aware of a way to have a story span multiple workbooks but I have dealt with a situation where I have multiple workbooks with dashboards that relate to a single theme or department. For example, dashboards and worksheets that are Admissions related but are in separate workbooks for the same reasons you state - overly complicated data joins or other considerations. In several cases like this I have created what amounts to a dashboard of dashboards - essentially a dashboard driven from an excel spreadsheet that contains labels and links to the specific workbook dashboards that I want to see combined into a common navigational view. I created a workbook that has a dashboard with 2 areas in it. On the left is a navigation panel that has links to the workbooks that I want as part of the theme and then a large fixed area to open the workbooks into when the links are clicked on. So for you you could have on the left several Stories listed and when each on is clicked on it would open into the larger window. You get all of the features of the standalone work book but in a common context essentially bringing the workbooks to the user, not forcing them to go to them. One of mine looks like the following where the workbooks you want to get to are on the left and they open on the right. Not exactly what you are looking for but it might be of use in certain situations.