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.

When end users utilize the excel add in functionality, they are only able to calculate 1 year at a time using the calculate button.  Is there a solution to allow users to calculate all (multiple) years shown on the cube view with a click of 1 button in the excel add in?

Hi all, I've col A and col B.I want to show a dynamically calculated col C which should be based on below logic: If col A has no data then display col B Else display col A Please suggest the best options to achieve this. Can it be handled in cube views or requires dynamic calc member formula. Thanks in advance

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.

Kinda of a silly question  I was building a cubeview and was trying to adjust the expansion on the layout.  It was set to default view, which got me to wondering where are these default selections set.  I first looked through the documentation, then remembered this is OneStream and this wouldn't be in any documentation.    I know we can set all this up in templates but are these defaults stored someplace else that we can set them?   Oh and I am not talking about the ones in the Application Properties.

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

I would truly appreciate any help you can provide in eliminating the blank rows in this pdf version below. These blank rows appear after my header, after all the current asset accounts, and again after total assets. Thank you. 

Hi all, I am building a dashboard that will be used by the Statutory Reporting team with 4 high level Group Balance Sheet checks (including BS = $0.00, IC = $0.00 etc etc). The users want to see a snapshot of the checks on the main dashboard . I have created these (Screenshot 1 with placeholders in there) using Cards in BI viewer and leveraging off the Cube View MD data adapter. They also want to be able to drill into the card to bring up the cube view to further review any balances. I was hoping the Card could be used as a button to open the cube view, but I can't seem to find a way to do that. Is it possible? If not, what are the best options to show checks like below with one specific number so that it shows as button?My second query, is in relation to showing the filtering the data in the BI viewer. The cards above link to a cube view which has rows as E#TotGroup.base and columns as C#Local,AUD,EUR,USD,NZD. The card itself only needs to show E#TotGroup and C#Local. How ca

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. 

Why doesn’t the report list the by month activity for entities 44, 87, & 55 from Feb to Sep? It does so for #77. YTD ties because Sept is the catchup month.Parent Entity 56 (Children Entities: 44, 55, 77, & 87) Child Entity #77 Only Child Entity #44

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?

Hi Team.We have a dashboard filled with cube views and also labels inside it where we are retrieving some values fromthe SQL table. Is there any option to get a printout in pdf format of the dashboard using extender rules ?   

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

Hi Team,I'm wondering if it's possible to create a dashboard with a list of all entities to select specific entities to certify.I would need there a tick marks ("Allow Multiselect" from Grid View settings might work) and make 2 nice buttons for "Certify" and "Revert Certification", would you think this might work?Thanks!  

Hi Everyone, I am creating an input form in CV and needs to pull IC entities which the entities are in use and have a specific name in Text 1. When I tried to use I#ICEntities.base, I got all entities including the ones that are no longer in use. When I tried to use I#ICEntities.base.Where((InUse = True) and (Text1 = SalesEntity)), no entity found for the query. Please let me know how to make this work.  Thanks!

I have a cube view that I have a spacer columns in. I would like to keep these columns but need their width narrowed when I export it the CV to a report.Here is what it currently looks like when I run the cube view:The spacers here are perfect.But here is what it looks like when I export to a report:The spacers revert back to full width. Is there a way to get them not to do this? Additionally, is there a way to get rid of the dashes in the title rows? It is set to an intersection that will never have data so I could have a clean title row in the CV, but shows the dashes like this when I export it as a report. Really looking for how best I can control/adjust the formatting of any CV I generate into a report. TIA!

Hello All,I have a reporting requirement, where I need to introduce an empty row between two Sub-Business units. These business hierarchies are displayed using .Tree expansion. In between the Tree hierarchies is it possible to introduce “Blank Rows”. Please let me know. Thank you.

Hey All,Looking into a case to get None entity member to appear for IC Matching. Are there any way to get None in IC Dimension to be listed under ICEntities? 

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

Hello everyone,  We have a few dashboard chart questions.  1. Waterfall chart Does anyone know if there are ways to change the data label text and background color? For example, change all the data labels to black text and remove all the red, green, and blue background colors. 2. Bar/Stacked Bar chart  Is there a way to make the data label within the bar more readable? For example, have the data label in text color black with a white background.    Any tips or advice are much appreciated!  

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 would like to use the text 8 attributes that vary by time and scenario to show that an entity can move from a group A to a group B. I am using the UD8 dimension to do this, where all data are set in "None". This is working fine for base member entity. However, in my report nothing happens for parents : As soon as I look for the parent, all data are invariably reported on the "None" member, even though both parent and child entities are set with the same Text8 attribute. Am I missing something ?   Regards,

Hi, I have a CubeView with UD1 on column and account on rows.I have a setting for columns "Use to determine Row suppression". I cant find this option on Rows.I want column to expand if there is data in Row 1-2, but for Row3 I only want to show data IF there is data in Row 1-2. Row 3 will always have data for all UD1 members (column) but I only want to show it if there is data in Row1-2. So column suppression/expansion should only be based on Row 1-2. Is this possible to do in OneStream?