Yes it is possible, there are formatting options to accomplish this; however, formatting applied to a row definition will apply to all members within that row definition. Another option is to import the relevant data or view into a Dashboard Componen...
Answer Reverse descendants and reverse children options will accomplish this. Source: Office Hours 2020-05-17 Partner Enablement
Answer Yes, if you would like to see the children members at lower layers of account structure you can for example: “children.children.children” to accomplish this. Additionally, you can leverage text values on the members you’d like to retrieve and ...
Answer Yes, default report formatting for Cube Views, PDFs, and Excel can be set in a number of different places. Application Settings – Sets default formatting across the entire application Cube View Settings – Sets the formatting specific to the cu...
...For example, center months across six columns. Answer: This is now available in PDF reports from 7.1 and in Data Explorer from 8.2.
Answer Standard Microsoft supported fonts are utilized in OneStream Source: Office Hours 2020-05-17 Partner Enablement Update 07/02/2024 Note that one can use any font that has been installed in Windows on the OneStream servers. The interface only li...
Answer They cannot be deleted as long as there are audit records that go along with the Cube View even if the data has been cleared. To clear this you would be required to run a reset scenario, however this clears out all workflows and data. Typicall...
Answer Text wrapping is not currently available within a Cube View itself. This functionality is offered in Excel or within a grid view component showing next to the data explorer then set word wrapping on the grid view within a dashboard. Source: Of...
Answer This can be found under cube view properties > Formatting > header format. Source: Office Hours 2020-05-17 Partner Enablement
Answer This can be overwritten on the report itself by utilizing the alternate language descriptions within the report settings. This will force the language/culture of the report. Source: Office Hours 2020-05-17 Partner Enablement
Answer Although this is possible either by loading the file via a dashboard or calling the SQL text in memory via the business rule itself, it is not recommended as it violates the audit trail functionality within OneStream as no changes to the rules...
Answer No, you will need to define multiple row definitions to accomplish this but you will not be able to keep the expand or collapse definition. Source: Office Hours 2020-05-17 Partner Enablement
Answer Currently, there is no way to keep blank rows when toggling the suppression settings. A workaround for this would be to hardcode a number in the member filter of a row. The screen shots below show how to hardcode “.0000001” for all cells in th...
Answer If there is a consolidate elimination, there is an elimination finance type that can be utilized. You can utilize a set data cell, set data buffer, or api.data.calculate inside the finance rule. The api.data.calculate is similar to hs.con. Sou...
Answer Whoever is hosting the cloud environment will be able to assist with anything that needs to be installed on the server. If OneStream is hosting the environment, a ticket can be put in with support for specific requests. Keep in mind, the custo...
Answer There is an extensibility rule in GolfStream (XFR_ExportAppMetadata) that can be run to perform the extract. An Extensibility Rule can be called by a Data Management job which can be set up for automation by using PowerShell or REST. The data ...
Answer There are custom rules that can be applied to prevent this from happening. Please submit a ticket with RCS for help with this issue. Source: Office Hours 2020-04-23 Partner Enablement
Answer You can sum YTD through the view but not by days in a month, unless you have the days in a UD member. Source: Office Hours 2020-04-23 Partner Enablement
Answer You can use an XFBR Rule to dynamically pull back a range. This can be useful when the workflow time is set to a range.If you have a set amount of months that need to be returned you can utilize the T#POV.Prior function. T#POV.Prior12 = Prior ...
Answer Write a calculation on the member filter of the dimension member. You need to sum all the prior years together in the calc. Source: Office Hours 2020-04-23 Partner Enablement
akloepfer
