Reporting

Hi,While exporting the Cube View to PDF and Excel we are getting the below error,Unable to process Cube View because of the Nested Member Expansions resulting in 167,125,564 rows and the maximum allowed is 1,000,000 rows. We have tried by enabling the Sparse Row Suppression still we are getting the same error. Is there any way to resolve this error?Thank you.

Whenever I try to load Cube View in the excel , it fails and shows blank when followed the below steps1) Open Excel2) Login to One Stream and create new CV connection3) Add any CV from OS app which has input enabled cells4) Save the file to your local desktop5) Input any data in the input enabled cells and click Submit SheetWhenever I click submit sheet , it shows blank excel and the CV gets wiped out. Am using 7.0.1 OS versionPlease let me know if anyone else faces the same issue or if there is any solution available.

I'm currently cleaning up the CubeViews available in the system that has been created over the years and not maintained.I noticed that templates do not "run" when a CubeView report is generated, so this might confuse a user to believe that the CubeView used as a template is not actively being used. However, when deleting a CubeView assigned as a template, I will get notified that I can't delete it as it is being used by another CubeView.I would like to know if there are any other dependencies I should consider when deleting a CubeView. Eg: is it used elsewhere in the system like a rule, workflow, etc, so that I can avoid breaking any existing processes.

Hi there, I am new to OneStream and would like to know is there any functionality to achieve below report output. I have two sections in my reports, the first section would be a header displaying what is the account used, and the second section would be the account breakdown by cost centres (e.g., Cost Centre A, B, C).  I would like to have report layout in column B as shown in below mock-up. I tried using the :Name(|MFUD1Desc|), but it does not work as expected. Any assistance would be appreciated. Thank you. Jacky

