Reporting

Hello I have a CubeView with 2 nested rows. Row 1 - |!varEntity!|.Base (say this will return 5 entities - this is a drop down in a Dashboard) Row 2 - XFBR(myModule_ParamHelper, GetWBS_by_Entity, Entity=|!varEntity!|) This rule checks for WBSs where Text2 = Entity (i.e. WBS1 - Text2 = Entity1, WBS2 - Text2 = Entity2) When I execute the CubeView, I see all the 5 Entities, and in the nested Row, I get the WBSs where Text2 = the first Entity only). I understand why it is doing this, as the variable gets the same value and passes to the rule. I also tried |PovEntity| and |CVEntity|.  PovEntity returns blank, and CVEntity return what is in the Cube Pov section, which I tried with a value or blank. I also tried WBSDim.Base.Where(Text2 = |CVEntity|) --- or PovEntity - comes blank Is there a way to pass the value of each evaluated Entity row to the WBS row? The result should be something like: Entity1 WBS1   WBS2 Entity2 WBS3   WBS4   WBS5   Thx Raf

I have Cubeview which takes ~50 secs to refresh in OS. When I insert same Cubeview in excel and refresh in excel (OS Excel-Addin); it takes over 2 mins. It is simple insert and refresh i.e. I do not have anything additional like VBA code etc in Excel. Is it normal for CV to take to take longer to refresh in excel? Any suggestion to optimize the Cube view refresh in Excel? Many Thanks.

I am trying to utilize a combination of Year() and PeriodNext1() within a GetDataCell, and it's not working. The combination of Year() and Period() within a GetDataCell works if you surround it with brackets, but once you add the Next1, it will not work. Any ideas as to how I can accomplish this?Example of GetDataCell with Year() and Period() working fine: GetDataCell(BWDiff(V#MTD:T#|!Prompt_TimeMonth!|:S#|!Prompt_Scenario!|, V#MTD:T#[Year(|!Prompt_CurrentYear_Comp2!|)Period(|!Prompt_TimeMonth!|)]:S#|!Compare_Scenario2!|))Example of GetDataCell with Year() and PeriodNext1() which gives an error:GetDataCell(BWDiff(V#MTD:T#PeriodNext1(|!Prompt_TimeMonth!|):S#|!Prompt_Scenario_FW!|, V#MTD:T#[Year(|!Prompt_CurrentYear_Comp1!|)PeriodNext1(|!Prompt_TimeMonth!|)]:S#|!Compare_Scenario1_Bgt!|))Error Message Received:Thanks!

Dear community, Can you please suggest me way to get report of two cube view in single dashboard. in pdf and excel format. Any solution to this will be very helpful, Thank You

Is there a way to get a dashboard to open up when the user click on a BIViewer component? Updating the Navigation Action here under Component Properties doesn't seem to work with BIViewer component.

Anyway to put the company logo at the bottom? I have just seen that we can move it at the header but not the footer.

Does anyone know what the attached "KPI" component is?  I attended one of the OneStream Demos and they presented this dashboard with these KPIs at the bottom.  I can't seem to figure out what component they used. 

Hi,   Would be great to get your thoughts on the below:   I have 2 cubes with 2 different time profiles attached – Standard (Jan-Dec) and AugYearEnd (Sep – Aug)   I have used the below query successfully in CVs to get the time description based on the cube selection.   T#2021.Base:Name(XFMemberProperty(DimType=Time, Member=|MFTime|, Property=Description, TimeDimProfile=CB#GroupReporting_AugYE))   Variations of the above also work:   T#2021.Base:Name(XFMemberProperty(DimType=Time, Member=|MFTime|, Property=Description, TimeDimProfile=CB#|WFCube|)), à more dynamic, or   T#2021.Base:Name(XFMemberProperty(DimType=Time, Member=|MFTime|, Property=Description, TimeDimProfile=AugYearEnd))   However, when we use this in a dashboard member list parameter, this doesn’t seem to work and always returns the description of the standard time dimension. In the 'Data Source' condition of the parameter, I had mentioned the specific cube and was hoping the time desc

I am trying to suppress rows in a cubeview  that are less than 10%.  I have the variance % as show below. For some reason zero suppression threshold is not working on this data point.     

Is it possible to use the linked navigation to pull a dashboard based on a scenario? I have 2 separate dashboards that are pulling 2 separate BI Viewers for 2 separate Data adapters. One pulls data from a relational table based on actual data and the other pulls timestamp information based. What I want to be able to do is if the column is actual then pull the dashboard that has the Bi Viewer with the actual detail. If the scenario on the column is Working, then pull the dashboard that shows the timestamp info. The scenarios on the dashboard changed based on the date selected using a date selector. Currently I have both dashboards linked to each column and when you right click you have the ability to select either dashboard but I only want the user to have the ability to have one predetermined selection based off the scenario.

Hello,Is it possible to refresh XFGETCELL (excel report) automatically through OneStream and save report as offline? i was trying to achieve this by uploading excel report as .xfdoc.xlsx but i want the output as paste special values. thank you 

We have made the latest upgrade to 7.2.1. When I use the Excel Add and use the keep and delete buttons it suppresses all data in that field opposed to only keeping or removing the items that I selected. Anyone else have this issue. The other members of the team don't have this issue and we have the same settings in place.

