Reporting

Trying to align the text in a button to the left. HorizontalAlignment = Left does nothing. I've also tried HorizontalContentAlignment under Image. It centers the interior text no matter what I do. Anyone have any thoughts? Is this possible at all? Kind of annoying if not.    

Hi!   I’m trying to create a cube view that can drill down to stage detail data. Is there any documentation on this?  Any input would be greatly appreciated!

Hello everyone, Is there a way to collapse/expend column via a native display configuration on Onestream (v8.1) ? Something same as the RowExpensionMode option in the Header Formatting but for the column. Thank you in advance.

We have users experiencing connection conflicts with the OneStream Excel Add-in. When they enable the OneStream add-in it disables the add-in they have for their ERP. They would like to be able to use both add-ins at the same time. How can we enable them to have both add-ins active? Have there been similar issues? What is causing their ERP add-in to be disabled? 

Hi OneStreamers, I am using the table vStageSourceAndTargetDataWithAttributes in a dashboard to display cost centers (Source Account) and Accounts (Target Accounts) per all other dimensions, for a selected entity and period. It's working fine but the amount from the table is always in the local currency of the entity, and I'd like to see all amounts in EUR. Is there an easy way to convert the figures in the table ? I saw there was a column named "Converted Amount", maybe it can be used somehow to show translated figures ? Appreciate your insights on this. Adam

I am trying to insert a row into a OneStream Application SQL Table through the SQL editor Dashboard component.  I am getting the following error message.  Is this something that needs to be changed in the SQL or a component setting I need to change.  At the moment I have not added anything additional to my SQL create table statement except the column names and a primary key for the Row Number.  

Is it possible to use Cubeview Parameters in XFGetCell ? Saurin

I have a Cube View that uses a parameter 'pm_EntityList' in the POV to let the user select an entity.Its possible that the same parameter can exist in both workspaces.In my case, the parameter is defined in both the default workspace and a workspace named 'CustomerWorkspace'.If I specify |!pm_EntityList!| in the entity POV for my Cube View, which parameter will the cube view look at?Taken a step further, lets say there are two Named Workspaces with the same parameter.  Now which one is evaluated?

Does anyone know what this message is talking about. Sorry...new. Users are trying to drilldown by 3 dimensions in the rows and are only getting approx. 6 rows of data and then the message under the output. Their row settings are at 10,000.   Any help would be appreciated.... James

Hi There has anyone had an issue at their clients previously where the OneStream excel add in keeps disappearing?It’s becoming a problem as some users don’t have the option to add back and have to contact IT all the time to assist.Anyone experienced something similar, if so, any ideas on how we can help fix it?

Hi, I am building a BI Viewer chart and need my colors to be dynamic. I have three colors in my color palette for the BI Viewer component. I can manually set the color to match the option in the palette, but if I use the parameter changes my scenario or time, the palette color is reset and it selects a random color. If I use the automatic setting (which would make the most sense) it sets every color to black.  My ideal color settings are: First year actual: Blue Second/last year actual: Pink Second year plan: Green How can I set this up dynamically?

Originally posted by Sheila GraffIs there a report what will show the when dashboards were modified? Looking for something similar to the CubeView Audit. 

Hello,  So we loaded some data to an application database, which we are accessing within Dashboard. Does anyone know how to format the table values in general? For e.g. I want the decimal to show in pct.   I tried to format numbers within here - but couldn't make it work. Am I missing something? Please suggest Thank you!   

Hi I am trying to add conditional formatting to my CubeView to bold certain rows, so that it stands out for my users. I'm using treedescendants(i) to list out all the accounts to minimize any maintenance, so I can't bold the rows individually. Also, the accounts I want bolded are not in the same indentation level, so I can't use that expression. I tried using If (MemberDescription = 'Apple') Or (MemberDescription = 'Orange') Then Bold = True End If. This works, but if I tried adding another Or statement, it would not work:  Eg:  If (MemberDescription = 'Apple') Or (MemberDescription = 'Orange') Or (MemberDescription = 'Banana') Then Bold = True End If.  Is there another workaround for multiple Or statements/ how should I update my condition? 

Dear CommunityI am facing the fact that my XFBR(BR_XFBR_String, ParentBold, sEntity = |MFEntity|) does not passing the Entity Name to XFBR.CubeView is organized in the way that Rows contains just a part of Entity structure Entity.ChildrenInclusiveR (this two step structure has no Base Members) and i need to format only Top Parent of that. It works when Variable comes form POV or CV but not from the Rows/MF.Is there any way to use |MF...| for passing information to XFBR?Thanks

Hello community can the Grand Total be added at the top instead of the bottom?   thank you a lot  

Hi everybody, I'm currently developing a dynamic CV that gives the chance to the user to select an account hierarchy of choice to show in the report  (P&L, BS etc.) through the parameter MainFormParentAcc_PL I'm having issues with indentation tho, because if I add .TreeDescendants the accounts are still shown on the same level in the report.  I tried to look if there is a format I can apply, but if I understand correctly the only format available for indentation is for the excel view (ExcelIndentLevel = xxx). Do you have any suggestion on how I could solve this?Thanks in advance!

Hello People, I built this CV and then I'm building this BI I used the same CV above in the BI dashboard, however, I couldn't move the periods in the columns like in the CV. I would like to have the periods in the columns like in the CV to get the same data.do you have guys any examples of this?    thank you

Hi all, I am trying to build out a CV for a report and I'm having trouble with the best way to build out the columns. My current approach is to just go at each column with differing member filters. For Example: 1st column - S#Actual:V#MTD:UD#Orders:...etc. Does anyone have a better approach that I could use? Or even just point me in the right direction in the documentation? Thanks in advance! Here is a screenshot of the report columns I need to build in OS:  

I have listed a parameter which has display items as Yes, No in one of cube view row override that displays in a Form. Along  with Yes, No items it is also showing "No Data" even if it is not listed down in Display items of the parameter. Could you suggest how to remove "No Data" item     

Hi, we have been working to build our Cash flow report and would need to include an account from the Balance sheet into the cube view report. We would need to include ''cash and cash equivalents at the beginning of the period'' and ''cash and cash equivalents at the period end''.Is this possible to include? When I tried to, I got no values from the BS account into the cube. If so, how would i proceed?Thank you! 

I understand that OS users are able set their own preferences for whether or not Excel Add-in data refreshes upon opening a workbook, however I would like to know if there is an option for the "author" of a Quick View or XFGet form to require a refresh of data when another individual opens it? Not meaning this as an attempt to override the settings of other OneStream users, but instead to make it so that non-OneStream users within the organization are unable to view QV or XFGet form data without having proper access. Thanks

Greetings - Looking for Audit option to track the data before the change, 'Audit History For Forms' option shows data after the change.   Thanks!    

Hi All, I've got an annoying error message popping up on a dashboard I've built. To be clear it doesn't stop anything working, just wondering if I can get rid of it somehow... Basically in the content section there are 2 cube views. When the user clicks on something in the first one, it uses the normal navigation links (in the cube views) to pass an entity and UD4 across to the second one. It's all fine and works except for the first time the user opens the dashboard when cube view 2 doesn't load (and gives the error message) because nothing has been clicked on yet! Is there any way to pre-populate the |!ClickedEntity!| and |!ClickedUD4!| in cube view 2 before anything has actually been clicked? Thanks (screenshots below), Richard First time load before anything has been clicked:   After clicking on cube view 1, the navigation links kick in and populate cube view 2:  

Is there a way to create a dimension member drop down in Excel to use for the GetXFCell data selection listing?