Reporting

Hi All,We would like to draw up some dynamic QV's from a time perspective & always have them aware of the current time so we can utilize the T#PeriodPrior1() MF rule. I'm curious how others have made these dynamically change, we were considering a BR to update the 'Global Time' on a systematic basis and then we could direct users to use this global time & know that it is always reflective of the current week. Maybe I'm overlooking some function of OS to do this but it seems like there isn't a natural dynamic time option.Thanks,Bryan 

SOURCE: ONESTREAM CHAMPIONSis their an option to input dynamic charts in cube view? I am creating a CV that calculates and pulls top 10 branch contributions, and projects in a visual chart.If it won’t work…is their any other way?Thank you for you help.

Hello,I would like to know, if it is possible to format only one word of a text or label in a dashboard :- Do you have examples of formatting only for one letter or one word within a sentence ?- Could we use conditional formating in order to format only a specific word (for instance, a user login) ? Many thanks,

Does anyone know if there is a way to suppress “Background Task has Completed” messages?

SOURCE: ONESTREAM CHAMPIONS Hi Team, I wish to know few features are possible in the Spreadsheet or not while using the Table View functionality. there are some Enumerated fields stored in the table, say for example 0 or 1 (stored in the table) but I want the user to save it Yes / No in the spreadsheet - not sure how to achieve it? Also to make sure that some other junk value should not get updated here, an Error Message should be popped up if the value is not per standard or some color code change. How to make the cell - color filled for specific header columns - blue or so, indicating read-only cell. How to format the numbers to 2 decimals. Color Code change if the cell is dirty ( the same way it works for cube View ) Referred 1 document from OneStream Table View reference guide, which enabled to help to fetch the data in Spreadsheet using table view… but questions to above queries are not yet clear. Hope team members here can share your experience, which we can re-use Re

SOURCE: ONESTREAM CHAMPIONS Hi, We are looking to take the values of a specific column and divide everything in it by 3. Was hoping to accomplish this via a Column Override. In the Cell Format within the column override we have tried several variations of the following without any luck: If (CellAmount > 1) Then /3 EndIf Thanks for your help.

SOURCE: ONESTREAM CHAMPIONS Hi Team, we have a situation in which we need to create a new dimension every month, and can obsolete the earlier one for the next period, that works perfect. no Issue here. but since they share the common workflow, in the Entity Filters both the old Dimension and New Dimension are appearing. Expectation here is to get Display on the New dimension in the current period and only the old dimension in the previous filter ( Refer screen shot for more clarity ) Since the filter is based on Entity calculations, not sure what’s the solution to achieve the same. I need some inputs to get the filter dynamically listed based on the Year / Period we choose. Regards Darpan Bhansali      

SOURCE: ONESTREAM CHAMPIONS Hi Team, do we need to put some specific settings to connect the External DataBase… when we are connecting it via SQL Table Editor. i am getting the below mentioned error ( where as the same connection works via Data Adaptor )   Subledgers _ External.png977×467 21.7 KB   Regards and Thanks Darpan Bhansali

SOURCE: ONESTREAM CHAMPIONS     Hi Team, I am facing a typical issue ( Error Msg 1) while uploading the data from an excel. where as the code for csv upload works fine. Refer the Code attached here by for reference. can any one help here to find what wrong am i doing in the below code. Also i want to fetch the range selected somewhere in the error log… or the message box… how to achieve that ? Also i could not find and XF Market place solution which enables this excel upload feature, Any guess on that as well. Regards and Thanks Darpan Bhansali

SOURCE: ONESTREAM CHAMPIONS Hi Friends, Did anyone try inserting rows into a custom table ( within one stream ) using Spread Sheet? I am able to update the data into the custom table, but somehow the basic functions like insert didn’t work for me. I need a similar function as per the screenshot for identifying the new records and the existing records.   https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/1c5dee15c2a1bb8d86b5682de4f4220b3122a2bd.png Expectation in SS.png966×362 20.1 KB   Regards and Thanks Darpan Bhansali

SOURCE: ONESTREAM CHAMPIONS Champions,Is there a way to have a Studio report recalculate a value at a group summary level instead of having the report sum up values from the detailed band? In example below, the ROI% as the 401 Total line is displaying 4.7% which is the summed up total of % from detail records. This value should instead be recalculated as Total Net ROI / Total Revenue = 510,000 / 15,000,000 = 3.14% In Studio, Is there a way to define a calculated field that uses data from other fields on the same band i.e. the group total Net ROI and Total Revenue?   https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/ad449b0c9dc199805a6c0159e56cea02d6698bfb.png image.png1046×396 8.73 KB

