Reporting

Dear all, Could you please advise is it possible to combine several cube views into single Excel file and download it from the application? If so, could you please advise how to do that.

Is there a way to disable excel functions/buttons within the excel add-in? For example turning off "submit workbook" in the top ribbon or calculate/translate when right clicking on a cell in a quick view/CV? 

Working with BI Designer and cannot get the Time order in place sequentially. The Cube View data source is pulling the correct time, data, alongside the POV for workflow. The WF filter builder is in order. However, cannot get the two months (Oct and Nov) in the appropriate place. Tried to sort and use Start/End Dates too in settings for WF Time Filter: T#WF, T#WFPrior1, T#WFPrior2, T#WFPrior3, T#WFPrior4, T#WFPrior5, T#WFPrior6, T#WFPrior7, T#WFPrior8, T#WFPrior9, T#WFPrior10, T#WFPrior11, T#WFPrior12, T#WFPrior13Has anyone experienced this before?   

Is it possible to make an attribute member run a comparison based on the stored text attribute for a specific Time Period ?Ex: - Text8 & 2023M1 =>  FO_SUPM      - Text8 & 2023M6 => FO_HYPMBased on the cell pov, is it possible to make the attribute member adapt to the context's Time Period instead of picking the stored Default Value for the Text 8 ?Thanks. 

Originally posted by Dean Harper Hi all, Hopefully a simple one - is there a way to dynamically select the prior year comparable for a Cube view based upon the workflow. So Column 1 = T#WF Column 2 = T#(WF-12 Periods)   or T#(WFPRIORYEAR) if you see what I mean? The WF "snippets" in the Member filter Builder, Time functions does not seem to cover this. Thanks in advance, Dean

In a quick view, I am using the syntax T#Pov:V#Periodic,T#POV,V#Trailing12MonthTotal in the 'Time' dimension. I have a specific requirement where I need column A to display as "2024M1 (or the short description) Periodic" and column B to display as "2024M1 (or the short description) Trailing12Month Total". I can see there are variables available to pull in the POV description, but I'm wondering if there's a way to get my desired outcome of providing all descriptions for all dimension members in my filter when they are not linked to the POV. 

HI All, Is there a way we can identify which cube views have not been used/opened for say last 6 months to a year?  

I'm trying to produce a report schedule for Miscellaneous Receivables to show the make up of the Account.  I'm looking at trying to use Cell Details if that will work, but didn't know if anyone had a better idea.  The setup is I have one Miscellaneous Receivables account and I want the users to enter the detail make up of that account.  The lines will change over time to different descriptions that can show up in dynamic report rows.  Like I said similar to cell details, but they don't seem that easy to use in a cubeview.

Maybe I'm missing something easy, but I'm trying to get some rows to group in the Excel import, and I can't get it to work properly. I think the problem may be that the rows are GetDataCells, but I'm not sure. So my question is, will the ExcelOutlineLevel work for GetDataCells, or is it restricted to member trees?To illustrate visually, I'm trying to get a bunch of rows like this: To export into Excel grouped like this:

Hi, has anyone figured out how to add files to Narrative Reporting. In the Admin area I have blanks in the Source File Name column for my documents. I cannot seem to figure out how to add word docs and cube views into the fields. Ideally, I would want the package to populate out a cover page which would be summary of MTD and YTD results followed by a page for both results in Income Statement format with a variance explanation page last. Thanks for any help in advance

Hey All,We got a recent requirement of implementing a conditional statement inside the cube view columns. The user wants to calculate a certain column on the basis of the value of another column. The design is explained below:If B <> 0 thenD= B+Celse if B = 0 thenD= A+CABCD1010020120 (100+20)200130150 (20+130)0203050 (20+30)I'm currently facing difficulty to implement this solution inside the cube view. My first shot was trying something in the XFBR string but that I couldn't get around the logic to implement the same.Any leads will be appreciated. Thanks!Pragyanshu BansalJackLacava OSAdmin 

Is there a way to drill through the entity hierarchy in a Quickview that shows the total of Top in the Consolidation dimension? I have users asking me if this is possible.   In the example above 87M is the total amount of the child entities including eliminations showing in the second Quickview but no total. The first Quickview is at local before eliminations therefore doesn't addup to the total of 87M. I've tried to use CAD but get the same numbers as local.    

Hi, All, I am planning to generate the report for users who are active/inactive, last login date? I am reviewing the Framework audit tables however I couldn't find exact fields. Can you please let me know ? thank you

Hi all,I have a simple cube view where on the row I have Tree expansions, like the following one:UD5#MemberName.TreeThe reason I am using Tree instead of TreeDescendantsInclusive or others is because I want the rows to collapse on opening  and RowExpansionMode=CollapseAll only works with Tree for the first dimension of the row as far as I now.Now, the issue is that I would like to remove a member from the rows and the Remove does not seem to work on Tree, while it works on TreeDescendantsInclusive and others.U5#MemberName.Tree.Remove(U5#None) returns this (expansion enabled=yes, none removed=no):U5#MemberName.TreeDescendantsInclusive.Remove(U5#None) returns this (expansion enabled=no, none removed=yes):Is there a way for me to have both the ability to expand/collapse the rows and remove members from the hierarchy, or it is just a trade-off with the impossibility of having both at the same time? Thank you 

