Reporting

I have a Cube View that uses a parameter 'pm_EntityList' in the POV to let the user select an entity.Its possible that the same parameter can exist in both workspaces.In my case, the parameter is defined in both the default workspace and a workspace named 'CustomerWorkspace'.If I specify |!pm_EntityList!| in the entity POV for my Cube View, which parameter will the cube view look at?Taken a step further, lets say there are two Named Workspaces with the same parameter.  Now which one is evaluated?

Hello community can the Grand Total be added at the top instead of the bottom?   thank you a lot  

I understand that OS users are able set their own preferences for whether or not Excel Add-in data refreshes upon opening a workbook, however I would like to know if there is an option for the "author" of a Quick View or XFGet form to require a refresh of data when another individual opens it? Not meaning this as an attempt to override the settings of other OneStream users, but instead to make it so that non-OneStream users within the organization are unable to view QV or XFGet form data without having proper access. Thanks

Greetings - Looking for Audit option to track the data before the change, 'Audit History For Forms' option shows data after the change.   Thanks!    

Hello, I was wondering if there's a time expansion that would only pull a previous year based off the workflow? I tried WFPrior2, but that pulls both prior 2 years. If I want to just pull the time form 2 years ago (i.e. 2022) how could I do that based off the WFYear time expansion? I know i can create a parameter and hard code it, but I would rather not have to go back and update it every fiscal year. Thanks, Will

Hello all, I was asked to code in a December of prior year. I know how to get any month prior to the current month but I am unable to figure out how to get a static month like December no matter which month we are in the current year. Seems simple enough but the time functions are not working. It says 'Unexpected Text' when i enter in the function T#POVPriorYearM12. Is this a POV issue? Not sure what is going on. 

Does anyone have any experience creating a bar graph with 2 dimensions on the x axis?  We have created a bar chart comparing Recurring and non recurring revenue by entity.  Currently, I have both the accounts as the rows and and entities to be displayed in the columns. The client wants to see the same chart but for the current month and two previous months for each of the entities. I have tried placing the T#Month(|CVTime|), T#MonthPrior1(|CVTime|), T#MonthPrior2(|CVTime|)  in the nested member expansion 2 on the columns but that does not allow me to have multiple dimensions on the x axis and only displays those three months. I am currently using the Chart (Advanced) component. Any ideas are appreciated. 

Dear Community,  We have a requirement to make all the headers in report as well as in excel to make it bold and to increase the size. Here, I wrote a Business Rule function in Cube View Extender to make the change. But, I see it's getting reflected for only one of the headers in the report. Here, I'm attaching the images for the reference. Any solutions to this are really appreciated. Thanks.   -- This is what I have given in the report header.       -- And this is the output when generating the report. This bold needs to be applied to all the headers given here.     -- This is the output when I'm viewing it in the excel format. No changes are seen here.      -- Cube View Extender Business Rule which I used.               

In my cube view, I need a column (% of net sales) to calculate each row/divided by net sales. In the selected column I am trying to only solve for actual. For example actual gross sales/actual net sales, and then actual sales rebates/actual net sales, and so on down my P&L. There must be a way but I have not found anything useful. I'd greatly appreciate any help.  

I am using BIViewer within the dashboard. This BIViewer uses a data adapter of Cube View type. Now, every time the dashboard refreshes, the Cube View runs and the task activity shows a Cube View entry. How can i avoid the task activity entry?

I am trying to create a conditional formatting code to convert a large percentage result in a percent variance column to replace it with text ("nm").  Can anyone provide the conditional formatting text that would replace the actual % variance with text?

I want format the Cube view cell based on cell amountIf (CellAmount > GetDataCell(CVC(Col2)) )ThenBackgroundColor = Red, TextColor = WhiteEnd if This code is not working, Actually I am comparing actual amount with budget. how can we do this?  

Hello, I used to work on v7.4. When we worked on cube views, changes were saved in Cube Views. It worked perfectly. Recently I began to work on v8.0.0, I noticed that when changing a Cube View, OS opens a second window for the same Cube View under CV Groups of Workspaces. If we make changes in one of the windows without refreshing, and then we modify in the other window, it doesn't take previous changes into account. It's just like the issue when two persons work in the same business rule. Do you have a solution for this issue apart from updating OS version ? Many thanks in advance.

