Active IQ Unified Manager Discussions

OCI Full Date

Nate00
2,133 Views

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

stephen2
1,995 Views

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)

Public