Exclude values from hierarchy

[former_member298288]

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?

[ccc_ccc]

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

[former_member298288]

Thank you Nanda,

But if i would like add two nodes (for example node1 and node2) ,all accounts begining by 2 will not be display .

my goel is exclud value juste frrom node1.

[ccc_ccc]

Ok,

While writing logic for new infobject read node1 and concatenate and update

like

NODE12 (Node1(hierarchy) and 2(account) )

Regards,

Nanda

[former_member298288]

Hi,

There is a waye in BEX query , without touching ODS or cube?

Thank you.

[ccc_ccc]

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