The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
XFDoc - PPT dynamic calcs
Hello, Is it possible to add dynamic calcs (UD8 member) into an XF doc powerpoint? I am trying to create an XFCELL that uses a variance member in UD8. However, I keep getting 0 as the value. Also, ...
Thanks! Is there a way to pass parameters into it as well? I can have parameters stand alone in the ppt, but not within the xfcell. Your copying and pasting method worked for getting the UD8 member to return, but if I replace let's say the time member with a parameter it only returns the XFCELL string like so: XFCell(Cb#ProtoCube:E#Group:C#Local:S#Aug 07_12 FCST:T#2023M5:V#Periodic:A#AEBITDA:F#EndBal:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#Top:U8#ActualvBudget, Culture=User, NumberFormat=N0, DisplayNoDataAsZero=True, Scale=0, FlipSign=False, ShowPercentSign=False, UseApostrophePrefix=False)
No problem! Passing a parameter into the XF Cell is possible as well. In your example, you would insert your parameter name into the XF Cell after the "T#". Remember to use the correct syntax for parameters (with pipes & exclamation points):
XFCell(Cb#ProtoCube:E#Group:C#Local:S#Aug 07_12 FCST:T#|!your_parameter_name!|:V#Periodic:A#AEBITDA:F#EndBal:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#Top:U8#ActualvBudget, Culture=User, NumberFormat=N0, DisplayNoDataAsZero=True, Scale=0, FlipSign=False, ShowPercentSign=False, UseApostrophePrefix=False)
When you process and open the document from the file explorer, you will be prompted with the parameter in the XF Cell.
Once a selection is made, the PPT will open based on your selection.
Hmmm that's what I tried - I had this as the original upload: XFCell(Cb#ProtoCube:E#Group:C#Local:S#|!Select Rolling Fcst!|:T#|!Select_BaseTime!|:V#Periodic:A#AEBITDA:F#EndBal:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#Top:U8#ActualvBudget, Culture=User, NumberFormat=N0, DisplayNoDataAsZero=True, Scale=0, FlipSign=False, ShowPercentSign=False, UseApostrophePrefix=False)
Then when I select the parameters from within OS it returns: XFCell(Cb#ProtoCube:E#Group:C#Local:S#Aug 07_12 FCST:T#2023M5:V#Periodic:A#AEBITDA:F#EndBal:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#Top:U8#ActualvBudget, Culture=User, NumberFormat=N0, DisplayNoDataAsZero=True, Scale=0, FlipSign=False, ShowPercentSign=False, UseApostrophePrefix=False) instead of the value.
When I copy and paste the value from the cube view it works. Almost as if it can't do both parameters and be a dynamic calc within ppt.
Appreciate your help and quick responses!
- JackLacava
OneStream Employee
The problem is spaces in your member name. Place square brackets around your parameter, e.g. S#[|!Select Rolling Fcst!|] and that should work.
