Skip to Content
author's profile photo Former Member
Former Member

Data Modelling - Time interval in Query

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2015 at 01:39 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on May 15, 2015 at 12:11 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 18, 2015 at 03:56 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

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

  • Posted on May 18, 2015 at 07:34 AM


    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.