Is it possible for PDF Formatting to underline each row?
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 Component of type Report, which (from version 6.3) allows for WYSIWYG "pixel perfect" editing of reports. This functionality is also available in Report Studio for older versions.Question: Is there a way to see individual account layers within a hierarchy?
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 then filter on the text values to pull these members within OneStream. Source: Office Hours 2020-05-17 Partner EnablementQuestion: Where and how can default formatting be set for reporting purposes, is there a way to format “Empty” to retrieve “0” instead?
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 cube view (overwrites Application settings) Rows and Column Formats – Sets the formatting for specific rows and columns Cell Formats – Sets the formatting for a specific cell For number specific formatting to be standardized you can change the application wide settings under application settings à Number Format. To get zeros instead of blanks select the “ #,###,0.00;(#,###,0.00);0.00” format Source: Office Hours 2020-05-17 Partner EnablementIs there a list of valid font families for Cube Views?
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 lists a subset of fonts produced by standard Microsoft libraries; but in recent versions any font can be invoked simply by using the FontFamily formatting property: FontFamily = [My Custom Font Name]Is there a way to delete deprecated workflows?
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. Typically, deprecated workflows are placed under a deprecated parent workflow and the security changed so that only admins can see these deprecated workflows. Source: Office Hours 2020-05-17 Partner EnablementIs it possible to wrap text in a column header and change its width within a Cube View?
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: Office Hours 2020-05-17 Partner EnablementIs there any other way to get an alternate description for a member other than using UD8?
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
