Active IQ Unified Manager Discussions

OCI Full Date


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.


Re: OCI Full Date


If you are pulling data from a query, do the following:


select (fields) from (table)

where table.datetk = and date_dimension tk >= (select tk-30 from date_dimension where latest = 1)

Earn Rewards for Your Review!
GPI Review Banner
All Community Forums