Does a Cognos feature is also available in BO?

[former_member210662]

Hi Experts

A friend of mine said that we have an very nice feature in Cognos that I would like to implement in my solutions in BO, actually this feature it's something that happens automatically when you are visualizing the dimensions in your database,. the Cognos hides the dimensions with no values in order to reduce the objects in the screen.

Would we have such option available in BO? Such as Webi Reports?

Thanks

[Former Member · Accepted solution]

Do you mean auto-hiding columns?

Rows with no data can be automatically hidden or not as defined within the report.

Two links for auto-hiding columns:

http://www.forumtopics.com/busobj/viewtopic.php?t=169664

http://www.forumtopics.com/busobj/viewtopic.php?t=168137

Regards,

Mark

[Former Member]

Hi Rody,

Do this, select Object properties in Web I Query Panel and in Limits place check the check box of Max Rows retrieved and is set to zero. so you can retrieve 0 rows in report level.

All the Best,

Madhu....