ROK
Gets the value of a KPI (Key Performance Indicator) and displays it. The KPI can be displayed as a value or a graphic. The OLAP Server database must allow this function.
Syntax
=ROK("Database Alias", "Cube", KPIName, KPIType, [elements of
the slice])
Example
=ROK("AdventureWorks","Finance","Return on Assets",0,"[Account]. [Account Number].[All Accounts]","[Date].[Fiscal].[All Periods]","[Department]. [Departments].&[4]","[Destination Currency].[Destination Currency Code]. [All Destination Currencies]","[Organization].[Organizations].&[2]", "[Scenario].[Scenario].&[1]")
Related topics