|
发表于 2014-3-16 00:05:39
|
显示全部楼层
Hi !
It depends if you want to filter on an element of a dimension or a value in the cube...
For examle, if you want to filter on "China" in dimension "Country", you wan write {[Country].[China]} on cell B11.
And in your fomula TM1RPTROW, you can write :
=TM1RPTROW($B$12;"yourserver:Country";"";"";"";0;$B$11)
If you want to filter your active form with a condition of value in a cube, you can use the method explained by schlemiel29.
But be sure referencing all dimensions (except country) in the filter...
For example :
If you have a cube "Cube_Sales" with 4 dimensions : Version, country, Product, and Indicator
If you want to filter you active form with sales > 0, you must write :
Filter(
TM1FilterByLevel(TM1SubSetAll([Country]) , 0)
,
[Cube_Sales].(
[Version].[Actual 2012]
, [Product].[Product1]
, [Indicator].[Sales]
)
> 0
)
You can't write :
Filter(
TM1FilterByLevel(TM1SubSetAll([Country]) , 0)
,
[Cube_Sales].(
[Indicator].[Sales]
)
> 0
)
Regards, |
|