I have a fact table that join with time table on AS_OF_DATE column. My fact table have partitions on AS_OF_DATE column. When user create an analysis, I want them to filter by month name but in SQL generated it must be filter by AS_OF_DATE column (so partitioning could work) so I set AS_OF_DATE as descriptor id column of…

Thanks but this will generate unwanted SQL query. When OBIEE generate SQL, I want the Date column will be in the Where clause so I can use partition. That's why I use date column for Descriptor ID of month name column so user can select month name on analysis and SQL query will have the date column in where clause.

Thanks but that's no help. I already set up as they said.

In my case, a date does uniquely identify year-month period so I think I can setup that way. About the display problem that I mentioned above, do you have any idea?

Now I understand. Thank you.

I know that upgrading to 11.1.1.9 or higher would work, but I also want to know the limitations of viewing chart in PNG format. Can you list some of them?

I want to change to PNG because I want to view reports on mobile (which web browsers like Firefox or Chrome do not support Flash).