Recent Discussions
Looking for Input: XFGetCell vs. Cube Views in Excel
Hi everyone, I’m looking to get some input from the community on Excel-based reporting in OneStream. In your experience, which format has proven to be more efficient and reliable: XFGetCell formulas or Cube View connections? The reason I’m asking is that we use OneStream reports to feed data into Excel workbooks, and we’re getting recurring feedback from users about performance issues—slow refresh times and, in some cases, Excel crashing. For context, these workbooks usually contain multiple tabs and often include a mix of: Cube View connections Quick Views XFGetCell formulas (used when a specific layout is required) Our goal is to better advise users on the best reporting approach. So far, it feels like this mixed setup is becoming heavy and is negatively impacting the user experience. If you have any best practices, lessons learned, or tips on what works best (and what to avoid), I’d really appreciate you sharing them. Thanks so much in advance! Eve
Task Manager Dashboard Configuration
I have to create a task manager build that does not include weekends in the duration. We have tried adding the weekends to holiday profiles and excluding them from the explicit day map, but the duration will always include the weekends. Right now, I have due dates on weekends an holidays even when calling them out in the Holiday Profile and setting each one with an offset of 1. Is there a work around for this or any other solution to have the durations skip weekends/ due dates not be due on weekends or holidays?
Narrative Reportings Extensible Docs
Hi, I need to provide a demo for a customer who is exploring using Narrative Reporting. I am using the Termplate to create the Root/Section/Document structure. Can anyone provide me with the Extensible docs that are associated with the template and imported into NR? Displayed in green below: It would save me a lot of time and effort. Many thanks Guy
Cubeview: Cell type Date Format
Hi everyone, In my CubeView I have a cell defined with the Date data type and I would like to force its display using the number format dd/MM/yyyy, However the format never changes and is always displayed as MM/dd/yyyy, probably due to the US culture settings. Do you know if it is possible to override this behavior? I assume it should be since multiple date formats are available. Thanks, NicolasEmbedded dynamic repeater
I have a cube view with a parameter on Entity |!Entity_select!| that I would like to put in a tabbed dashboard that has one tab for specific Entity member. I am using dashboard type "Embedded dynamic repeater" where the component is data explorer report. Data explorer report has data adapter component to the Cube View. I thought the way to do this would be to use the template parameter values in the collections. But it shows error as attached below. It seems that the template parameter value was not passed to Entity_select parameter. Is data explorer report component compatible for dashboard embedded dynamic repeater? Is there any sample of Embedded dynamic repeater dashboard using data explorer report component? TIA, Nuryana
Publish a Document in Narrative Reporting
Hi Team, We have an issue in publishing the document in the Narrative Reporting. while Publishing the document, it is saving under respective user folder. how to publish a document in share folder or any group folder. Can you please help us resolve the issue. Thank you, Shiva Prasad
Data formatting GridView
I have tried multiple ways: Literal Perameters, Column Formatting, Data formatting to try to format GridView cells. I have some decimal data coming over. it is formatted as $#,###,0;($#,###,0);$0 I cannot get it to Horizontal Align Center, Negative Text = Red. This is really agitaitng. Trying to align my data, show Negative Values as Red. Thank you in advanced
