Recent Discussions
XFGetCell() + XFGetCell() gives incorrect result
statement 1: gives zero which is correct =VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "F99", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE")) statement 2 : gives value which is correct =VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "FNONE", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE")) statement 3: gives incorrect value =VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "F99", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))+VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "FNONE", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE")) This works correctly in 8.4, but not after upgrading to 9.1
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
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, VolkerHow 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.
Excel Errors (V8.4.1)
Hi, A user is facing two issues with Excel add-in. XFGetCell and XFSetCell formulas with XFGetMemmber Property are used (XFGetMember function only at the top of the page). There are 15 sheets in the Workbook page. Has anyone experienced issues described below? What is the likely solution? Is it V8.4.1 specific issue? Thanks in advance for any help/pointers. Two issues: (1) Retrieval formula dont work and have to keep refreshing the whole workbook/worksheet. When refresh one worksheet, the rest will went error. When refresh another sheet, previous sheet went error. (2) When trying to save an offline version of retrieval file but error keeps pop up as attached.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
