I have created several reports to show capacity and performance but I am having a hard time custoimize the date range in the OCI Reporting Chart. Currently I am using "[Advanced Data Mart].[Date Dimension].[Full Date]". This give me around 9 Months of data. How would I go about limiting this to say 30 days or 90 days? I have tried using some of the functions to no success.
1 REPLY 1
If you are pulling data from a query, do the following:
select (fields) from (table)
where table.datetk = date_dimension.tk and date_dimension tk >= (select tk-30 from date_dimension where latest = 1)