2018-01-12 09:08 AM
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.
2018-01-23 01:04 PM
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)