Skip to Content
avatar image
Former Member

Creating Continuous Periods for a given range in Web Intelligence Report

Hello All,

I have a need to show all months even though there are no transactions available for every month. My inputs are Start Month and End Month (201601 - 201612). But sicne not transactions available for these period I display only a few columns (201601, 201604, 201609, 201612). But I would like to generate 12 different values like 201601...201612 and display values only where there is a match for the rest of the dummy months I will display 0. Is there any way to do this web intelligence cross tabs?

Thank you,

Arthur.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 17, 2017 at 04:36 PM

    If you have some date object then you can use TIMDIM & MonthPeriod function to generate continuous dates.

    https://blogs.sap.com/2014/12/03/demystifying-the-timedim-function/

    other option is to add one more webi query and select Month object only and add the same date range prompt condition in this query.

    Merge both the Month object and use in the crosstab.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 17, 2017 at 06:19 PM

    Amit,

    I already have the time dimension, which is merged with my model to generate the various dimensions of date/time. Yes I can create additional query and display only the month for the prompt and it will return 12 months. But if I merge with the transaction data-month (which I have only for 5 months) with Query2-Month (though it brings 12 months) after Merge will I not get just what is available in the transaction data? (I have tried it and this is what I get when the Merge dimension is used)... It is almost like an outer join result what I should use in my cross tab... (My transaction data is not there for some months, so for missing months I should have 0's or I should create them ins some other way..

    Any other ideas?

    Query1 Query 2 When Merge Dimension applied

    201601 201601 201601

    201604 201602 201604

    201609 201603 201609

    201612 201604 201612

    201605

    201606

    201607

    201608

    201609

    201610

    201611

    201612

    Thank you,

    Arthur.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 17, 2017 at 08:01 PM

    Amit,

    Yes it may give the result I am looking for, Since I did not have enough time. I have changed (not technically) and added the entry I wanted with another group and got the result I am looking for. I believe what you suggested should work.

    Add comment
    10|10000 characters needed characters exceeded