Recent Discussions
Guided Reporting Duplicate Param Dialogue Box Showing on Run or Param Change
Hi OneStreamers, I'm currently working with the Guided reporting solution in OS v8.4.0. When running the report in the GDR homepage a duplicate dialogue box appears after the Guided Reporting Dashboard is selected via the OnePlace menu item, once a report is selected, or after a Parameter is changed anytime the Parameter combo box is changed. Each Parameter is set up a Member list at the moment but were previously discovered as Member Dialogue, and now rediscovered as the updated Member list param. Any Idea what I could be missing?rsacco4 hours agoNew Contributor16Views0likes1CommentChange Variables
Has anyone had success with the change parameters (Variables)? I have several reports that all have a simple substitution variable |CVTimeDesc|. When running the book, I would like to change that Variable to predefined text, however, this doesn't seem to be working.CAIGuySeanF4 hours agoContributor3Views0likes0CommentsCell Value Showing "OK"
Hello, I was wondering if it's possible to have a check figure if the amount equals 0 that it displays "OK" and if it doesn't it says "Check Details". I've tried conditional formatting when the cell amount = 0 then "OK", but I figured I'm missing something or this might just not be possible. Thanks, WillSolvedWillVitale9 hours agoContributor1.5KViews0likes10CommentsPage Numbers in Book Reports
I have a book report with multiple Cube views ,Excel ,Word and and PDFs. If all together the book has 100 pages, Is it possible to show the Page numbers 1 of 100, 2 of 100 in sequence? I have tried the Cube View Extender BR discussed in this forum previously and that does display Page numbers only within the Cube view where the rule is attached to and in the format of Page 1 0f 1 ,Page 2 of 2. Page Numbering Format for Books | OneStream Community Appreciate any help or guidance.vmanojrc309 hours agoContributor12Views0likes0CommentsXFGETCELL() with Drilldown - V8
Hi all, I'm 100% certain that I read somewhere that Version 8 would include a new XF function for Excel add-in that would allow us to drilldown on a cell whose data is retrieved via an XF function. However, now that we are upgrading to Version 8, I cannot find any information about that at all. Even a search in the OneStream documentation does not show any XF function that allows this. If anyone has a link or more details about this expanded functionality, would you be kind enough to share that here? Thanks in advancekmd11 hours agoContributor II10Views0likes1CommentGuided Reporting - Multiple Extensible Hierarchy Selection - List Selector Error
I have a Cube View report in Guided Reporting where the user needs to be able to select from anywhere inside of the following three hierarchies. The hierarchies contain extensibility. I am running into an issue where the hierarchies are not appearing correctly, and member are missing in the 'List Selector' on Guided Reporting. I created my parameter to pull the tree views of all three entity hierarchies. I have confirmed that the Cube View parameter selection shows up as expected. When I try to select Entity in Guided Reporting, I see the following: The only items that are showing under the tree views are the members that do not have any extensibility. Output is showing its children, but it is not collapsable to the parent. If I switch the order over the tree views in the parameter, whichever is the last one listed has its members listed out like Output does in the screenshot. I have tried multiple different ways to write the parameter out and have been unsuccessful. Has anyone else experience this issue? Is there any way to get the hierarchies to display correctly? I am having trouble since the code behind Guided Reporting is locked by OneStream. Thank you!bdean2 days agoNew Contributor50Views0likes4CommentsImporting Descriptions/Comments into Reports
Recently, our client requested that the reports display descriptions associated with specific combinations of dimensions. These descriptions correspond to the unique combination of all dimensions and are provided in the data import file. How can we achieve this? Would creating a new dimension be a viable solution? What alternative approaches could we consider? Since the model is already built and this requirement was not initially specified, we're exploring the best way to address it.JoãoRodrigues2 days agoNew Contributor36Views0likes4CommentsTrying to pull data from cube view using label component
I am trying to create a label which needs to display the gross profit in my dashboard. I have created a data adapter (when running the adapter, it's showing the relevant data) and attached the same in the label. But I am not getting any data in label. Can someone help/suggest what I am missing?BhavayMangla2 days agoNew Contributor II21Views0likes0CommentsParent Name using UD8 Formula
Has anyone been able to successfully obtain a parent name for a member, within a UD8 formula without needing to leverage a text field on the member (using Parent Sort Order for example)? As an example, I have a base level entity member of B1229 (this is Branch). I would like to return D1229 - Chicago based on its' parent sort order of 2 (this is District). Appreciate any insight!SolvedBWHITAKER2 days agoNew Contributor II204Views1like9Comments