on 04-24-2015 12:59 PM
Hello dear experts,
I got a question regarding data modelling with time.
The request is to report on data which is based on a time interval:
Example Data:
Char 1 From To Value KF1
A 01.01.1000 31.12.2003 10
A 01.01.2004 31.01.2004 20
A 01.02.2004 31.12.9999 15
KF 1 is non cumulative.
The Query should look like this:
Char1 Dez 13 Jan 04 Feb 04 Mar 04 April 04
A 10 20 15 15 15
KF 1 is non cumulative,
The time dimension in the Query is flexible, so the user can select as many month to display as he likes to.
So my only idea to solve this is to bring the data on a "month snap shot" level before
For this I would need to create one entry for each month within the intervals. Since it is a lot of data I´d rather not do that...
Does anyone of you have an idea on this how to do it better?
Thank you very much in advance,
kind Regards
Oliver
Hi Oliver,
Is the monthly snapshot on a fixed day of the month, or any possible day?
Perhaps you could maintain good month and day relation in the cube, user can input time range for the query, this range is used as 'characteristic restriction' in query definition. Then drill down month with master data access. In this way you could get a dynamic monthly snapshot in this range.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Oliver,
Here is my piece of thought. Not sure how feasible it is for you.
Create a info object copy for Char A with valid from, valid to and your kf as attributes. Mark the kf as time dependent. Load the master data ( Since the kf is non cumulative.. you may have to do this from your data provider ) and then use the kf attribute in your report.
Try to leverage the time dependent MD functionality.
Let me know what do you think.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi - thank you for your thoughts.
In deed, if I only had to display the KFs this would be feasible. Since I have to calculated with those values it´s a little more difficult.
We already did some kind of scenario with a KF as attribute and used a reference varaible to use it in the query. Unfortunately this lead to strange effects why we decided not to use this concept anymore....
So what I´m going to do is - create SNAPSHOTS of the data for each month.. this will mean a lot of data but will work for sure...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Would you try creating a join between calmonth (year+month) and your object.
The out put of your infoset should be multiple months from the calendar and associated KF's.
As long as month is in query you will not see aggregated KF, it again depends on how you defined the KF and and exception aggregation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.