Skip to Content
author's profile photo Neha Yadav
0
Neha Yadav

Fetch different time columns dynamically in bpc report

Posted on Jul 23, 2020 at 10:50 AM 62 Views

Hello,

We have a BPC report with TIMES as the driving dimension. I want to fetch this time period in one column of BPC report and in the next column I want to fetch last year time period. Eg. Current year is 2020.07 then next column should have 2019.07 and I want this to be dynamic? Is it possible to do it in BPC ? I am trying to include this in the same report. Below is the report structure:

Regards

Neha

reprot-structure.png (4.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Vadim Kalinin
    Vadim Kalinin
    Posted on Jul 24, 2020 at 08:34 AM
    1

    It's so simple:

    Symmetrical means that if you have 2 categories and 2 times then you will have 4 colomns with all combinations of category and time.


    timeov.png (17.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Vadim Kalinin
    Vadim Kalinin
    Posted on Jul 24, 2020 at 03:45 AM
    0

    You can always use EPMDimensionOverride to present 2 time members - one from context and another - calculated by Excel formula.

    But as a result you will get a symmetrical report.

    Add a comment
    10|10000 characters needed characters exceeded

    • Neha Yadav
      Jul 24, 2020 at 07:21 AM

      Thanks for revert!

      Can you elaborate symmetrical report ?You mean I will have to create 2 separate reports ? I want this to be done in the same report.

      With EPMDimensionOverride formula how do I pass 2 values for same dimension ? The excel formula will override my context value also then

  • author's profile photo Alan Guillermo Valenzuela Amezquita
    Alan Guillermo Valenzuela Amezquita
    Posted on Jul 23, 2020 at 08:02 PM
    -1

    Use a local member to bring the previous year, here is a link with some examples of how to use local members.

    Local Members - Examples

    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.