Reporting

can you keep a QV POV separate from the main POV so I can look at 2 things with 2 different POV's at once? 

Looking to use a Sparkline or Chart in Reporting Studio.   It has to show the trend of the first 6 column in my CV.   For Sparklines, you can only supply a single column.  How am I am able to show the trend of the first 6 columns for each row?

Is there a way to get the value of the cell that is 1 row above and 1 column to the left of the cell?I have a cube view with 2 columns, one is for actuals and the other is for estimate months. The actual column is going to pull the account value directly, but the estimate column needs to pull in the starting balance and then make adjustments. Below is an example of the data: The 'Last Month Ending Balance' row is where I am having an issue and tried to use variables such as |CVSubPeriodPrior| but I get the same value for all of the estimate months. Is there a better variable to use or could I use a simple offset formula to pull in the value of the cell 1 row above and 1 column to the left?

hello! Is it possible to bookmark reports generated through books? 

When I try to run reports for certain entities, I get the error "Value was either too large or too small for a Decimal" . Does anyone know why this is showing and how to resolve this issue?

Hello, I have a question in regards to cube views - I have multiple rows in the report, some of them including member extensions, and I am gonna write here an example: Row 1: A#Rent Row 2: A#Penalties.Children Row 3: A#OPEX Check that I want to make: GetDataCell(CVR(Rent) + CVR(Penalties) - CVR(OPEX)):name(Check) Instead of getting 0 on the check row, I get to have a difference due to tha fact that the formula only takes into consideration the first child of Penalties, ignoring the rest of the children. How to accomodate/change the formula in order to have all the children into consideration?   Thank you, Ioana

can you add totals to all the columns in a quickview?  not with excel formulas

can you link the T# to a cell in a spreadsheet to pull in the date and refresh on its own without having to go into the member filter builder every time? 

is there generic template available to load journal via csv template?

Does anyone know if it is possible to display commas within numeric columns in the table view feature?  I have attempted to make this work both through the business rule and using formatting within the spreadsheet tool, but every time the spreadsheet is refreshed, the commas are removed.  Any advice in this area would be greatly appreciated.

Hi, We have combo boxes in a dashboard that use an XFBR to define a UD1 (Cost Centre) list based on the text 2 field from the users current workflow. For example, if a user is in the North America workflow the combo box will only display North America & below. When a user changes their workflow & returns to the dashboard if their last selection isn't present in the new hierarchy the combo box will display a blank result. Is there a way to prevent this? We also have a similar issue where a combo box contains 2 parameters, 1 that defines the prior month & another for prior year. If the workflow time is changed these also return blank when the dashboard is opened. Thanks,

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

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?

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

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?

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

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

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!  

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