Reporting

Hi,Is there a way to paste values from Excel into an empty cube view? I get read only cells with pink background. I tried already to use A#NoneAny help is appreciated.

Hi,I am using OneStream version 8.2 and the Excel Add-In with a workbook that contains XFGetCell formulas. The workbook retrieves data successfully, and Refresh Workbook works as expected.However, the Calculate, Translate, and Consolidate buttons in the OneStream ribbon are disabled (grayed out). I am logged in successfully and can retrieve data through XFGetCell formulas, but I cannot perform any processing actions from Excel.Could anyone help me understand:What conditions must be met in OneStream 8.2 for the Calculate, Translate, and Consolidate buttons to become enabled?Is there any way to trigger Calculate, Translate, or Consolidate from Excel when working with XFGetCell-based templates?Thank you! 

Our users are wanting to know how many applications are in each environment, then show the applications under each environment by clicking on the environment, plus the ability to enter a comment next to the application. Similar to the Cloud Admin Tool, Applications on top, user would click the environment, the grid would then show the applications. A text field next to the application name where they could input a comment. Any thoughts on how this could be done? Appreciate it in advance!

Hi, is there a way to download an updated GolfStream version? I like to use it to reference different formulas, dashboards, features etc. but things break every time we upgrade our version....Rather than filing a ticket and modifying rules manually behind the scenes, I think it would be helpful to have an updated one issued by OneStream.  I reviewed this forum and checked the Solution Exchange to no avail. Sometimes I just need help "getting started" with an idea that I've seen in a demo or solution and using Golfstream is a solid reference.  

Hello everyone! Not sure if this is the right forum or not, but I am creating a very simple home page using the Genesis Home Page. Creating buttons to go to Dashboards or Workflows was not an issue, but I cannot figure out how to get the buttons to work to navigate to a document or website. Below is how I was attempting to do it. If anyone has any advice on what I am missing, it would be greatly appreciated, thank you.  

Hi Team, Generally we can export the cube view to an Excel. But when we attached the Cube view to the Dashboard through cube view component. at the time we wont find the export option. Can you please advise us. how export a dashboard(Cube view attached to dashboard).

We used to be able to reference and retrieve the RPTA Audit Reports from the Guided Reporting Solution. After we upgraded the RPTA to Navigation Center, we are unable to retrieve the Single Journal Detail Report from the Guided Reporting or our custom homepage dashboard. See the prompt box displayed in the Guided Reporting when retrieving the Single Journal detail report:  

I have a bi blend based on cube view md. I have an issue with the Year total. The value is exaggerated as I have millions and not billions and because of this the height bars of the months is short. Does anyone have a clue on how to have the correct values?Thanks.

Hi everyone !We'd like to recover data in a date format using Quick Views.First step is to setup a CubeView that can recover this data. To do so, the CubeView setup is done in "Cell Type = Date " in the Data tab of the given line on the CubeView definition. Setup of cell type in CubeViewThen data can be correctly input in the CubeView:Possible selection when data is type "Date".This particular date is saved as 639,160,344,000,000,000 (numeric value) in the data base.Next step it to recover this data using the quickview, but I can't get the correct style. It seems that the data in Onestream is different to that of the Excel date style (Excel starts from 1/1/1900 as day 1).Set up of the style in a given quick viewDoes anyone know how to properly set up the style to recover dates using a QuickView?Thank youCarlos  

hi folks, does anyone know how I get one of these agents going? Our client has AI studio and is asking

Hi ,We have DEV and PROD environment and we want users to have read-only option to cube views in PROD environment.  If we restrict the cube view group maintenance, users could execute the cube view  but not see how it defined. All options are greyed out like shown in below picture.Is it possible to have Read-only option for cube view in production?  

Hi,Anyone on Version 8 who's actually tried to use this 'enhancement' feature in Cube Views?  We requested this on Ideastream a long time ago with a lot of support. I can see this command is now available in the header format dialog; however, it would appear that the only thing it does is change the header from left justified to center view.  There does not seem to be a way to actually 'merge' column headers, despite the fact that it's called "MergeAndCenter". Even the system documentation appears to confirm this behavior. Someone please tell me I'm missing something here and it actually is possible to merge column headers, because we really really wanted this feature. Thanks

Hi,Is there a way to paste values from Excel into an empty cube view? I get read only cells with pink background. I tried already to use A#NoneAny help is appreciated.

