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

Script Logic - REC into a dimension property dinamically

Dear Experts,

I write to you to ask if you can share your knowledge regarding how to solve a little problem in Script Logic. Let me state the case..

I have a model where two dimensions should be "linked" (COSTCENTER ENTITY). The relationship of each is somewhat as follows:

COSTCENTER n -- 1 ENTITY

Each COSTCENTER has a property (ENT) which states what ENTITY it is part of.

I have a situation where I need to allocate a set of COSTCENTER of a single SEGMENT into different COSTCENTERs and ENTITYs. Is there a way to obtain dinamicaly the ENTITY from a COSTCENTER when I write back into a REC statement? I had the following idea but it is not working...

*FOR %CC% = %COSTCENTERS%

*REC(FACTOR = SomeDriver, COSTCENTER = %CC%, SEGMENT = [COSTCENTER].[%CC%].Property("ENT"))

*NEXT

Is there a way to achieve this?

Thank you all for your time and help!

Best regards,

Joaquin.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 13, 2015 at 08:58 AM

    And by the way, can you explain the business logic of what you want to achieve? Not the script logic code, but some sample with figures and result How To: Ask questions about Script Logic issues

    Vadim

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 13, 2015 at 07:00 AM

    Hi Joaquin,

    If you want to write the result of rec into some member contained in the property of another member then:

    The current member has to contain the required property value!

    *REC(FACTOR=SOMETHING,SEGMENT=COSTCENTER.ENT)

    In this sample for current COSTCENTER the ENT property will be used as destination SEGMENT.

    Current - means current record during when/endwhen loop execution!

    Vadim

    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.