Reporting

Dear community, I'm using a getdatacell formula to sum few range of rows. The formula is correct and I'm getting the correct/desired output in the data explorer. But, when I try rendering it in the report and excel. It throws an error with "#ERROR'rowname'". I'm not sure what causing this issue. Is it because of the column override I'm using or some settings are driving the issue. It throws error Any solution to this would be appreciated. Please find the attached 2 images of data explorer and report output. The values in the data explorer are displaying. And the in the report it's throwing #ERROR: Rowname. 

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.   

Hi Community, Our financial auditors are asking for reports on onestream that they can use to sign of on our trial balance imported into onestream. so that would include movement reports etc. is there a standard set of reports that can be downloaded from Marketplace for this. I see there is something called standard application reports. We are on a cloud version

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.

Does anyone know if/when OneStream plans on addressing the incompatibility issues between Power Query and quick views/cube view reports? I've got a number of reports that utilize the get/transform functionality in excel but saving an offline version of any reports that contain an @getcell() formulae will wipe out any queries, connections, tables or table-named ranges. Is there a way to avoid this happening via the settings in the excel add-in?

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

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.  

Does anyone have a good solution when viewing dashboards that require scrolling? We have a P&L view set up as a dashboard, which is fed from a cube view, but are hearing a lot of noise around the scrolling and loading of additional data. When a users scrolls down on their report they get the loading circle and need to wait a moment for the rest of the data to load to continue scrolling and get the same thing. Once they reach the bottom they can scroll back up and down without issue. I understand why OS is set up this way, but if anyone has any feedback or input on the different ways they improved their performance on that I would appreciate it! TYIA

Is there a list of keyboard shortcuts available for OneStream using Excel.  Having a hard time trying to find any documentation on shortcut keys that work for OneStream excel addin.

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 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,We have a CV that has first few columns Actuals and rest as Forecast. User can select the Base Entity and enter the numbers in forecast columns but only look at the Actuals numbers.We have situation where we need to show parent of entity member for Actuals but use that base entity to capture forecast amounts.  We need this for just 5-6 entity members. Any idea how I can achieve this without writing complex business rule? Tried conditional formatting but no luckThanks,PM

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

My rows are my UD3 Dimension, and I want to mimic a current Excel Report.  I want to Left Justify the Description and right justify the UD3 Name so it basically looks like this.  Boys garments                   B100Mens garments                  B110I have this Name function to reverse the Description and Name.U3#Root.List(B100, B110):Name(XFMemberProperty(DimType=UD3, Member=|MFUD3|, Property=Description)XFMemberProperty(DimType=UD3, Member=|MFUD3|, Property=Name))Based on that I getBoys garmentsB100Mens garmentsB110Of course I could add some spaces, but I have Descriptions that vary greatly.I just wanted to make sure I wasn't missing a statement could make the Member Name property to Right Justify.  Any ideas appreciated, otherwise I just get the users to accept it in Name Description format.

Hi All, I have created a Cube view which has  negative values in few cells with parenthesis format in OneStream, when i try to export the repot to an Excel am not getting the same format in Excel instead am getting "-" in Excel. I need the same format in excel while exporting. Can anyone suggest the formatting settings how to get that. Please find the below snaps for reference.     Thanks in Advance.

Dear Community, We have a requirement to calculate the sums of two rows total for every month we run. We have a time parameter that is helping us to select the desired month. We used GetDataCell formula to calculate it for the particular month.for an instance if Jan period is selected - GetDataCell((Divide((CVR(Row1) + CVR(Row2)), (1)))*12):Name(Total)  will be the formula to calculate the sum total for Jan. If Feb period is selected in the parameter - GetDataCell((Divide((CVR(Row1) + CVR(Row2)), (2)))*12):Name(Total) this should be the formula. The bolded part should be dynamic upon selecting the months selected in the parameter. If it's June the bolded value should be 6, If it's July it will be 7, and it goes on. When we are switching the periods, we notice the totals are not matching and the values remain constant. We have a requirement to make the totals dynamic when selecting the periods in the parameter. How can we achieve this? Are we need to w

How can we  pass the selected row key using a bound parameter? I am trying to capture the selected row to a BR for further processing. I also have a supplied parameter to collect the bound parameter but it does not seem to work as a delimited list. The active selected items will be passed to the defined Bound Parameterfield as a comma delimited list. The Bound Parameter format will be as: item1, Item2, Item3. Please advise.Thank You,Indu 

Hi all, I wonder if I can use the following code in a Cube Cell Format.        "XFMemberProperty (DimType=Account, Member=|MFAccount|, Property=AccountType)"The idea is to flip value sign in case AccountType is 'Expense'. -----------------------------------------------------------------------------------------------------------------------------  If ('XFMemberProperty(DimType=Account, Member=[RowE1MemberName] , Property=AccountType)= 'Expense') Then               FlipSign = TrueEnd If-----------------------------------------------------------------------------------------------------------------------------  

I need to build a cube view that shows my closing & average FX rates in my row set. Which dimension has these options? 

Hi Team,I am using Excel Column width option in cubeviews to reduce the width of Blank Columns in Excel but it's not working,Please provide me any suggestions

Hi All,I am trying to create a simple view using SQL in BR. it works if do it directly in SQL server so no issue with the syntax. When i am trying to do the same using a BR it gives this error: anyone seens this and know the reason and how to resolve it? Code:  

I am trying to utilize a combination of Year() and PeriodNext1() within a GetDataCell, and it's not working. The combination of Year() and Period() within a GetDataCell works if you surround it with brackets, but once you add the Next1, it will not work. Any ideas as to how I can accomplish this?Example of GetDataCell with Year() and Period() working fine: GetDataCell(BWDiff(V#MTD:T#|!Prompt_TimeMonth!|:S#|!Prompt_Scenario!|, V#MTD:T#[Year(|!Prompt_CurrentYear_Comp2!|)Period(|!Prompt_TimeMonth!|)]:S#|!Compare_Scenario2!|))Example of GetDataCell with Year() and PeriodNext1() which gives an error:GetDataCell(BWDiff(V#MTD:T#PeriodNext1(|!Prompt_TimeMonth!|):S#|!Prompt_Scenario_FW!|, V#MTD:T#[Year(|!Prompt_CurrentYear_Comp1!|)PeriodNext1(|!Prompt_TimeMonth!|)]:S#|!Compare_Scenario1_Bgt!|))Error Message Received:Thanks!