OneStream Platform Forums

Hi, I am loading periodic data and in some periods there are derived amounts (due to no periodic data for some periods).  The YTD values appear as derived data.  However, the parent entity isn't rolling up correctly because the parent is not including the derived amounts of the children. What is the most straightforward / best method to include the child's derived value in the parent value for the entity to correct this?  (I am ok with storing the children's derived values, but not sure of best method for that, either.)Thank you! 

Hi,Report Title is hidden in CV Extender but can it be collapsed?Using above code it is hiding Report Title, But it is consuming too much space, Is there any way to Remove / Collapse / Eliminate CubeView Report Title using CubeView Extender Rules. Any solutions would be Helpful.Thank you

Hello, I have a problem with a couple business rules running at the wrong times from within a dashboard.  The background: I have a business rule that changes the formatting of the buttons on a dashboard to show which one was clicked last. The buttons function as "tabs," each linking to a report; the button linking to the currently selected report shows itself as highlighted. To do this, I have the name of the current active button stored in a literal parameter. When a button is clicked to launch a report, a business rule rewrites the value of this literal parameter. (An XFBR String rule then reads this parameter to determine how to format the buttons, and is output to button - formatting - display format). The problem: When I launch the dashboard from OnePlace, the highlighting works correctly, showing a set of buttons with the first button highlighted. When I click another button, the button works correctly by launching a report, but the first button remains highlighted. The li

Hey all,We are trying to creating a toggle button so that the dashboard will render based on the selection. We have 4 Scenarios and we want to compare those but the scenarios will be selected by the end user at run time and s/he can change the selection as many number s/he wants.I have tried to achieve this via Checkbox but that is not working as expected for multiple users as the literal parameter gets updated every time.I tried radio button as well but it looks like so many option (buttons) on the dashboard. Do anyone have any other suggestions on this? Below are layout images on both tries we done. Radio button (first image) looks best but as mentioned above not working as we want too.   

I have a dashboard with a button component in which I have a XFBR String which alternates between two colors for the button's image background when clicked. Similary, I would like to be able to alternate between two images for my button when clicked. Is this possible with a XFBR String at all ? I thought I could return the image's file name with a XFBR String under Image URL Or Full File Name   or can XFBR Strings only be used under Display Format ?

Is there any way to get the cube view profile and Group Name of the CubeView using Business Rules?Thanks.

Hi, Did anyone have any situation when they deleted a DM Job by accident? How can you retrieve that? There's no Orphaned area for DM jobs for us, unfortunately. I can't find any back up for it. Would save us a lot of time if we avoid rebuilding it. Thanks in advance. Regards, Irina

Hi Team,I wanted to insert a text to data cell (for example 'Add comment'). Is it possible to be done by using api.data.calculate?This is how I see this:Dim Comment As String = "Add comment"api.data.calculate("V#Annotation:A#xxx:F#xxx:O#xxx:I#xxx:U1#xxx:U2#xxx:U3#xxx:U4#xxx:U5#xxx:U6#xxx:U7#xxx:U8#xxx=" & Comment) Thanks a lot! 

Recently I heard in these forums that FDX methods (like FdxExecuteCubeView) should be used from a BR whenever the performance of the data is critical. Can someone help me understand why they are faster? We've already built quite a lot of client-integration software using cubeviews.  The cubeviews are being executed via the REST api.  We are retrieving data with "api/DataProvider/GetAdoDataSetForCubeViewCommand". Now that I have discovered the "FDX" methods, it puts me in the troublesome position.  I realize that a ton of our integration software should probably be re-written to use those FDX methods.  The re-write may take some time.  Why won't onestream just extend the "normal" cubeview interface of the REST api, and add an option to run it in FDX mode?  That would be similar to the "turbo" buttons they used to put on a the tower of a PC to make it run faster (for those users who had a preference between a fast computer and a slow one.) It would be h

Hi dear contributors / members,I am trying to format the Cube View cells to final value divided by 1000. Any idea how to do this?Thanks in advance.Kind regards,Irina

I want to execute a list of DB Stored procedures after executing a DM step in OS. Is it possible to call a DB Stored Procedure from OS?After the Stored Procedures are run, I want to execute a list of DM Jobs for data imports to cube.Appreciate any pointers how I can implement this.  

Changing the "Is Consolidated" option on parent Entities will impact consolidation performance. Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Please let me know what controls/dictates what entity parameters are being asked when running a dashboard.  I'm looking to cleanup some of the dashboards we currently have built.  Currently in our production environment we have a dashboard that is asking for the entity to be selected twice before running the dashboard, but in development it's only asking once.  I'd like the production environment version to run like the development one.  I've tried comparing the differences between both environments but having no luck.  The cube views we're referencing are the same parameters as well.  For Entity Members the |!WFEntitiesAnyLevel!| is being used for all.  

First time poster here!  I created a data source called Vista that has 4 different entities using it.  Each of those 4 entities has their own Workflow Profile and each entity is “assigned” to their respective Workflow Profile.   In the Data Source, how do I address this in the Entity field?  Is there a formula I can use to pull the Entity name from the Workflow Profile that is selected by the user?  So if the user is importing the “Chicago” entity (which is assigned to the “Chicago” Workflow Profile), can the Data Source somehow read that?

I have SQL Table Editor with about 70 columns. I have the bound column tied to a parameter. But I need to access the value of another column of the selected row based on a button click. I want to process that row in the BR function. PLease help.

We have users that frequently desire to mass updates to their transformation tables.  We use the TRX download/upload process to export current mappings and upload changes.  This works great except the TRX buttons are only available to administrators.  I believe that these should be available to admins along with anyone within the assigned maintenance group.  Is there a way to provision this? 

We leverage many cube view for monthly expense reporting and one particular report will not return values for certain columns that are pointed to a single User Defined dimension, but returns data for other columns.  There are no security restrictions on this or any dimension and the users security is no different that others who have no issue running the cube view and rendering complete data.  Has anyone else run into this or a similar issue?  YTD 6/30/2023     UD4#AlphaUD4#BetaUD4#OmegaUD4#TotalOperating Expenses$100,000BLANK/NA$150,000$250,000

Hi all, Is there a way to have the pivot grid in a BI viewer automatically expanded? I've built a custom JE report as a grid but the user has to expand every single column in order to see the JE description for example before exporting in order to get that data on the export. It's manual work where I should be able to set up the pivot to default as expanded or there should be an "expand all" button. Appreciate any direction you can provide! Thanks! -Nicole

Hi, I can't seem to find a method in the api that accepts a substitutionvariable object and returns the string value of that substitution variable. Or just get a dictionary of all predefined substitution variables and their values. Is this or something similar available? 

I have tried with the suppressions to make the cells that have 0 disappear but it has not been effective. In the first cell I would show how the data is arranged, and in the second image how I would like it to be   

Report Books LOOPS - A Loop is a sequence of instructions that will continually run a process as many times as is defined in the Loop Definition. For example, a book can be set up to loop through all the base entities under a particular hierarchy and generate an instance of the same Cube View Report for each entity. See you Building Basic Report Course for details - this is only a quick reminder that excel sheets are not the best way. Keep it all in OneStream.  see this QuickTips course for details: 🤣 https://onestream.thoughtindustries.com/learn/video/quicktips-intermediate-reverse-engineering-a-report-book-part-1 Try this out on yout local OneStream App.  🕺We have a Report Book looping through a group called Clubs, a  parent of children, NA Clubs and Europe Clubs etc.   Screen 1 - Entity Dimension -Clubs, this books will loops through each group and sub-groups and children in clubs. The Book will loop for all entitie

  We are trying to create a form with external vba code to refresh automatically once the onestream addin- refresh workbook. 

You can only enter data for up to 12 months in any given Workflow. Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

hi,Am looking to trigger the Finance Business rule from the DM step.Below is my snippet , but the DM step is not triggering the  finance BR .      Thanks 

Hi all, what do you usually suggest to clients as last step of a budget/forecasting cycle, to Close the workflow hierarchy or to Lock its workflows? I am just checking if there is any disadvantage by using one against the other. Also, is there a way of automating the closing/locking so that it is trigger on a certain date? I was thinking I can may create a rule encapsulated in a data management job and schedule that, but is there an easier way? Thank you