Please respond

Any alternatives for this.

The OBIEE version: I have been working on this since 6 months, there was no issue.

Thanks for the information. Will follow the dimension modeling rules.

There is a second level of logical table sources (Products_new, Years, Sales_Year). Please refer above, previous response. I have created two dimensions and a sales fact for summary at year level. Year table have year_id and year and year_id is primary key. There is no mapping in BMM layer for fact table timeid column. But…

Hi, Please find the physical layer and BMM layer diagrams: I have created summary table for producing monthly data for the product. Physical layer: BMM Layer:

Hi, The following physical query from log file. WITH SAWITH0 AS (select sum(T1400.QUANTITY_SOLD) as c1, sum(T1400.AMOUNT_SOLD) as c2, T1400.PROD_SUBCATEGORY_DESC as c3, T1400.CALENDAR_MONTH_DESC as c4 from MONTH_SALES_AGG T1400 group by T1400.CALENDAR_MONTH_DESC, T1400.PROD_SUBCATEGORY_DESC) select D1.c1 as c1, D1.c2 as…

found solution.

some one help is most appreciated..

Any suggestions please.

Hi, I just need to change the format of all the date columns to dd/mm/yyyy in all reports in the catalog. I think it will not effect the date calculations (in column formula) and report level filters on date. Will it change all date columns formatting, once i change on a particular date column formatting in a report and…

Hi, Thanks for the reply. As per my understanding Save as System-wide Default Option- I think the third option will work for all the date columns with catalog will change, once i change in a particular report date column formatting to dd/MM/yyyy and set it to 3rd option in the above screen shot. Please confirm. Regards,…

Hi All, The only problem is when export this report with multiple sections (Supplier), the formatting in excel becomes very difficult. Please advice how to go about this. Regards, Chandra.

Yes, i have tried this. Fixed formatting is not showing in the report result.

Please explain me "Grant access to your user on 'Save System-Wide Column Formats' Option"

Yes, user has "Save Content with HTML Markup" privilege.

Hi, OBIEE Version: Oracle Business Intelligence 11.1.1.7.150120 Regards, Chandra

I am not understand what you are saying. Please detail me.

HI all, In rows i have the following columns. I am unable to understand how to have a FLAG at row level to check if there is a single negative value for any period then display the whole row. Please suggest. Regards, Chandra.

Hi All, I am attaching screen shot with actual scenario. In above report result the measure column "-units" displayed for monthly data. For the formula written: CASE WHEN '@{PV_Negative}{ALL}' = 'ALL' THEN "Analysis"."- units" WHEN '@{PV_Negative}{ALL}' <> 'ALL' THEN CASE WHEN "Analysis"."- units" < 0 THEN "Analysis"."-…