How to display no value node in hierarchy

[Former Member]

Hi,

I want to display a node even it has not data in report, but Bex supress the node in default, how can I change this setting?

[Former Member]

Hi Lorin Gu,

Check your displya properties uner query properties.

Query Properties----

---

>Display -

---

>Suppress Zeros

Thanks,

Vijay.

[Former Member]

Hi Vijay,

It's not zero value node, for example, assume there's an account hierarchy in system, one account 'ABC' belongs to this hierarchy, but this account has no key figure value in Cube which my query is based on, then the node which represents this account dispaears in query. Do you have any idea to show it?

Edited by: Lorin Gu on Sep 9, 2009 1:49 PM

[gaurav_kothari]

Hi,

Try using the option inQuery Designer Properties Advanced Tab -> Filter Value Selection During Query Execution -> Values in Master Data Table in.

This will display all the accounts from the master data irrespective of the values in the KFs.

You can do this after query execution also using context menu-> Properties(of the InfoObject Eg: GL Account) Accestype for Result value -> master data.

Regards,

Gaurav

Edited by: Gaurav Kothari on Sep 9, 2009 5:27 PM