Reporting

I have a column performing the following expression: GetDataCell(Divide(CVC(CYAct)-CVC(PYAct)), CVC(PYAct))):Name(PY % Var) The column uses the following formatting: ExcelNumberFormat = 0.0%, ExcelUseScale = True, NumberFormat = 0.0, Scale = 0, ShowPercentSign = True The Cell Amount of the column/row intersection is -26.956   When I run this cube view in OneStream, the number populates as -27.0%, which is okay with me. However, when I export it to Excel, the number populates as -2695.6%.  My resolution is to multiply the number by 100 and then apply a scale to make the number appear correctly. However, if I multiply the division calculation above, it ignores the multiplication aspect.  My multiplication formula is: GetDataCell((Divide(CVC(CYAct)-CVC(PYAct)), CVC(PYAct)))*100):Name(PY % Var) Any suggestions on how to add this multiplication to my calculation, or another way for the number to appear properly within Excel?

Hey everyone, Is it possible to display either a text field or any other member filter in BI Viewer Dashboard? When using a CubeViewMD data adapter, I notice that even if the cube view being referenced uses :Name(XFMemberProperty(DimType=Account, Member=|MFAccount|, Property=Text3)) in the cube view it will display the dimension name in the dashboard instead of Text3 the way it does in the cube view? thank you.  

Hi, we would like to build a report with two columns with comments Annotations/AuditComments/VarianceExplanations). Each column needs to be filled in by a different team. The two teams need to be able to read each other comments. I am using UD3 to distinguish these two type of comments (as the requirements ask for variance explanation from more than 4 teams) The problem I am running into is that the varianceexplanaiton column is open for everyone to edit as long as that person has access to that cubeview. I have not found a way to make one column read-only and the other read-and-write depending on the security group. The "Can Modify Data" setting in the cube view does not seem to do anything. Anyone who can help on this?            

After migrating from OneStream version 6.8 to 7.4, it looks like the Excel data groupings disappear after refresh. Does anyone know if this is an issue with the Add-in itself or do OneStream/Quick view settings need to be changed?  thank you      

Hi all, I was not able to find a detailed guidance on how/when to use different view dimension members, so I would like to seek for advice here. In a cube view, I have a member formula which return either a text or number based on different conditional. For example, if conditional A is met, return a calculated value (sum of Account A and Account B), else return "Not applicable" text.  I notice that we can utilize V#Annotation to display the text, but then it cannot display the number. So, I would like to know if there is a view member to allow display of both number and text.  Thank you so much!  

Cube View within a Dashboard.   When an amount in a data cell is changed and the save button (either the cube view save button or a dashboard save button) is clicked I would like to add in validation code that evaluates the changed amount. A WorkFlowEventHandler allows me to identify the CubeView so that I can isolate the action solely to that cube view.   So far in the WorkFlowEventHandler I have been able to identify the cube view and get code to fire based solely on that CubeView, however it all seems to run after the cube data has been saved. Is it possible with a WorkFlowEventHandler to have code run before the changed amount is saved to the cube and not save the changed amount based on some validation/code logic?  

I have a cube view within a dashboard.    The dashboard has a save button which fires a Dashboard Extender rule.  (The cube view save button is hidden). I would like to add a step that, before any changed amounts on the Cube View is saved to the cube, checks the sign of any changed amounts and prompts the user based on a rule if they are sure the sign is correct. Any Ideas?    

