Reporting

It appears that my chart only changes when I "refresh" the Dashboard it is contained on, and the Parameter prompts do not prompt when I "redraw" the dashboards.   How can I get the chart to Refresh w/o the CV parameters prompting the user? Thank you, Stephen

Ad Hoc Analysis is a way to use a spreadsheet environment to report on data loaded into the Cube. Question Credit: Becca Speese   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello,   I created a Grid View to export data from database by SQL query. Some columns should be in number format and others in date format. I defined date format in both SQL query and in Grid View. But when I export data by right click from grid view -> Export To Excel XML, all columns are in text. How can I change default setting of XML Export so that columns will have correct formats ? Thanks in advance. Summer   Format in SQL Query: FORMAT(ActiveDate, 'dd/MM/yyyy') as BuildingDate,   Format in Grid View: ColumnName = BuildingDate, DataFormatString = dd/MM/yyyy,   Export XML file:      

I am looking for a way to download a dashboard with multiple tabs to excel and making sure each tab is downloaded to a tab in excel workbook. Is there a way to do that easily?

Is there a way of setting the selected cell in a cube view when this is refreshed. As far as I can see this defaults to the top left data cell. It would be useful if this could be set using a business rule or a parameter.

Hello,  Is there a way to apply the RowExpansionMode (e.g. - Collapse All) setting when a user select's "Show report"? The Report Viewer appears to default and expands all.  Ideally, I would like to set it to open at a predefined level, which I know is capable in excel. Thanks, Sean

Originally posted by Colin ONeillI would like to add an Excel "cube view run time" time-stamp to a cube view report. But I have been unable to find a way to do that. I can't be the first person with this question.

Hi, Is there a way to audit (in a report...) for all cube views, which one refers to a column or row cube view template ?    Thanks.   Regards, Harry

Is it possible to create a custom header on a cube view when viewing the report in Excel?  I was able to create my custom header for the Report view but I can not find any options available to change the header font and size on the Excel view.  I do see in the Application Properties where the Headers can be formatted, but I am looking to only modify one header for one customer and not all of the headers. Is that possible? 

Hi, My client has asked me to build a report with all subsidiaries and associated companies with respective Percent Ownership. I am aware that I can retrieve this through XFGetRelationshipProperty in Excel add-in but I wonder if there is any way to retrieve it in a cube view?

Originally posted by Jacqueline McBrideI tried running a CubeView I just created and received the following error message: "Error processing shared Cube Views. The maximum number of Cube View references has been exceeded." The application I am working in shares many row sets and column sets for various CubeViews. Does this error message means there is a limitation to the amount of times you can share rows/column sets? Thanks in advance! -Jackie

Originally posted by Priya GnanabhaskarWe have created a department level report which shows all expenses pertaining to a department in our actuals cube. This report consolidates the balances across all our legal entities for each department [e.g. IT].  The expectation is to create a drill through report that shows all the data loaded from the GL across all entities.  In the current drill through the user has to drill through each entity to see the transactions loaded from GL. Is there any way to achieve this drill through?

Hello,Has anyone experienced partial uploads when using the XFSET formula? Does anyone know if there is a way to set XFSET uploads to only upload data if there aren't any errors? Regards,Ronnie

Currently when we open excel the context pane automatically opens. Is there a way to disable so that it does not appear automatically?

Is it possible to pull up a linked dashboard by using a button component instead of having to right click on a cell.  I want the user to be able to click on a cell in a cube view, then click a button that pulls up another cube view showing the detail.  I am using two bound parameters for account and department within the dashboard.    

This seems very standard, so I have to be missing something.  I have the row filter on a Cubeview "A#6020.TreeDescendantsInclusiveR".  6020 is the total line for all the single level descendants.  How do I get only the last descendant to be underlined in the report before the Total line of 6020?

Looking for anyone who has used the CVRC() function successfully in their Cube Views. If so, is there anything special you are doing with the syntax for the Row or Column Index #?According to the OS documentation, I should be able to simply do this:  GetDataCell(CVRC(RowName,RowIndex,ColumnName,ColumnIndex).... ETC.) Example:  GetDataCell(CVRC(MyRowA,1,MyColA,2) + CVRC(MyRowB,2,MyColD,4) But even with the most basic test cube view, the result is always giving me an Invalid Index error.Is there some special way to express the row or column Index # that I'm missing here?Thanks in advance for any advice

Is there an easy or single step way to add a book to run from within another book?  Trying to avoid re-creating the book from scratch just to use elsewhere.

SOURCE: ONESTREAM CHAMPIONSHi Team,Just want to understand, can we customize the standard Drill down reports or may be add 2 more rows in there and call some cube view reports from there.https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/7e895d9991933241d561622179a47990f62958d3.jpegCustomized Drill down.jpg701×421 61.3 KB Regards and ThanksDarpan Bhansali

Hi, Is being able to Right click and choose Consolidate in a cube view an admin only function? We have a report where "Can Consolidate" is set to True but users are not able to consolidate from the cube view...they can from a data mgt job. Thanks, Haaris

Hello;  Would it be possible to round a number in a cube view? For example I have a result in cube view which has a value of -839 for an intersection, would it be possible to make this value to -840 using the Round or any other function in a cube view report.    thanks, in advance for any support!  

Team   Is there a way we can add long text like comments to the cells through Forms?  Am trying to build a cube view with data and comments to it which is visible on view rather than adding it as "note" or "attachments". Please see the sample image below on the requirement.      

What is the best approach to choose the first base member in a hierarchy, the following member filters not returning the expected results. E#|CVEntity|.Base.First nor E#|CVEntity|.First.Base or  E#|CVEntity|.Children.First.Base Entity keeps pulling in POV as in CV which is a parent the goal is to pick one single member from the hierarchy for Input  thanks  

I have a tabbed dashboard with three tabs displaying cube views. I would like to give my users the ability to print, export to excel or to pdf with a single action instead of doing so with each cube view individually. I would appreciate any approaches that community can suggest. Thank you.

Hello team, I am trying to get a dump of Yearly data in one table where I will use joins of member table with data records and want to expose this in BI viewer so that analysis can be nicely done on Month on Month, YOY basis etc. however pulling so much data seems problematic and I came to know about a term 'FDX' (Seems Fast data Extraction). Kindly help with some details on it, I could not find any content on this.   Thanks Satish