I have a use case where my base application i.e. SalesDashboard has large set of records(for10 Regions data) which has low performance with N printing reports distribution.
I want to create 10 new apps each for one region and contain data only for corresponding region so now I will have 11 apps, one is SalesDashboard(Base app) and SalesDashboard (Region1), SalesDashboard (Region2).....SalesDashboard (10) and I will make 10 N printing connection with each application for specific region and distribute the reports.For how it will help me, for distribution report by N printing for one region I do not need to fetch data from base application which has all the records.
I can do this by duplicate the base app to 10 news apps and put filter as Region='Region1' but this will be very old fashioned or I can say manual approach.
What solution I am looking, I reload by base app SalesDashboard then automatically(QMC or any how) reloads 10 applications for each region.
Can you please help me what is the best way to do it.
1. There are two kind of apps in ODAG Selection and Detail
2. When we SELECT any value from filter and click on generate app, new app DETAIL will be generated in which the selected value(Dimension value i.e. Region) is set or fixed.
3. I can reload generated or DETAIL apps from SELECT and DETAIL apps will refresh with same value filter will be there i.e. Region1 for first detail app, Region2 for second Detail app...so on.
4. I don't need to generate the apps again, just reload it and new data will be there.
5.No automate task reload for ODAG is available yet.
6.ODAG generate apps or DETAILS app would be generate in stream or My Work section.
1. There are two kind of apps in ODAG Selection and Detail
Correct
2. When we SELECT any value from filter and click on generate app, new app DETAIL will be generated in which the selected value(Dimension value i.e. Region) is set or fixed.
Correct the selected value is passed into the script of the detail app and is added to the SQL WHERE clause, the app is reloaded and published
3. I can reload generated or DETAIL apps from SELECT and DETAIL apps will refresh with same value filter will be there i.e. Region1 for first detail app, Region2 for second Detail app...so on.
you can generate any number of detail apps with different filters
4. I don't need to generate the apps again, just reload it and new data will be there.
No to get the latest data (any new records) the app will need to be regenerated/reloaded
5.No automate task reload for ODAG is available yet.
Correct
6.ODAG generate apps or DETAILS app would be generate in stream or My Work section. Correct
