Recent Discussions
Force Excel to store the source number (no scaling) when CV is exported
Hoping someone out there has some ideas on how to make this work... Let's say we have a cube view containing a parameter that allows the user to select a scaling option (millions, thousands or no scaling). The results of the parameter are stored in the CV's default CellFormat. Currently, when the CV is run and exported to Excel; regardless of the scaling selected by the user, the display in Excel is in thousands and Excel stores the entire number (unscaled). For example - if scaling selected is millions: If the number is 345,773,247.11; it displays in the CV as 346, it displays in Excel as 345,773 (but the stored number shown in the formula bar is the correct source value: 345,773,247.11). In other words, regardless of whether user selects thousands, millions or no scaling.... Excel displays as thousands and stores the correct number. If I try to change the Excel format to display in any other way (i.e. millions), it will store the scaled value based on the format and no longer stores the full number. This happens even if I force ExcelUseScale=False. The goal in this exercise is to figure out a way to "display" the exported CV in Excel exactly as it appears in the cube view but still retain the whole number. Using the above example, I would like to see this result: CV Displays 346 Excel Displays 346 Excel stores 345,773,247.11 Is this even possible? I have tried multiple ways to make this work including manual formatting, XFBR, parameters, etc., but I still can't determine the exact combination of formatting options that will result in what I want to see. Would love to hear if anyone has found a way to accomplish this. Thanks
XFGetMemberProperty
Hi Team, How does XFGetMemberProperty works in Excel AddIn? The fields in the formula I have are - MemberNameorScript PropertyName VaryByCubeTypeName VaryByScenarioTypeName VaryByTimeorTimeDimProfileName I want to pull the properties for Text 1 to Text 8 from OneStream Production for Entity, for different Time Periods like Default, 2023, 2024 and 2025. Now the properties I pulled at Default are giving correct result. But when trying to pull at year level like 2023, 2024 and 2025, I am not getting the correct data. It is only showing the data present at Default. But in OneStream Prod, I do have data in 2023, 2024 and 2025 for the Text Tags. In my formula, I was setting VaryByTimeorTimeDimProfileName = "2023". And so on for 2024 and 2025 I am getting the same thing for XFGetMemberPropertyVolatile formula as well. In OneStream my year values are stored in 'Stored Property Value' Can someone please help me here ?
Conditional Formatting in Cube view on Annotation members
HI, I am looking for an option to highlight text value in the cube view based on some condition. I have combo box which has parameter which pulling value from one of the DIM Member 1 = United States Member 2 = Canada Member 2 = Not filled If its not filled then I want to highlight red. Is there any option. I tried using XFBR but seems like it run on specific data unit onlyFormat Cube View based on third Header Override expansion
I am using header overrides on my columns to create three column expansion levels. I need to add conditional formatting based upon the header display text of "HPU" in this third expansion so that only sections with "HPU" in the header are set to three decimal places. I do not want to build every HPU column separate from the others, as this would require the build of 108 columns, instead of 12 columns. The system will not let me call that third expansion level in my conditional formula. Any help would be greatly appreciated!
Issue with navigation using button on mobile device
I am having issues with my dashboard appearing on my iPad after clicking through one of the buttons I created (going from one DB to another). It seems to work properly within the application on my PC but when I navigate on my iPad the next page goes blank. I made sure the naming convention I want to navigate to is correct. Is this a potential bug that this doesn't work on mobile device? Here is the button property I used for navigation:
Modifying QuickViews
Does anyone know how to add another row or column level dimension to an existing QuickView? The rebuild button in the Panel doesn't seem to be activating or changing anything. Can you please show me how to do it properly? Also doesn anyone recommend any beginner video tutorials, there doesn't seem to be much online.
Dashboard Tab Layout
Hi OS Community, I’m revisiting our key reporting dashboards and wanted to check if there have been any updates to the tabbed layout functionality. Since our dashboards pull large datasets from BIBlend tables, we’ve used button components as tabs to avoid long load times caused by the tabbed layout preloading all content at once. Has there been any change that allows us to restrict data loading when opening a dashboard, or is our current approach still the best practice? Thanks!How do I return description to XFBR from a multiselect prompt?
We are using the multiselect tool to gather certain entities for reporting, which will show up in rows in a cube view. We're returning to the cube view the values from the multiselect via an XFBR. When the user chooses the entities, we can't get the resulting members in rows to show as description, only as member name. Anyone know how to return the description in a cube view/report?Can a button control two parameters simultaneously?
I have a button on a dashboard that needs to change the values of two parameters with one click of the button. Is this possible without building an XFBR? The "Bound Parameter" property implies it can only control one. Placing a comma between two parameters in this property does not acknowledge the second parameter.
