In the AdventureWorksDW Analysis project I defined a new Action
Name: Filter Sales France
Target Type: Cube
Target : CURRENTCUBE
Expression: "create subcube [Channel Sales] as (select [Geography].[Geography].[Country].&[France] on 0 from [Channel Sales])"
Invocation: On Open
After deploying and process database, when I browse the cube and choose [Channel Sales] perspective I expected to see only the France in the Hierarchy Geography, since I defined the subcube that filters the France country. It seems that the action is not
begin triggered. I also used the Sql Server Profiler and did't see my action statement being emmited to the server.
Am I missing something?
Thanks in advance
View Complete Post