Hi, I wanted to remove + sign and show all the row , remove the collapse function please help

Hi, Is there a way to call a dimension parameter in a QuickView? If we put for example UD1 in the rows in our QuickView and instead of choosing a dimension member for the rig we choose a parameter we get a “#error - The member filter contains unresolved parameters.” The parameter does work in a cube view. Thanks!

I just had a call from an Excel user who uses the OneStream addin. He has a number of reports that he's been using, but they're working differently today, and we don't know why. Instead of retrieving all of the records and exporting them to a single page, he's getting about 59 entries on page 1, and then page 2 has the next 19 entries, and 23 entries on page 3. I don't know what the pattern is that is causing OneStream to separate these among several pages. Is there a preference or an option that controls this and that he might have accidentally changed that would cause his retrieval to be paginated?

Hi All, I was wondering if it was possible to pass through an XFBR to cube view column / row sharing.  In this example, we are trying to dynmically have the column template passed through to the cube view using the XFBR string. The string is looking at the workflow and based on the name of the workflow profile the rule returns a specific column template.  When I stick the XFBR string into the column sharing I receive the following error:   Any insight on how to most efficiently do this would be greatly appreciated! Cheers, Amar  

Dear Community -  I'm building a dynamic prior year formula for my Variance Cube view. However I want to pull the MonthNo (e.g. M10) from the parameter I have |!SelectCol1Period!|  so that it can reference the accurate period based on selected by user period. Currently it pulls the PY from POV instead of what the user has selected as his time period.  Wondering if their is an API function to call a parameter?  Here is the code I'm working with: Dim SelectedTimeMonth As Integer = api.Time.GetPeriodNumFromId(api.pov.Time.MemberId)Dim SelectedTimeYear As Integer = api.Time.GetYearFromId(api.Pov.Time.memberid)Dim PYTime As String = (SelectedTimeYear - 1) & "M" & SelectedTimeMonth Dim Amount As Decimal = api.Data.GetDataCell("U8#None:T#" & PYTime).CellAmount Return Amount   Here is the front page of my cube view:  Let me if I can answer any questions.   Thanks for the help.  

Hello All, I have requirement to present a number from an external table in cubeview so that number and a cube datacell number displays side by side. It is like doing a recon between two systems. Has anyone ever done that? I know I can do it in a dashboard using dashboard extender BR and display in a pdf report but I need to capture some comments from the user and store it in the cube that’s why trying to see if a member formula can do it so that it can be used in a cube view report. Are there any example anywhere in golfstream app to reference? appreciate any help.

I know when you open a cube view report as PDF it puts logo automatically. Is there anyway it can be displayed in excel export? never seen or done it but wondering if someone did it or have a work around. I have a requirement where we are doing an export of a Book in excel workbook (multiple tabs based on a loop in the book) and want to have the logo in the output so users don’t have to add it manually.

Dear Community,I was wondering if there's a way to have a component "embedded dashboard" that would target a Dashboard from another Maintenance Unit ?The idea is to open a dashboard ( Predictive Analytics 123  dashboard) as an embedded dashboard in my global navigation dashboard which is in another maintenant unit. Regards,

Originally posted by Henning WindhagenHi All, did anyone here write a macro in Excel to kick off "Submit data"? A customer wants to enhance his data submission from Excel and was asking me about this.

Hi. I have created a new Quick view report for the first time. I've set the POV parameters, the column dimension is Time and the row dimension is account. The report is not showing any values. I've drilled down to the base accounts. Still nil. Any idea why this might be? 

Source: OneStream Champions   Hi, is there a way to hide/format these repeated text in CV excel settings? I would like for e.g. “ProSolutions” to show once for every stats section.     image.png444×661 8.47 KB   Thank you!

Source:   Migrated from Champions Hi Team, Hope you are safe and doing well.I am attempting to display members using the if-else condition in cubeview.Does anyone know if it’s possible to use the if-else condition in Member Filter Builder Cube View? Thanks in advance

Source:   Migrated from Champions Hey Everyone, I am trying to create a report/cubeview for our regions. But how do I get the dynamic calculation inserted into my CV? (Highlighted Yellow) Do I need to approach it differently? Here is an example of what I am trying to create -   Thanks

Source:   Migrated from Champions Hi All,This is my first time posting and happy to do that!I’ve built a cubeview showing the clients in rows and Revenues in columns but struggling to sort my client based on the revenues (descendant).Is there any effective way to apply descendant / ascendant sorting ?Thanks