Skip to Content
author's profile photo crossmen crossmen
0
crossmen crossmen

Exclude values from hierarchy

Posted on Dec 09, 2014 at 08:28 PM 51 Views

Hi All,

I have created a query bex that contains the hierarchy for infoobject 0ACCOUNT

The hierarchy contains 4 nods (nod1, nod2, nod 3 and nod 4)

I would like display just nod 1 by exclude accounts that begin with 2 in this node.


II tried to create a restricted key figure by inserting the node1 and exclude the accounts beginning with 2


But the query display all values in node1.

Can you help me please?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Nanda Anantha
    Nanda Anantha
    Posted on Dec 09, 2014 at 10:03 PM
    0

    Hi

    You can create one more infoobject for cube/dso which ever your using.

    in transfer rule, just write logic for new infoobject = source_fields-account+0(1).

    and

    in Bex report drag node1 and drga new infoojbect with hard code 2 and exclude.

    try this.

    Regards,

    Nanda

    Add a comment
    10|10000 characters needed characters exceeded

    • Nanda Anantha crossmen crossmen
      Dec 10, 2014 at 04:04 PM

      Hi,

      Yes , we have few ways.

      1 Use virtual characteristics :SAP BW BEx Virtual Characters

      2 If your query output is excel(use macros) , Web (HTML , JAVA)

      3 Make report as "Query is used as InfoProvider" , RSRT-->Properties and update infocube.

      Or

      Create APD and update report data to Direct DSO while updating data implement exclude logic

      and again report on top of Direct DSO

      4 Enhance 0ACCOUNT_HIER and new filed in ECC (ex ZFLAG), for ZFLAG flag where node1 and account number start with 2 and restrict X in BEx Query.

      5 Create ZACCOUNT update from 0ACCOUNT hierarchy table through generic extraction , update NODE12 where node1 and account number start with 2, if not update account number as it is and create infoset with cube & ZACCOUNT with join. and do report on infoset so, here data will display where accounts are equal in GACCOUNT and cube, so that by default we never have account number NODE12 in 0ACCOUNT so by defualt we can restrict.

      0Account node ZACCOUNT

      12 node 1 12

      23 node 1 node23

      43 node 3 43

      While join on 0ACCOUNT --> ZACCOUNT, we can get only 12 and 43 ,

      Please try.

      Regards

      Nanda

    Comment on This Answer

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.