cancel
Showing results for 
Search instead for 
Did you mean: 

Data Modelling - Time interval in Query

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

giselle_lin
Active Participant
0 Kudos


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.

Former Member
0 Kudos

HI Giselle,

thank you for your reply.

the snapshot would done based on a fixed day i.E. last day of month.

I do not clearly understand your suggestion here...

Thanks

Oliver

0 Kudos

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.

Former Member
0 Kudos

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....

Former Member
0 Kudos

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...

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hey Eriki,

Thank you for your answer.

I tought about Infosets, but since I have 3-5 SPOs to get all the information I need, I believe this is not a feasable solution...

Any other ideas?

Thanks

Oliver