Has anyone else run into the below issue related to Excel Freeze Panes and/or found a solution for it?Unlike exported cube views to Excel, OS does not automatically create frozen panes using Cube View Connections.  We have determined that we can apply certain Excel formats over top of the Cube View connection.  We did this with Freeze Panes setting at the corners of the first row and last column header. However, when we refresh these Excel template files a second time (i.e. after responding to parameters), the frozen panes seems to relocate up above the first header row.  This happens even though the cube view connection itself does not change in terms of it's starting position.For example:Cube view connection is set to start at cell $A$4.Freeze panes setting is at $E$7Above is saved to the Excel template which is then uploaded to OS as part of a File component.  File component is attached to a button on the dashboard that user selects to open the CV connection

Is there a way to have nested column headings centered and merged when exporting a cube view to excel? I have nested columns and want the top column header to be centered and merged over the bottom columns. It does this automatically for a pdf export but the excel export repeats the top header for each column.Excelvs. pdf   

I'm looking for a solution to create a parameter that would allow users to select from a drop-down list current and next period's scenario. I'm trying to avoid having users select the incorrect scenario for data submission via the excel add in. 

Getting below error in Data Explorer for Cube Views, can someone please help me to resolve the below error. User Interface Stack Trace: Server stack trace:at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)at System.ServiceModel.Channels.ServiceChannelProxy.InvokeEndService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]:at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)at OneStream.Client.SharedUI.DataExplorerServiceReference.DataExplorerService.EndGetDataCellsCompressed(IAsyncResult result)at OneStream.Client.SharedUI.DataExplorerServiceReference.DataExplorerService

Hi All, We have a cubeview that is taking much longer than we would expect.  It can take up to 4 minutes to run or, in some cases, it keeps going forever and we have to logout and abort.  The cubeview has time periods in the column (from a BRString) and Accounts and UD3's in the rows (also a BRString).  Replacing the BRStrings with hardcoded values doesn't really improve the performance so I have removed BRStrings from consideration.  We have also built a clean version of the cubeview to ensure there aren't old ghosts and hidden issues building this on the back of a previous cubeview used for a different purpose.  This cubeview is as clean and lean as it gets and still slow. The part that really strikes me is that if I recreate the cubeview in a quickview in Excel, it takes just a few seconds.  So a 4 minute cubeview can be a 10 second quickview.  And looking at the report, 10 seconds feels right....4 minutes seems way too long for this repo

Hi all,Referring to an old post: "Advanced" graphical content in dashboards.In a graph (created using the report component) I would like to add a trend line. Please see the picture below for clarification. This graph links to FX data (USD/EUR) retrieved in a cube view.  Is there anyone that knows if there is any possibility to add a trend line in here? Maybe someone that has experience with trend lines? The things I thought of:- Adding a trend calculation in the cube view that will be added as a separate series in the chart.     Problem: need to find calculation for trend lines which is very complex.- Data aggregation options in the chart component. (Under Series --> Properties --> View)     Problem: this doesn't seem to do anything. Not sure how to work with the 'custom' setting. - Calculated field in the field list.     Problem: I cannot seem to find the right function for the trend line (relates to problem 1).&nb

Hello,I am trying to find a way to have my variance % follow my dollar variance value.   If a favorable variance, then the % variance should also be a positive percentage.  In this example I'm looking at variance in an absorption account.  Any thoughts on how this could be done?    

Hello,We have a user who is experiencing intermittent instances.  Her CubeView connections, via the excel add in, are displaying a #Logon instead of retaining the last value retrieved.  See below.Her preference is set to "Invalidate old data when workbook is open = false". Is there another setting or preference that needs to be enabled to ensure the user sees the last value?Note: there are multiple cubeview connections in the same excel file.

When using the minimum range value in  a waterfall chart, e.g. (10) that excludes all series values that are lower than 10. Is there a way to keep those values under (10) while using the minimum and max ranges to make the chart show the small value variations with a decent scale for the eye? thanks!

Hi everyone, Is there a way to use more than the 4 offered Row/Column Overrides? Here is my problem:For a customer I have to create a report, in which among other things the sales figures of different business units (UD1) are to be seen later on an Excel sheet. Since, as far as I know, it is not possible to loop on an Excel sheet in a report, I wanted to create a cube view and list the different UD1s under each other. However, a dynamic calculation with the following formula is included: GetDataCell(Divide(CVC(ColA, 1), CVRC(RowA0, 1, ColA, 1))):Name(%) The value A0 should then be changed to B0 for the next BU. However, since there are a total of 12 BUs and 12 columns for each month, the 4 overrides are not enough. Is there a way to increase them? Or another way to get the calculation right for all BUs?

Hi everybody,Below you can see a graph created for a client.A question coming from them is that they want to align the 0 points (highlighted) of both the primary (left) axis and the secondary (right) axis. I've tried (amongst others) to change the visual and whole range, scaling options but it doesn't seem to change anything.  Does anybody know if it is possible to align the 0 points? Thanks!Floris

I am trying to see the last changes were made to an intersection. Currently I am using a UD8 to join a couple tables together and can see the last time a section was changed but my issue is run time. It will run in about 2 seconds for one account but times out if I try to run it on all accounts. It is being used in combination with an XFBR that pulls a rolling list to select days after a date is selected from a date selector. Is there an easier way to see if changes were made to a certain intersection that would run quicker?

Hi, I have an Advanced Chart where I am displaying dates.  The values, however, are stored as ticks(Long).  This is great for the bars and points, however, I need the Axis labels to be displayed as date (not Long see below).  I've tried a few versions of {V:MMM-yyyy} however, that doesn't seem to work.  I do have a business rule to work with as I'm using a secondary axis, but not sure how to target the data labels in the rule.  Any suggestions? thanks,Greg