11 Replies Latest reply: Aug 8, 2017 8:14 AM by Andrey Khoronenko RSS

    Multiple Data Model for Single App

    zahid Rahim

      Dear Experts,

       

      We have multiple data models for different modules like Sales, Financials. Now we want to develop a single App where we want to develop a single dashboard where data from different modules/data models can be displayed.

       

      Is this possible and how?

       

      Regards,

       

      Zahid Rahim

        • Re: Multiple Data Model for Single App
          vikas mahajan

          Hi ,

           

          You can use Binary Load all data modules in single QVW file. Make changes as you required and build another data module using this.

           

          Vikas

          • Re: Multiple Data Model for Single App
            Jonathan Dienst

            You will need a load script that merges the data from each of the modules. You may want to partially aggregate the data (and perhaps reduce the dimensions) for the dashboard to keep it to a manageable size. The fact tables could be concatenated into a single fact table with a source type field specifying the module from which the data comes. Then you can load the original or reduced dimension tables tables.

             

            Your expressions would then use the source type field in a set expression like

            Sum({<Source = {'Sales'}>} Amount)

            • Re: Multiple Data Model for Single App
              Mark Ritter

              As Vikas said you could put a Binary load statement at the start of your script that will load the script from another app.  Then add your code for the 2nd app.

               

              Depending on your data you may end up with synthetic keys or other issues with the combined data models.  They may not associate either if they should unless you do some manipulation.

               

              Another option is just to copy the script from app 1 into app 2 and then make whatever changes you need.

               

              The approach really depends on the complexity of the scripts and what you want to end up with.

              • Re: Multiple Data Model for Single App
                zahid Rahim

                There is only one data source.

                 

                Now i have an APP with the name "BI" with data model for 2 tables A and B which is creating analysis. Now i want to create entirely a different query using 2 tables Y and Z which should show analysis on the same one Single APP with the name "BI".


                • Re: Multiple Data Model for Single App
                  Andrey Khoronenko

                  Hi Sadasiva,

                   

                  Forgive me for possibly an absurd question. And what is the need to combine modules into one application? What is the goal pursued?

                   

                  Regards,

                  Andrey

                    • Re: Multiple Data Model for Single App
                      Sada Siva

                      Hi Andrey,

                       

                      It's not mandatory to combine these modules into one appilication.

                       

                      Simple thing was users want to see those modules KPI's in one application. They don't wanna use multiple applications. It depends on the client requirement.

                       

                      Thanks,

                      Sadasiva

                        • Re: Multiple Data Model for Single App
                          Andrey Khoronenko

                          I understood. Our experience has shown that simply combining individual applications into one is not a grateful event.If a single application were developed at once, it would clearly differ in structure from the simple sum of the modules of individual applications. In addition, if the functionality of a single application does not change, what will the customer pay for? If, in the single application, an extension of the functionality is supposed, then all the more can be talked about the development of "from scratch" and in the process to use the developments of individual modules if possible.

                          But all this must be discussed with the client.

                          This is a purely personal opinion. I'm sorry if I'm wrong.

                           

                          Regards,

                          Andrey