Recent Discussions
Page Breaks in Excel add-in
We are having an issue with users and page breaks in the excel add-in. Example 1: A user creates a cube view connection and pulls said cube view into an excel worksheet. The result, however, does not render all the rows. There is a page break and they are forced to page through to see the rest of the rows. If I replicate these actions, I do not get the same page break, my results render all the rows on a single page. No page breaks. We went through preferences and other excel settings together to make sure our settings matched. What is causing this to happen? What other things can we try to resolve? The user must have all the rows displayed at once (no page breaks). Example 2: A user creates a quickview only to have the results get cut off with a page break. If I replicate the quickview, the return does not cut off the rows. I get everything on the sheet. Any hints, tips, etc would be most appreciated. We are trying to determine if this is a OneStream issue? Microsoft Issue? Excel Settings? For reference, we are on OS 9.0.1. thank you in advance
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!
Narrative Reporting setup Issue
Hi Team, In our system Narrative Reporting setup has done, but when we open Narrative Reporting. could not able Fetch and Load and anything. seems like everything is empty(below screenshot are for your reference). Can you please help us to setup the Narrative Reporting in the system.
Table view marks all numeric columns as dirty
Hello, I have a table view where I also allow users to save changes. In my code I'm checking for the cells that have changed using "If tvr.Item("Bonus").IsDirty()". This seems to work fine for non-numeric columns, however, I find that for the numeric columns the cells are always marked as dirty even if they are not changed. I tried different things, e.g. marking the column as decimal data type "tv.Columns(7).DataType = XFDataType.Decimal" but so far no luck. Do you have any advise how this can be solved? Thanks, VolkerReport Books - Dashboard Chart
Hello, I have an automated report book and would like to expand the functionality to include charts (in addition to the existing cubeviews). I was able to add the chart, but I'm struggling with trying to control the formatting. I would like to modify the header and have the chart fill the page (too much white space). See below. Thanks! Is there a way to format the chart output, in particular I would like to enlarge the chart image and have it stretched across the page?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!!
