If you missed the pre-registration for NetApp MS Azure AD B2C, the new login prompt will offer the option to register. Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

OCI Full Date

Nate00

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

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)

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

Public