12-06-2022 05:51 AM - last edited on 05-24-2023 12:28 PM by JackLacava
1.How can we use the below member filter in red colour inside XFCELL. How can we use it?
XFCell(Cb#GolfStream:E#[NA Clubs]:C#USD:S#Actual:T#2022M1:V#YTD:A#69000:F#None:O#Top:I#Top:U1#Top.base.where(Text2 contains '|WFYear|'):U2#Top:U3#Top:U4#Top:U5#None:U6#None:U7#None:U8#None)
2. How can we use GetDataCell(A#A100+A#200) inside XFCELL to calculate some expression.
Thank you!!!
12-07-2022 06:39 AM
XFCell is only able to retrieve one cell at a time, given a precise POV; you cannot use expansions there, nor calculations. If you want to use expansions and calculations, you need a Cube View. Have a look at the section "Presenting Data With Extensible Documents" in the Design and Document Guide (or search for it in online Help) for how to embed CVs in Extensible Documents including Excel.