Reporting

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 

Hello,I was curious if anyone knows a way to get their Quick View in Excel to breakout the hierarchies on the row dimension so that it would separate the parent and children by column and not just have it indented?Instead of this:I want this: Thank you.  

Hi,The request is that when showing base level members, every other row should have a dashed underline. However, there are two issues why we can't achieve this via the formatting editor:1. The bottom line won't render when it has the condition (is rowNumberEven).2. Don't have the option to select a dashed under line (how you can for the excel formatting settings) Can we achieve this through Cube View Extender Rules?? Thank You.

Hi everyone,I have created a waterfall as below using the advanced chart component. Is there a way to change the font size/color for the data labels within the waterfall bars? I cannot seem to find this option. The request is to make the text more readible.Any help is highly appreciated!BR,Floris 

Is there any way to stipulate the Cube whilst building a Quick View without selecting that Cube on the user's default POV? I've tried typing Cb#CubeName in the cell in Excel but when I create the Quick View it ignores this and uses the default POV Cube. In the example I have tried to create QuickView for RETLWRK cube but POV default of MAINREP has been used to I need to change the Quick View cube in the Context Pane after creating the Quick View.  

Hello Everyone ,We have requirement to keep  the indentation level to specific number using cube view extender rule for Pdf report.It looks like : CV Extender rule  that checks, if Col Header Name StartsWith 'ABC' or 'XYZ' then,Set Row Indent to 'Some number 'Any Answers for the above issue would be of great help .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

I am using the BI Viewer to display bars for actual data and a line for the budget/target.My issue is when I split the values into two groups the items in my legend are doubling. So I see each one once for the budget line (even though all intersections are 0 but one) and once for actuals. I have tried using the filter through the graph as well as creating a calculated field to filter what I want out before I get to the graph but still the legend is doubling. Does anyone know how I can remove unwanted items from the legend? The graph is showing exactly how I want it to it is just the legend that is the problem.Thanks! 

I am creating a cube view to use for a form template. The first column brings in data from a set of account members using A#xxxx.Base as the member filter for the row. On the second column I want to allow input from the user. So, on that same row I am trying to use column overrides to achieve that but having issues:Using A#yyyy.Base as the member filter for the column override doesn't actually allow the cell to be editable. Using the base members in a list for the member filter allows input on each cell, but automatically fills in the rest of the column cells with the same number and upon checking a QV only sends data to the first member in the list. Can modify data is set to "True" for both the column and the row.My question is - do I need to break this out and create a line for each member with the corresponding column override member or is there another way to do this?  

Hey,We have a Pivot in the BI viewer with 3 rows say Row 1,Row 2,Row 3 and we want the sum of Row 1 and Row 2 as Grand total. Today when we try to do this, we get the sum off all 3 Rows.Is it possible to archive this in BI Viewer? 

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

Hello,We are having this below requirement, where we trying to achieve this using Cube View extender rules.Rule should vary margin depending if it's landscape or portrait.If Landscape, thenRight and Left should be 0.25, Top should be 0.75, and Bottom 0.5Else If Portrait, then Left should be 0.75, Right should be 0.25 with Top and Bottom 0.5  Any help or suggestion will be of great help!Thanks in advance.

Is there a way to move the company logo to the right header side of reports? I have applied a business rule to move the report title on the left but now it is hidden behind the company logo.  TYIA!

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! 

Hi , We are trying to achieve the below format of Date ,Time and Time Zone in Cube View report footer 25/08/2023 5:00:00PM CT/IST/ET  Here, time zone should vary according to user's local timing.Any solutions on this are greatly appreciated.Thanks  

Dear community, I'm using a getdatacell formula to sum few range of rows. The formula is correct and I'm getting the correct/desired output in the data explorer. But, when I try rendering it in the report and excel. It throws an error with "#ERROR'rowname'". I'm not sure what causing this issue. Is it because of the column override I'm using or some settings are driving the issue. It throws error Any solution to this would be appreciated. Please find the attached 2 images of data explorer and report output. The values in the data explorer are displaying. And the in the report it's throwing #ERROR: Rowname. 

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.   

Hi Community, Our financial auditors are asking for reports on onestream that they can use to sign of on our trial balance imported into onestream. so that would include movement reports etc. is there a standard set of reports that can be downloaded from Marketplace for this. I see there is something called standard application reports. We are on a cloud version

I have a dashboard with a button component in which I have a XFBR String which alternates between two colors for the button's image background when clicked. Similary, I would like to be able to alternate between two images for my button when clicked. Is this possible with a XFBR String at all ? I thought I could return the image's file name with a XFBR String under Image URL Or Full File Name   or can XFBR Strings only be used under Display Format ?

Is there any way to get the cube view profile and Group Name of the CubeView using Business Rules?Thanks.

Does anyone know if/when OneStream plans on addressing the incompatibility issues between Power Query and quick views/cube view reports? I've got a number of reports that utilize the get/transform functionality in excel but saving an offline version of any reports that contain an @getcell() formulae will wipe out any queries, connections, tables or table-named ranges. Is there a way to avoid this happening via the settings in the excel add-in?

Hi dear contributors / members,I am trying to format the Cube View cells to final value divided by 1000. Any idea how to do this?Thanks in advance.Kind regards,Irina

Changing the "Is Consolidated" option on parent Entities 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

Please let me know what controls/dictates what entity parameters are being asked when running a dashboard.  I'm looking to cleanup some of the dashboards we currently have built.  Currently in our production environment we have a dashboard that is asking for the entity to be selected twice before running the dashboard, but in development it's only asking once.  I'd like the production environment version to run like the development one.  I've tried comparing the differences between both environments but having no luck.  The cube views we're referencing are the same parameters as well.  For Entity Members the |!WFEntitiesAnyLevel!| is being used for all.