Hi,

I have the following query on cube:

select
{[Measures].members} on 0,
{CROSSJOIN([DimDate].[MonthHierarchy].[Month].members,
[DimConfig].[ConfigHierarchy].MEMBERS)} on 1
from [scorecardv2cube]

When I tried executing the above query using SQL management studio with
AS profiler on, first time it fetched 'non-cached' data. When executed
second time, it fetched data from the cache.



WITH
MEMBER [Measures].[abcd] as '([Measures].[MonthlyActual])'
select
{[Measures].[abcd]} on 0,
{CROSSJOIN([DimDate].[MonthHierarchy].[Month].members,
[DimConfig].[ConfigHierarchy].MEMBERS)} on 1
from [scorecardv2cube]

When tried with the second query, it never caches data. Is it beacuase
its a member and always will be calculated on the fly?? Is there any
way to cache such queries?

Basically what are all the ways to enable cube caching to improve query
performance?

Regards,
Gayatri