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

Update Rule

Hi ,

I have one info object in Tranafer Structure , Applied Transfer Rule based on 5 info object and derived the addition of those 5 and stored result in Transfer Rule . That info object is in Key Fig tab of Cube .

Now in Cube i have one Info Obj Char , Which do not have value in Comm Stru , But i need to caluate based on The Transfer Rule Applied that info object Tota Value .

How can we do it ? Is it possibe ?

Consider Transfer Rule Applied info object = ' Total ' .

Now i need to writr update rule based on this Total , To update field ' Grade '

So i click on Info Obj char ' Grade ' In update Rule , Create Routing , Now in

Result = ?

What shoud be given ?

Total or Grade .

Kumar

Add a comment
10|10000 characters needed characters exceeded

Related questions

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 09:03 AM

    Hi Kumar,

    There is only one ENDIF if you use ELSE IF.

    The syntax is like this:

    The last statement block is always terminated by ENDIF.

    IF ( <condition1> ). 
    
    <statement block1>
    
    ELSEIF ( <condition2> ). 
    
    <statement block2>
    
    ELSEIF ( <condition3> ). 
    
    <statement block3>
    
    .....
    
    ELSE.
    
    <statement block4>
    
    ENDIF.
    

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 08:06 AM

    Result = comm_structure-Applied.

    Use the right neme of infoobject for Applied.

    Hope it helps.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 08:20 AM

    HI ,

    Can i use Nested If conditions

    IF Comm_stru Eq -


    Condition 1

    Else If Comm_stru Eq .....

    Condition 2

    Endif .

    Can anyone give syntax ? Becaues nested if it shows Error

    . Needed after Else

    Kumar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 08:30 AM

    Hi Kumar,

    Yes. You can have nested "IF" loops. But make sure you dont have too many of them as it affects the performance.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 08:09 AM

    Hi Kumar,

    Each info-object would have a RESULT so for Grade you need to specify the "Grade Value".

    For example you can define for "Grade" routine something like this:

    IF COMM_STRUCTURE-TOTAL < 40.
    RESULT = 'F'.

    Hope this helps.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 08:38 AM

    Dinesh ,

    Can you give simple syntax of using condition like checking a range

    Eg : IF A > 10 and < 20 .

    Else if A > 20 and < 30 .

    ENDIF.

    How to brinng this in Routine ? This syntax answer will solve my Problem ?

    Kumar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 08:52 AM

    Hi ,

    Why we need

    ELSE IF.

    IF .

    This is equal to

    If

    endif.

    if

    endif .

    Is this necessary , <b>In other languages the syntax is like this</b>

    If Cond 1

    else if Cond 2 to Cond 3

    elseif Cond 3 to Cond 4

    elseif Cond 4 to Con 5

    else Exceptional condition

    endif .

    Kumar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 09:08 AM

    Thanks Dinesh . Assigned Points .

    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.