Hi All,I am trying to use a font in Onestream which seems to be working fine in the cube views and Excel extract, however it it does not work in PDF. May I know the reason why it is not consistent? I have updated application properties, hard coded in business rule, and added the font family in the cube view itself. But does not work on PDF which is the most important one.Any suggestions?

Dear all, Is there a way to show for instance journal data and also identify which are the names of the journals involved in a given intersection? For instance if there are 3 journals going to the same intersection, recover in a CV 3 lines, describing the detail for each journal name? Thank you in advance.Best regards,Carlos

Hello, we encounter the following behaviour with the OneStream Desktop Client and the Excel Add-In: The Server Adress URL is stored in c:\users\[username]\AppData\Roaming\OneStream\Common\Settings\webserverurl.txt As soon as I click connect, the URL stored in the webserverurl.txt file gets deleted with the next start of the desktop application or the Excel Add-In, the Server Address field is empty and I have to get the Connection URL by clicking the three dots next to the Server Adress field (which is quite annoying). Does anyone of you encounter the same issue? Regards Martin Gebhartl

Is there an audit on FX rates, to see who updated the FX rates?

Hi,I have created a dashboard with a Reset Scenario button.The code behind the button updates the workflow time, wf start time and wf end time of the workflow scenario (there is actually a dialog dashboard in between, i.e. when I press Reset a dialog box opens asking what the new WF Time should be, and user can press OK to reset the scenario or Close the dialog. WF Start and End times are determined based on the WF Time).The issue I have is that the workflow POV does not change, unless we click on a different workflow step, which can be confusing. So if I change the WF Time of the scenario member, using the Reset button from 2024 to 2025, the workflow time POV (the one shown in the OpenPlace tab) does not change, but as soon as I click on the following step (eg. Seeding) the workflow time POV changes to 2025.How do I make so that the Reset button forces the workflow POV to refresh? Do you think is something that I can achieve at dashboard level (through refresh or redraws) or business

Spoiler (Highlight to read)  Hi everyone,I am trying to replicate an example that i have created in OneStream 8.2, where I have a combo box inside a cubeview:But when I do the same in OneStream 8.4, the combo box doesnt work:I replicated the same parameterization in both version but I dont understand why in 8.4 doesnt work.Does anybody knows if there is a bug? Thank you   

Hi,I need help implementing conditional visibility for a button in my dashboard. In the attached image, there's a Store button that I'd like to make visible only when the "Single Store" option is selected in the Store Hierarchy combo box. When any other option (e.g., "All Stores," "Takeovers2024FY," etc.) is selected, the button should either disappear or have a different style to appear disabled.Can anyone guide me on how to achieve this behavior?Thanks in advance! 

Hi, Is it possible to create member filter in QV using Text1 that varies by Year and Scenario. Is it dynamic enough to read T# and S# of POV and use them to get Text1?  For example, I have few members with "AAA" in 2024 and "BBB" in 2025.  In other members, "BBB" is in2024, and "AAA" in 2025. I want to pull all UD2 members that have "BBB" in 2025. If this doesn't work, other way is BR "CustomMemberList" I guess. Anyone has sample code that can create list by reading Text1 in 2025? Thank you in advance, Mikki

Hi, All I have a column in a cube view for which I need to get the time description prefaced by "YTD". This was no problem for the current period as I could use a variable "wfTimeDesc" as follows: T#WF:Name(YTD |wfTimeDesc|) However, when trying it for a prior period, I couldn't find a variable to use that gave me a description.  This is close, as it returns "YTD M9 2023" but what I really need is "YTD Sep 2023": T#PeriodPrior12(|WFTime|):Name(YTD |WFSubPeriod| |WFYearPrior|) I know I could add a header row and put it underneath, but this was the request, if I can do it. Thanks in advance!    

Hi, I am creating a report for our auditors that takes the IC accounts and their elimination "Plug" account throughout the Origin dimension. I don't want to create a bunch of separate reports for AP/AR, Sales/COGS, IC Expense, etc. My thought is to define these in a Parameter and then build a book. Can anyone point me to a good starting point on how to define these 4 different drop down options? For example, the AP/AR one would include A#19999, A#29999, and A#IC_DIFF, and the report user would select AP_AR_DIFF or something like that. Any insight is appreciated - the forum has been very helpful! Thank you!

Hi All,is there any way to clear the added comments in V#VarianceExplanation/V#Footnote using rule or any other method. I tried using rule but it's not working as expected. we are storing our comments at parent entity and mostly Top members in UD dimension , please let me know if any other information required.our intersection where we are storing the comments:E#ParentEntity:P#?:C#USD:S#ActualComment:T#2023M9:V#Footnote:A#acc:F#EndBal:O#Top:I#Top:U1#TotOPU:U2#Top:U3#Top:U4#Top:U5#None:U6#None:U7#Top:U8#Top