Reducing size of the XFGetCell function

[MarcR]

The XFGetCell function has 20 arguments, when you have a large sheet (e.g. for data validation) there can be many of these functions increasing the size of the excel file.

In SmartView it was possible to create 1 cell with commonly used arguments and reference that cell at once. In OneStream i'm not able to do so. 

Off course i cannot imagine that SmartView has a feature that OneStream doesn't so i probably need to change my syntax a bit. Hope you guys can help.

So instead of:

=XFGetCell(TRUE, "Finance",$A274, "",F$4,F$14,F$5,F$2,$C274,$D274,F$3,$B274,F$6,F$7,F$8,F$9,F$10,F$11,F$12,F$13)

I want to create a cell (lets say A1) that has the content:

TRUE, "Finance",$A274, "",F$4,F$14,F$5,F$2,$C274,$D274,F$3,$B274,F$6,F$7,F$8,F$9,

So my formula would look like:

XFGetCell($A$1, F$10,F$11,F$12,F$13)

Unfortunately the function put double quotes around the cell so i get the whole string as my DisplayNoDataAsZero parameter and the next few down, missing many parameters (see picture below).

[PeterFu · Accepted solution]

Hi Marc,

I think you are looking for the @XFGetCellUsingScript formula. See print screen below. My formula is picking up the Cube in B1, the POV from B2, entity in A11 and time in C8.

Peter

[MarcR]

Hi Peter, that was exactly what i needed! Thanks.

Do you know if there is a performance impact of using this function versus a regular XFGetCell?

[PeterFu]

Sorry Marc!

I do not know what the performance impact are on these 2 different approaches.

Peter

[OS_Pizza]

Hi @MarcR , Were you able to check on the performance?

Thanks

[MarcR]

Hi Manish, we did not compare it 1 to 1 but have quite a large sheet which performs well so my current assumption is that there is no performance issue using this approach. Let me know if you find out differently.

[gbftong]

I used this solution as well and would like to add you don't need to call out every dimension.  If you omit, I believe it behaves like QuickView and assumes the default POV.