OBIEE 12c Version 12.2.5.9.0. Combinations : DATE is used with between clause and 3 other dimensions are added to filter the data. Never before happen this kind of issues. Template : it is .xdo As said earlier there is no issues with the SQL in DM, for short date range it is working, but when we are expanding selection of…

Yes, I guess it is OAS 5.9. But, can you please help me about 2 questions? Is it correct approach to pull the column?

Thank you Gianni for your response. OBIEE 12c Version 12.2.5.9.0. This is the new column I am adding in the Analysis. Earlier Analysis is working fine. Not sure about Bundle patches.

@Gianni Ceresa Thank you for your help :)

Hi Ben, Can you please try to change it to default from the My Account, Thank you, #Mayur

https://www.rittmanmead.com/blog/2013/04/obiee-odi-and-hadoop-part-1-so-what-is-hadoop-mapreduce-and-hive/

Hi partycrane, I have added the rank column based on the fact and applied the Conditional Formatting. When Rank is one it will applying the conditional formatting for it. And for the total we don't have the option for the formatting. For this I have added Union with the same columns set in the analysis and added again the…

Hi partycrane, Please try with the Conditional Formatting. Thanks, #Mayur

Hi , Please find the below solution, * Select New > Dashboard Prompt * Select the Subject Area * Click on Symbol it will ask what type of prompt you must create select COLUMN PROMPT * Select date column from the Dimension table * Add the following Highlighted settings, Result : Thanks, #Mayur

Hi, Please find the below thread, How to stop auto run of reports in Dashboard You need need to disable the PROMPT BEFORE OPENING in the dashboard properties. Thanks, #Mayur

Hi Viresh, It's working in OBIEE version: 11.1.1.9.0. Not sure about 12c. Thanks. Best Regards, #Mayur

Hi Viresh, Add the dashboard catalog path like, '\shared folder\dashboard_folder\Dashboard_Name' Hope this will help. Thanks. Best Regards, #Mayur

Thanks Christian for your reply. I have achieved it using the JavaScript code. I have added the JavaScript code in the Dashboard and mentioned the path which I have to extract. JavaScript Code is like below, <a href="javascript:void(null)" onclick="return saw.dashboard.exportToExcel('<Report_Catalog_path>',…

Hi, Please refer the following thread, cumulative sum Use the following function like, RSUM(Measure BY DIm.Col) eg. RSUM(Amount BY STATE) Regards, Mayur

I guess we were adding replies at same time and I got little late.. +1 @Christian Berg Yup Joel Added the answer first with the 3 different other solutions. Joel's answer is need to mark as Correct Answer.

Hi Matija, Please archive the Objects which you have to migrate. And unarchive them in them in the Production. Please check the path and Permissions before while Unarchive. https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-E163C218-3E30-4FD8-91BE-DE909B90CC63.htm#BIESG1381 Thanks, Mayur

Thank you Gianni.

Hi, Create Presentation Variable in The YEAR Dimension and pass it in Default Value Selection of Date Dimensions Like,

Hi, In Summary Department Analysis, on value create the Conditional Action links it will Display the report as per value required. for eg, Create Conditional Action link like, Value Department 1 will display the Detailed Department 1 analysis. Thank You. M

Thanks Christian.