Data Infrastructure Management Software 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)

Check out the KB!
Knowledge Base
All Community Forums