Embedded 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
CV Spreading
Hello, We want to spread data acrross multiple periods in a cube view, so we select the parent member (Year) and we expect that automatically OS applies spreading to all its base time members (months). However, we are working on a forecast scenario with the setting "Number of No Input Periods Per WF Unit" set to 4. And we don't understand how the spreading works. It seems the system calculates the difference between the amount entered at the parent member (Year) and the total amount of the closed months (the no input periods), and this calculated amount is the one that is saved at the parent member (Year), instead of the amount enetered initially. Could someone help us to clarify this calculation? Thanks!How to populate a Dashboard List Box referencing WFText4 but the UD dim may vary across Workflows?
As the title suggests, I am trying to populate a dashboard list box that references the Workflow text property regardless of the dimension being used. I'm able to populate the list box using a single dimension, meaning a UD3 member is populated on the workflow's WFText4 property and a member list parameter uses |WFText4| to pull it in. How would I get this to work if the Workflow text value is not always UD3? For Example (both workflows will be using WFText4): Canada Workflow A needs a UD3 Member.Base to populate in the list box when they run the dashboard in their workflow but Canada Workflow B needs a UD6 Member.Base to populate the list box when they run the dashboard in their workflow. Please let me know if I can provide more context.
Narrative Reporting Issue
Hello! Has someone tried Narrative reporting in 9.1 version? I am currently experiencing issues: 1.- Inserting charts/Advanced Charts / Reports if someone could insert an exaple on how they have done it. 2.- I cannot vie the artifacts and acces them, this message keeps popping up (and the names are fine) Thank you so much for the help!!
Reports - Column Width
Hi Everyone, I recently developed Flux reports for my organization, I'm encountering following issues. When I type comment on the 'Comment' column, if the comments is of say 100 words, the red line which I marked in the screenshot keeps moving to the right. refer screenshot below. How can I fix this issue? I use, V#Annotation for Comment column. 2. When multiple users, try to update the comments, the comment from the last save is only visible. Could you please advise how can i overcome this? thanks in advance
Display Parameters of Embedded Cube View
OneStream Community, I am having difficulty applying visible parameters after embedding a Cube View in Excel. When I embed the Cube View and select "Use Display Value" the parameters appear but the parameter member list drop down is misaligned to the applicable parameter. Additionally, when the Cube View connection is removed and re-embedded without selecting "Use Display Value" on refresh the cube view shows an object reference error, but then after selecting ok the cube view will render with no issue. Has anyone come across this?
Create Excel Book
Hi, I am trying to create a OneStream Book that contains data in Excel format instead of PDF from a dashboard component. Currently, the book uses a dashboard report component to generate a .xfDoc.pdfBook containing the data, which Parcel Service then attaches to a list of emails and dispatches in a zipped folder. I attempted to create a book that retrieves the data from the same dashboard component but in .xfDoc.xlBook format. However, every time I run the Parcel Service to dispatch the file in Excel format, the Excel file is blank. Could you please advise if there is a way to obtain the same data in the Excel attachment as we have in the PDF attachment? Thank youCube Views - Nested Dimensions - Fill in all rows
Hi Everyone, I have received a request from the business regarding a cube view report where they wish all the rows to be populated with the dimension member. For example in the screenshot below, they would wish to see "Entity 1" populated for all the lines in the second column of Largest Clients. I am not sure if that is feasible unless someone has found a way. Thank you in advacne for your response. RegardsOneStream Power BI Connector - Optimal Performance
Hi All, Has anyone used the OneStream Power BI Connector to pull millions of records and found the fastest way to do it? I’ve been asked to use the .TreeDescendantsInclusive member expansion in the Get Cube Data function for a few dimension members, but this is making my query run very slowly. I was previously just using the .Base member expansion and could pull about 5 million rows in 20 minutes. To avoid the 2 million row limit, I created an M Query that loops through specific dimensions and splits the calls into smaller queries. This included several historical periods, and doing an incremental refresh for 1–2 periods didn’t take long. Here’s a screenshot of part of my new query using .TreeDescendantsInclusive. My issues now are: The queries eventually fail because one of them hits the 2 million row limit, because I cannot easily loop through some of the new expanded dimensions It takes an extremely long time to query and load data into their Power BI data model as I am now pulling an estimated 30 - 40 million rows at once Is there a way to optimize what I have so that it doesn't take a long time to query data, or is this just how the connector works? Thanks!