We have a client with a custom font that they would like to apply to reports that are exported to PDF. Has anyone come across this as an option? Thank you

Hi all, does this 2021 OS community post by OneStream still hold true? I would like the cells from the FTE row to be formatted in a certain way (for example set the background to red) when the FTE check cell amount is not zero. Is there a way other than the XFBR they suggest (which looks like an overkill for what I need to do)?Thank you

Hey everyone! Wanted to reach out and see if there was a simple way to include banded rows (every other row highlighted a different shade) into CV formatting within the application. Thanks for the help!

Is there a way to have a nested parameter with different dimensions? Example: If I select Year = 2020, the next prompt will ask me to select a Scenario The example I saw in the Design & Reference Guide used the same dimension, so I'm not sure if this is possible. 

Hi, We are facing a strange issue with Excel QuickViews.  When a non-admin user tries simple quick view, user is getting below message. But when admin tries, he is getting all of the data in single page. We have tried changing all the settings on Max rows, Max seconds, almost 100s of combinations (from 1000 to Billion) but no luck.  Any thoughts on why this is happening? We are using slice security for users. Page 1. Use row paging buttons in Task Pane.

Hello, I am using a cube view that has the same rows, but it needs different columns based on the UD8 member. I built multiple template columns cube views, and created a parameter for UD8 members. I want to retrieve the column template CV based on the selection of UD8. I created the following XFBR: I then attached it to the main Cube View: When I run it, and select UD8, nothing appears: If I put directly the template name, the cube view runs with no issues, showing data as well. Any idea why it is not working? Thanks, Ioana    

Hello,   I have a Dashboard that has an attachment button, setup as "File Upload" to the Application Database. We want the client to be able to attach files (this part is working). Due to the number of attachments, every file that is attached, will have to be tagged to a Text field for a specific Member. We'd like to tag multiple files on a single text line, separated by commas. Has anyone done something similar? How did you go about this?  Thank you for your time.

I would like the use one of the T#Global function and create a dynamic time list for the last 24 months.  For example, I had the time as 2023M12, the list would show me all the months of 2023 and 2022.  Anyone has any tips on how this can be acoomplished? Trung

Hi everyone, I have the current Entity hierarchy: I created a cubeview that allows the user to initially select a base entity from a dropdown list to be used as Entity member within the cubeview. In some of the rows, though, I'd like to consider the Legal Entity code rather than the base member code (for example, assuming the user initially selects 1010TRW, I want two rows to use 1010 as Entity member whereas the rest of the rows will use 1010TRW). Is there a straightforward way to consider the first 4 characters of the parameter in one of the rows of the CV?  I tried to search for functions to be used in the Member filter builder window but I did not find any.Thanks in advance for any help!            

Hi,I have a large Excel report built on XFGetCells. I am trying to understand the dimensions that each XFGetCell is grabbing, but it takes a long time to parse through an XFGetCell manually and make notes of each relevant dimension. Is there a method or tool to read XFGetCells and translate the dimensionality in a format that identifies which dimension each member is related to? An example of one of my XFGetCells is:=XFGetCell(TRUE, "Cube1", "Entity1", "", "USD", $G$4, H$18, $I$4, $C$24, "Top", "Top", "Top", $C$15, "Top", $C26, "Top", "Top", "None", "Top", "None")-XFGetCell(TRUE, "Cube1", "Entity1", "", "USD", $G$4, H$18, $I$4, $D$24, "Top", "Top", "Top", $C$15, "Top", $C26, "Top", "Top", "None", "Top", "None")-XFGetCell(TRUE, "Cube1", "Entity1", "", "USD", $G$4, H$18, $I$4, $E$24, "Top", "Top", "Top", $C$15, "Top", $C26, "Top", "Top", "None", "Top", "None") I would like to understand that Cube= Cube1 Entity= Entity1 Parent= Cons= USD Actual= $G$4 Etc. Thank you

Hi Everyone.  How can I make an element not open with just one click, but with two clicks or more?

Hey guys! I am working on an Dashboard to present workflow status.... i got this: The query is: {Total GolfStream}{|GlobalScenario|}{|GlobalTime|}{}{}{RowType <> 'A'}   How can i remove the ones that have Central in the name?   Thanks!