I'm trying currently to build some reports with historical data:
1 for the SAN-Storage for a specific host which have a size bigger than some value x
1 for tha discovered Storage Arrays
Both should be able to present historical data up to the current date.
What would be the best datamart(s) to be used? The Inventory, which holds only current values is it not. I was looking into the package "Storage and Storage Pools" but there I'm somehow not get the data like I want. (Either it is already aggregated in some way, or I do not get the historical data). Unfortunatly the Cognos Error-Messages are not really helping to look for the Issue.
For the first Case, I did find a solution with a hand-crafted SQL, but there I can't generate a graph out of it, I'm stuck with 'No Data found'.
A couple of thoughts on how you might troubleshoot this:
Make sure [Full Date] is a data element in the query to which you're applying the filter. Use the query editor screen to set it up, if you're not doing so already.
It's going to be difficulut to get maximum([FullDate]) to do what you want, or at least it has been for me. You might try specifying an "over" clause on the Maximum function, otherwise it will calculate maximum([FullDate]) on each line so every line will be included. If you can't get that working, use the current date instead of maximum([FullDate]). If you're reaching back 18 months, this should be close enough.