Announcement
ABCRecent Activity
Dimensions Descriptions via PowerBI connector
Hi, does anyone know how to get the dimension descriptions (other then default) into PowerBI via the OneStream PowerBI Connector? In the OneStream PowerBI Connector, there is the "Get Dimension" part with an "include descriptions" option but it only loads the default description (which is english in our setup). We have also a German culture setting and all descriptions are setup in English and German but I cannot find a possibility to get the German descriptions in PowerBI. Regards MartinSummary: The remote server returned an error: (502) Bad Gateway
Hello OS Community - We are running into below error while trying to load 1 + million records from SAP via connector business rule. Tried with all the options on Cache Page Size limit, at present it is set as below. We did not have any luck so far. Any recommendations or guidance is much appreciated. Summary: The remote server returned an error: (502) Bad Gateway Thanks.
Load to Multiple Scenarios?
Is there a way to load to multiple scenarios from one Workflow? Example, from the below Workflow POV, I want to load to the Actual_PP scenario, but also to the Forecast_PP scenario. I don't want to create a new workflow for forecast because I want to use the values from People Planning that have been calculated for Actual_PP to populate both scenarios. I don't what to load the People Planning register twice and calculate it twice.Service Factory - Data Management Step
We're moving most of the Business Rules to Workspaces Assemblies under PV 8.4. - We have several Extensibility Rules that are run by multiple Data Management (DM) Jobs like you. - Hence, we included separate DM Step Services (DMSS) in the same Service Factory (SF). - The result of this SF setup was chaos. - We saw that launching one DM Job by a given DMSS in the SF will also launch other DM Jobs by their DMSS in the SF. We couldn't find enough practical advice on the SF/DMSS setups in the Design Guide to overcome this chaos. Pls share how to set up Data Management Step Services in a Service Factory to launch one Extensibility Rule/DM Job at a time. TY.
Numerical Order: Cube View Accounts (MFB)
Hello, Is there a way to sort accounts in numerical order using the member filter builder? Need to see trial balance in numerical order based on account name (i.e. A#12345, A#98765, etc) using the hierarchy. It would help as well if we could apply alphabetical sorting as well for the accounts which start with names. (i.e. Investment Other, Autos, etc). Thank you in advance,
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
Write an amount
I am having difficulty writing an amount to a prior month via a Finance business rule. Specifically, for forecasting purposes in the last month of a quarter we calculate an excess amount and then want to spread that amount to the last two months in the quarter. I can successfully calculate and write to the last month but cannot seem to write to the prior month. For example, in Q2 as of June calculate the excess amount and then write 50% in May and 50% in June. Has anyone been able to accomplish something like this? Thanks in advance.
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 ?Cube View formatting
Have a question regarding Cube view formatting. The client has a column for comments where large commentaries are written point wise which currently are seen as one line. They want to view the same like excel where comments are seen point wise one below another. How can the same be done. Also while exporting the report in excel the wrap text option in the Column cell format under excel only wraps the entire cell but it does not show the comment point wise one below another
