CODEWITHSUNDEEP
mdxolapiccube
Mathias Philippe
Mathias Philippe

Reputation: 145

icCube Schema Refresh Time

I'm using icCube Web reports and I'd like to display the refresh time of the cube but could not find how to do it. I guess there's a way using a dedicated MDX statement but could not find any reference in the documentation. Any idea how to do it?

Upvotes: 3

Views: 228

Answers (1)

Marc Polizzi
Marc Polizzi

Reputation: 9375

The MDX function SchemaRefreshTime gives you this information. So you can use a "Simple Table" widget with a "Plain MDX" request:

with 
  member [Measures].[Schema Refresh Time] as SchemaRefreshTime(), 
         FORMAT_STRING = "j:HH'h'mm"

select [Measures].[Schema Refresh Time] on 0 from [Sales]

The FORMAT_STRING is using a Java simple date format.

Upvotes: 3

Related Questions