Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

show always all rows although no data in db

Alex1Jun 4 2012 — edited Jun 6 2012

Hi,
I'm using OBIEE 11G

I have to show always same rows in my report.

Example: I have a pivot table, Entity on rows, Months on columns

-----------Jan-----Feb------Mar...----Dec
Entity1
Entity2
Entity3
...
Entity10

I prompt section with Years.
If I select Year=2008 I can see only 3 Entitys (3 rows), if I select 2009 I see 7 Entitys (7 rows)...so I have different rows depending year.

I want to see always all of my entitys (10 rows) and see null values with no data.

Doesn't work If I put "Ifnull" in a measure and change format in measure column with #,##0;-#,##0;0

Any solution about this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2012

Added on Jun 4 2012

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

8 comments

1,210 views