Reporting

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 

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

Hello - I am working on a cube view where I would want the resulting values (variance amount) to sort with the highest value first. The complication is, my users are used to reports from Hyperion that enabled expansion drilldowns on these members. The Hyperion reports retained the sorting even when using expansion. I can't seem to figure out how to do this in OS - or if it is even possible - when selecting a member expansion (.Tree or .Base).  Wondering if anyone else has attempted this.  Thanks,Cody 

Does anyone know how to add more than 2 custom titles on a row?  Below is the view of 4 headers.  I can change the name on 2 but not 3 of these titles.Member filters are below.  I have custom name at the end of my Time and Scenario member filters.  I want one more on my View dimension.This does not work...    

Hi all -I am creating a cubeview that seems basic at first glance, but have ran into some walls as I am still new to using cube views on my own. What I have is an entity, net sales, profit, profit margin, months, and a changing scenario.I want to see net sales, profit, and profit margin for the current year. This part is simple enough and will not move.However, I want to compare these same metrics to various other scenarios, one scenario at a time. I want to be able to select something like prior year actuals, budget, or any forecast and see the figures come in for it in the second/lower half of this cube so I can then make a comparison between current year and whatever selected scenario I have. Is the best way to do this to create a parameter for the scenario and then write in that parameter name in the necessary rows for the scenario?Additionally, if I wanted to create a better/worse row, would I be able to easily do that even though one of the two scenarios could change at

I am trying to create a quickview that would require the data presented to consider some account configuration that only appears on the decendents set up.   ex i have a parent member P that has multiple children and would like use a where clause to exclude IsIC data. i tried to do A#P.Base(IsIC False) but this results in multiple lines where i would want to only have one line presented that is removing the data associated with the children that are IC. is there a function that would let me create a summary line while still checking the descendent configuration?

We are trying to format numeric columns in a Table View but haven't been successful. The numeric columns are currently appearing as 999999.99 instead of the desired 99,999.99. Are Table View currently looks like this:The Spreadsheet Table View rule is defining the numeric columns here:sql.AppendLine( ",FORMAT(SUM(ISNULL([V4],'0')),'N2','en-us') As [Gross Revenue]")Thanks

I am building a Rolling Forecast scenario (eg. name is RFC 2+10) using the below formula snippet which takes the current month actuals, and adds the future Budget scenario. It works well so far, however when I use the scenario in a cube view, I'd like to use the headers based on the source data. So in RFC 2+10, columns 1 and 2 are actuals, and 3 to 12 are Budget. But for each column it just shows RFC 2+10 - is there a way I am able to write something or use some conditional formatting so that show Actuals/Budget based columns?Thanks