I will try this one as well and we have approached another way like adding year ago wid in day dimension. @Regis Peregrin Thank you

It did not worked out @Regis Peregin .It does not allow to add like that The starting Point of Period rolling function is larger than the End point.

Christian Berg & @Gianni Ceresa

Christian Berg , Is there a way that I can restrict to display 2013 Q1, 2013 Q2, 2013 Q3, 2013 Q4 only once during the start of the quarter. I also tried the above way but period is displaying multiple times.

I want to reiterate the issue @Christian. We already had a time dimension If I added Period the data is summing up and showing as month wise data, But I should show up Graph with date and X-axis Label like period.

Thank you @Gianni Ceresa. Now, the it is connecting to the database.

TNSNAMES.ORA file is not available in that location. I have manually added but it did not worked out.

H @Jerry Casey For Example: I have date records from 2019 May to 2020 DEC. There will be no filters in report. When I execute report it should pick Current date Mar-12-2020 and it should populate till 12 weeks(MAR-MAY results) + 13 week(Rest from May to till DEC) it should fall in 13th bucket.Before Mar-2020 (i.e 2019 May…

Hi @Jerry Casey, Thank you for the immediate response. I can able to achieve it from the above logic, The thing is that I did not have any filters on report but whenever a report executes it should display the Current_date + 12 weeks data + 13th week data.For suppose I just added Award Date greater than 12/4/19 which it…

Hi @Jerry Casey, I have misinterpreted the logic. For Example If Award Date is 1/9/2020 the week data 5766239.14 value should fall under 5 - Jan Bucket which is a Sunday Label.(It should fall under Previous Bucket). The logic should be implemented with Current_date & Award Date.I want to display only 12 weeks from Current…

I have used below formula in report. EVALUATE('REGEXP_REPLACE(SUBSTR(%1,1,%1-4),''[0-9]'',''X'')||SUBSTR(%1,-4)',"Order Details"."Credit Card Number") - syntax is working fine. But it is populating data as '0.00' in front end report where as If I executed the back end code in database it is giving expected results as…

How can we implement this at RPD Level ? I have Dimension table W_STATUS_D - Created two alias 1. W_STATUS_D_Generic Date, 2. W_STATUS_D_Latest_Date and Fact table W_MXD_F. I joined the two alias tables to fact table with common column Status ID. In BMM Layer I created One logical table with Two LTS (which are alias of…

Thank you @Jerry Casey, I have removed the Null and it is not populating duplicate columns.

Hi @Jerry Casey I have added the same case condition and noticed that it is causing null values in data, I tried to keep filter as List price is not null where it is giving error Oracle Error code: 934, message: ORA-00934: group function is not allowed here at OCI call OCIStmtExecute. It is populating duplicate values will…

Hi All, Thank you for the response. We are planning to implement Oracle apex. Thank you, steel.

Even I have implemented the same logic. Thank you @Jerry Casey.

Hi @Gianni Ceresa, Thank you. I will check and update you.

Hi Gianni, Particular dashboard is the Custom Dashboard. I am not going to change the OOTB dashboards. I want those colors to appear on Custom Dashboard only.The above three methods which I google from different blogs. Those code are worked for them. None of the codes did not worked out for me. The dashboard consists of 15…