Dear CommunityI have requirement to pull all the prior months including the current month for my report. Currently I am using this(T#POV.AllPriorInYear)  function which gives me the only prior to the current month but not current month, and I need both the prior months along with current months to display in report. Any solution to this will be very helpful and appreciated. 

Hi All,  We have 100's of Cube Views that have been created, and we're looking for a way to efficiently delete many of them. Is there a method to delete multiple cube views simultaneously through BR or any other simple approach? Thank you and appreciate your help.  Regards Sri

When a data attachment is added to a cell, the cell is marked with a red triangle indicating the existence of the attachment. This does not appear to show up in excel when the form is connected to Cubeview Connection. The only way to know whether there is a data attachment seems to be right clicking the cell to drill into the attachment. Is there any way to get an attachment indication to show up in excel?

I've created a cubeview that is no longer working.  My co-worker is able to run the cubeview without and error.  I get the below error when I run the cubeview. How to I fix this.  Thanks Candice

Hello, I am seeking for assistance on header and cell format with conditional formatting. I am trying to add a top and bottom line to specific accounts in the "Show Report" function. Header Format used However, in the report, only the bold formatting is applied while the top and bottom line do not appear. Any guidance on resolving this would be greatly appreciated. Thank you. Thanks,Jacky

Hi,We have adjusted the top margin to all kinds of numbers, however it still doesnt seem to shrink. I have removed the log from the extender rule but it seems like there is a margin default. I have also tried to look at removing the blue line header to see if that helps but cant seem to find the proper rule for that. Any suggestions to get this top margin basically down to a very little space? The report needs to fit on one page so we took the font down and it works but would like to find a little more space if possible. Thanks!

Hello,I'm trying to create a 5 quarter bar chart trend in BI Viewer, but I can't get the time dimension to properly display the columns in the correct time order, it keeps defaulting to alphabetical (ie Q4 2022, Q3 2022, Q2 2023, Q2 2022, Q1 2023).  Does anyone know how to fix or adjust for this?Thank you!

Hi, sorry I always get a bit confused on how to use parameters in data management sequences/steps.I have a dashboard with: a combo-box that let users select an Entity member; a cube-view which Pov is based on the combo-box selection; a button which runs a data management sequence.The combo-box bound parameter uses a member list.The data management sequence contains only one step, which is a custom calculate.I would like the data management step to run on the selected Entity member (the one selected in the combo-box). How do I link the Entity of the data management step to the selected Entity member?With the current Entity filter setup in the data management step:- I can run the step from Application/Data management page and I am prompted to select an Entity. No issue in this case.- I receive an error if running the data management sequence from the dashboard (Summary: Error processing Data Management Step 'Plan_Growth_Adjs'. Invalid parameter. Entity Filter, |!prm_plan_bu_entity!|.)&nb

Guys, there is a requirement where we have to use a single template for all the 5 forms in  a workflow and depending on which form the user selects the rows and columns should generate dynamically . Is there any way we can get the Selected Form name in a BR. Or Is there any other solution for this Problem?  Thanks a Lot.

Hello,I am building a Quick View with the columns Account, Flow and UD5 - for UD5 I want "TG304" for all rows other than when the flow is "MVTCALC".  Is it possible to have this level of variance in the QV?Thank you!

Hi all, Is it possible to format the top row of an expansion different from the expansion details in a cube view if they are the same line on the CV set up? For example, I would like the formatting to have the Total Product line bold with the details under it not bold and with only one expansion at Total Product. It seems the only way I can do that is to have one row in the CV set up for Total Product formatted one way and a separate line below for the details formatted another way (result in screenshot above). The problem is then my expansion isn't really where it should be and the first detail line (Branded Pharm) will always show.I can't figure out a way to do this but if it's possible, please let me know!  

How are parameters organized within a DMU? I refuse to believe they're placed in a random order once created. They're not sorted in alphabetical order or by Parameter Type—then how?

Hi We are creating a book that loops over an excel export item to create multiple tabs (see below):Is there any way to add a named range around each exported cube view?Thanks,Mark

Hi all,I am trying to find a way to set up a member filter where the member's text 1 field contains the name of an entity.My CV row setup is as follows:E#MyParent.base     U1#MyU1Parent.base.where(Text1 contains xxxxxxx)in the above example, xxxxxxx should be the name of the current entity.So basically this CV should go through all the base entities and for each Entity, the U1 member(s) that display should only be those whose Text1 field contains the name of the particular entity.There must be a way to do this.  The concept is simple.  We use a lot of where() clauses here in our CVs but no matter what I try (i.e. where(Text1 contains |MFEntity|), where(Text1 contains |CVEntity|)); nothing seems to give that result.  It either completely ignores the where clause and just returns all of the U1 member regardless or it defaults to the total U1 parent.This CV works perfectly if I select a single entity and ask for all of the U1 base members whose text1 field co

The Formula for Calculation Drill Down will impact consolidation performance. Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi, is it possible to give someone access to the FileShare folder in OnePlace, without giving access to the System tab (from where, using File Explorer, it is possible to browse to the FileShare folder)?Thank you 

how can you add calculations into a quickview.  how can you add the input fields also? I seen both at splash so i know its possible 

Hi dear contributors / members,I am trying to format the Cube View cells to final value divided by 1000.I have setup Scale = 3 for all rows and all columns, however the divided value appears only for the first column.Any suggestions please?    Thanks in advance.Kind regards,Irina

Hi,Report Title is hidden in CV Extender but can it be collapsed?Using above code it is hiding Report Title, But it is consuming too much space, Is there any way to Remove / Collapse / Eliminate CubeView Report Title using CubeView Extender Rules. Any solutions would be Helpful.Thank you

Hi all,  We have data coming into Import/stage that subtotals to zero when it validates/maps into the cube. We need to review this data in import/stage before the validation and the easiest way would be a QV or CV instead of having the user manually go into the workflow and export the data. I thought accessing stage data in a QV/CV was possible but I can't find specifics. Any direction would be useful - thanks! 

Hey all,We are trying to creating a toggle button so that the dashboard will render based on the selection. We have 4 Scenarios and we want to compare those but the scenarios will be selected by the end user at run time and s/he can change the selection as many number s/he wants.I have tried to achieve this via Checkbox but that is not working as expected for multiple users as the literal parameter gets updated every time.I tried radio button as well but it looks like so many option (buttons) on the dashboard. Do anyone have any other suggestions on this? Below are layout images on both tries we done. Radio button (first image) looks best but as mentioned above not working as we want too.