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

Base member syntex in input template

Dear BPC Friends,

I have to pull the BASE member of around 30 PARENT member using EPMDIMENSIONOVERRIDE function. I know the syntax for this is BAS(111),BAS(222),BAS(333),BAS(444).........etc.

So my question is, can I use syntax BAS(111,222,333,444).... etc. or is there any other syntax to pull the base member of 30 parent member using EPMDIMENSIONOVERRIDE function.

Kindly advice,

Thanks,

Rahul

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2015 at 11:54 PM

    Hi Rahul,

    Do you have one node that is higher than 111, 222, 333?

    You can use that node instead of all 30 parents.

    Andy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 26, 2015 at 04:57 AM

    Hi Rahul,


    Is the 30 parents members are fixed or some logic is there for pulling the members apart from base members? If 30 parents are fixed then why you are using override?


    You can directly use from edit report, simply select 30 parent and choose relationship as base members.


    If my assumption is wrong about selection of base members then, kindly provide more detail about reporting structure and override logic.

    Or

    You can you use Andy's suggestion, if you have higher node for your 30 parent members.




    Hope this will help you. 😊


    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.