Hi everyone,I'm building a Balance Sheet report in the Text Editor. For various reasons, I have two separate CubeViews: one for Assets and another for Liabilities & Equity.I've placed both CubeViews inside a table within the Text Editor (one per cell, side by side), trying to display them in the classic balance sheet layout — Assets on the left, Liabilities & Equity on the right.However, I'm having trouble getting them to render correctly next to each other.Has anyone done this before? Is a two-cell table in the Text Editor the right approach, or is there a better/recommended way to place two CubeViews side by side in a single report?Any tips or examples would be greatly appreciated.Thanks! 

Hello,  I'm responding to audit requests regarding user task activities and found an active user which has no task activity logged. The user uses the Excel Add-in. What Excel activities are/aren't recorded on the Task Activity log? Is there a way to capture the Excel activities?  Thanks! 

Hi,I can figure out how to solve problem with cell format in column ShowCurrency=True (in Cube View) to work in Excel export? Any ideas how to fix this? I want to have it both in Excel and PDF export.  In Excel formatting I cannot see any settings that I can use. Maybe some kind of combination in ExcelNumberFormat that can be used? Currency is depended on accounts etc. Thanks for your help,Pia

  Hi Is it possible to change the blue, green and red color? Is it possible to add a value     

I have created a quick view template file, but each time I launch it, the font gets changed to a light gray. This obviously makes it difficult to see and I need to reformat it afterwards. Here is a sample: My QV has "preserve excel formatting" enabled, so I am uncertain what is causing a formatting override. I have tried different primary styles, but it does not stop the format from overriding after closing and reloading the spreadsheet. Here are my options: Has anyone else experienced the same issue or have any insight into how I may fix it?

I'm building a cube view column that shows combined annotations from descendants. I'm calling an Finance Cell Service BR from inside GetDataCell so I can pass dashboard params needed for the logic. GetDataCell(T#|CVTime|:BR#[BRName=..., FunctionName=CombinedComment, Flux_ID = {fluxID}]:U8#{ud8}):Name({ud8} Combined). I need to the UD8 POV member because that distinguishes what type of comment it is (CMvsPM, CQvsPQ, CMvsPYM, Ect...). The BR returns a String, but GetDataCell expects a numeric amount so the text doesn't render in the cell. Pointing the column at V#Annotation doesn't help either.Has anyone gotten BR-returned text to display in a GetDataCell with full POV/param context? Thanks,Ben

 

Hi all,I’m currently upgrading instances of Genesis-created workspaces and ran into an issue.The workspace named "Genesis" was upgraded successfully. However, the ones with different names are failing and returning the error below.For example, one of the affected workspaces is named "Landing Page." I’m not sure if the naming is related to the issue, but it’s the main difference I’ve noticed so far.Has anyone encountered something similar or knows how to resolve this? I’d really appreciate any guidance. 

I have some users who like to view a report in actual currency and others in 000's.  Is there a way a user can change the number format of each report?

Hello,To standardize the look and feel of my dashboards, I would like to create a reusable dashboard template for a toolbar. The Menu component seems well suited for this purpose. However, some actions (for example, Save) cannot be defined at the menu item level and are only available at the menu component level.As a workaround, I am using Event Listeners: each menu item sends a parameter value, which is then used as the Event Listener name. This allows me to have one menu item that performs a Save action, another that launches a business rule, another that opens a dialog, etc.This approach works fine until the Custom Control dashboard is embedded in a Dynamic Dashboard. The issue can be easily reproduced by embedding the dashboards described in this blog post into a dynamic dashboard.Any help or guidance would be greatly appreciated.Thanks in advance.

hi folks,When trying to edit some new blocks I've added in Genesis, I'm getting the error "Unable to find the Workspace Assembly Service Factory class for name 'WSMU' in Workspace 'Genesis' and Maintenance Unit 'X'"any idea why? I'm getting the error when i try to load a 'cube view basic' or 'embedded label' so far, in a card in a row in an advanced formatting block

I am trying to submit zero via excel add-in using XFGetCell formula into MTD/periodic view.  Excel/Spreadsheet does not seem to allow it.  I can put in zero into the same POV via a data form. The only workaround I have is to submit a 0.0001 record into OS via excel XFGetCell formula instead.   Is there any proper change in setting that would allow me to do this?