on 05-03-2016 10:32 AM
Hi Experts,
I have 3 years (2016, 2015, 2014) of monthly sales data based on 15 Stores coming from a relational database. It was modeled in SAP BO IDT and SAP Lumira consuming the data through SAP Universe Query Panel. Where i am stuck right now how to show three years of sales data by month on the column chart as well as the average of the 2015 year sales only. How can i accomplish this task?
Thanks in advance.
Note :- The dotted line is of 2015 average sales data.
Can you model the average sales back in the IDT? It is best to do the calculations (where possible) in the backend
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Pawlas, thanks for the reply. We do know that majority of the complex calculations should be done at the backend level which will become part of the SAP BO IDT obviously. But with respect to Language Scripting Model, the scripting language of SAP Lumira should be strong enough to handle this kind of scenario. Let suppose, if the calendar year moves to 2017, definitely users will be needing 2016 Average Sales, so again we have to build that part in the backend, refresh it in IDT and bring it again by editing the Data Source in SAP Lumira. I hope, i am able to clarify what we are looking for.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.