Hello,  I am receiving an error "Value is either too large or too small for a decimal" in a Cube View when I try to divide values in two rows using the cube view math.   When exported into Excel the math for the same division yields 8.2, which does not seem like it would be too large or too small for a decimal.  Example:  GetDataCell(A#NetInc / A#Diluted_Shares_Outstanding_AsAdjusted_DC)      I am trying to divide the two rows shown above.  Using the Excel divide function produces a clean 8.26, which I would not expect to be "too large or too small for a decimal" The second member is a Dynamic Calc member that dynamically changes the view to either YTD or QTD depending on user's POV, but is not doing any math on the account value itself.  Any help or insight into this issue would be appreciated. Thank you!

I keep receiving this error when attempting to run my dashboard that has a BI viewer component attached to it. I made a bi viewer component and assigned a cubeview MD data adapter to it. created my BI viewer and everything works fine. However, when I assign it to my dashboard I get this error. I've tried attaching other cubeviews to the data adapter and making other BI viewers but I keep getting the same error. Has anyone else run into this issue?    

Hello All, Any ideas how I can remove these "0's" from the background in the Cubeviews? Is there any property that will make it disabled?

Hello all, I need to create a dashboard based on a cube view where I have accounts on rows, and MTD and YTD view in columns for actual, actual vs budget, actual vs PY. The request is to have in the dashboard the report with the rows displayed between the MTD and YTD view columns.  Is there any way I could achieve this in OneStream? Thank you! Adina      

  Hi, I am trying to use Cube View (already added in Data Adapter as Cube View MD) within the Report Designer of the Report component. However, I am unable to see the row-wise values for Entity and Account, and the column-wise UD8 for Text consolidation. I have checked various Data Adapters and Report components in different MarketPlace solutions but have not found a similar case. There also appears to be a lack of comprehensive video tutorials or study materials on using the Report component. Could you please assist me with this? Thanks

I have a column where I'm using a GetDataCell formula and I want my Time Row Header to show a date different than that of the Pov.  I've had a solution that uses a Business Rule but wanted to see if an out-of-the-box solution is available. 

Hello I am trying to create a type of dashboard that will contain multiple reports. I want that whatever report has data, only that should appear and report with no data should get suppressed along with its rows and columns too whenver I execute a dashboard? Can this also be achieved via a Cubeview? Please suggest?

With power query in excel, you can connect to a database one time with your credential then they are stored in the document.  If the connection is refreshed on another computer, credentials are required to refresh; however if the connection is refreshed for the latest data on your own computer credentials are not required.  This is a great set up for overlaying python scripts to refresh the data in automated fashion leveraging task scheduler, see below for example script with just a simple power query connection: import win32com.clientimport time xl = win32com.client.DispatchEx("Excel.Application")wb = xl.workbooks.open(fileName)xl.Visible = Truewb.RefreshAll()wb.Save()xl.Quit() Is anyone aware of a similar type set up with the OneStream excel add in.  As far as I can see, you have to log in your credential each time you open excel and hit the refresh sheet button each time you want updated data.  Most times this works just fine, but there are certain case

Is there a way to view application Workflow Status reports in excel rather than having to use a dashboard in the application that shows if an entity is certified/locked or not? Something that is easily refreshable so that you don't have to leave the current workflow you're in to view all entities workflow status? 

Hi Team, I want to add one excel that display all the contents in start of a book. I tried to load the excel file in a folder and try to pull it through the add file component in the book but i am unable to fetch it in the report while executing. Is there any possible way that i can achieve this?   Thanks

Hi, I have a book, with different report, but 2 of them are excel spreadsheets with cubeviews inside. They work, but after created and attached i am getting this error if i want to open it again and do any change.   Error in DXCustomFunctionsHelper.GetSpreadsheetDataProvider(). The spreadsheetDataProvider is not available using the Workbook's Tag property. It works in the book.... Any idea? Anyone?   Thanks JJ  

Hi all, I have the same question as AndeaF (https://community.onestreamsoftware.com/t5/Reporting/Conditional-formatting-based-on-the-value-of-other-rows-and/td-p/20227) Is the below solution post by OneStream still the only workaround for the question? I am trying to compare the variance of prior year and current year data and want to return a specific number format based on the two numbers. Thank you.  

       

Hello,  I would like to create a report book that includes several cube views and an xfdoc (ppt cover page). I added the xfdoc as an application database file and pointed it to the working URL.  However, when I run the report book I get a blank page.  I can't figure out how to get it to render the File (xfDoc).  It does render all the cube views as expected.  And I confirmed that my standalone xfdoc is working as well.   Thanks, Sean Report Book - Add File (XfDoc)Report Book Preview - BlankStand Alone Xfdoc - generating fine  

Dear community, I need to display numbers in columns in cubeview. Is that possible?  Please refer below image for better understanding. TIA

Hi All, How can I show Cell Detail Classification in the report ? Thanks

Does anyone know how to use VBA code to save offline copy?  I know VBA support the following, but anything for save offline copy? RefreshXFFunctions()  RefreshXFFunctionsForActiveWorksheet() RefreshQuickViews() RefreshQuickViewsForActiveWorksheet() RefreshCubeViews() RefreshCubeViewsForActiveWorkSheet() ShowParametersDlg() ShowParametersDlgForActiveWorksheet() Thanks

Hi All, I am trying to display percentage values for the different continents in a BI Viewer component with a Choropleth Map. The display of the values works, but I would like to see only one label per continent, as is the case with South America, for example, and not for each individual country, as is the case with Africa and the other continents. Is there a way to change the labeling to only once per continent?