Skip to Content
avatar image
Former Member

Expanding column dimension (TIME on column) based on range in BPC 10.1 Classic

Dear Experts,

I have a requirement where I need to expand TIME dimension (on column) based on range.

e.g: I know start and end months I need in input template viz. 2017.01 and 2022.09

I want to expand all the members within this range in input template.

This start and end date is user input and can keep on changing.

Is it possible to achieve this in EPM Excel?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 27, 2017 at 12:29 PM

    You can do something like:

    Assuming that you have TIMEID correctly set for base members (no TIMEID on Parents!)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 01, 2017 at 11:29 AM

    Thanks a lot Vadim.

    The solution worked.

    Add comment
    10|10000 characters needed characters exceeded