Discuss the features and functionality of OneStream.
Recently active
I am trying to build a cube view where the client can insert suppressed row members for account, ud3, and entity with ud3 having 2000+ members. I can't figure out how to work the suppression so it only shows the top row and allows the user to enter in the suppressed rows without having all combinations visible through expansion. Currently it is showing all possible combinations or no combinations. Thanks in advance for the help!
Is it possible to build a Business Rule (Dashboard Extender) that connects to and updates the Task Scheduler Table without the use of a BRApi? Our team is currently connecting to the table using BRApi.Database.ExecuteActionQuery. This function allows users to update the Task Scheduler through a dashboard. But we would like to find an alternative approach to updating.
If each Cost Center is mapped to a single profit center, can that be stored as a Text attribute in the metadata and then referenced in Transformation Rules?
Does anyone have any sample code they can share to see how to trap errors during an automated dataload process? Currently, all I can see is that the dataload process executed and completed but it does not tell you if something happened in between. I'm having no luck capturing if an error was encountered during the import or validate steps.
This is my first time creating a book. I'm working on creating a book that presents an income statement by location. The ideal outcome is that the IS is displaying location at the top and each subsequent page displays a child location member. I have my loop setup as a member filter that references the location dimension as shown below. My change parameter is setup to change the POV. When I preview the book it's still showing location at TOP for all the pages instead of showing TOP and then each location base member. Any suggestions on how to fix this or any literature would be appreciated. Thanks.
Hi Community ! Is there a way to get the culture of the user, by using a retrieve function like XFGetCell? Basically, I have to retrieve the user culture in an Excel file in order to define Titles and other periferical elements in the spreadsheet. Regards,
how can i get 2 columns on a quick view to be shown as %?
We are trying to develop logic to do the following during transformation: If the G/L account in the load is in a certain range and the UD2 member is valid, load to that intersection otherwise If the G/L account in the load is in that same range but the UD2 member is invalid, map UD2 to None Has anyone gotten something similar to work? Thanks,Bil
Hi to all, Im looking for any idea on how to inactivate users automatically. Let me know your thoughts.
Hi to all. Wondering if any of you have been able to connect PowerBI as a data source in Onestream. In this case, PowerBI is an Analysis Service server. any thoughts on how to start doing that? Thanks in advance
Please see this post from Adam. Posting on his behalf. I also want to know the answer to this.
GOALExport cube view to Excel with Landscape printing orientation. METHODThere is a cube view setting on the Advanced tab, labeled as Landscape = True/False. I have set that setting to Landscape = True. RESULTAfter exporting to Excel, the cube view fails to take on a landscape orientation, instead being portrait orientation. Does anyone know how to set the Excel orientation within the cube view?
I'm trying to figure out how to build an expression that pulls "Avg Fleet" numbers and plot a bar chat on an existing pane. I've asked a similar question in this post - I was able to make the syntax work. However I still can not isolate just Avg Fleet. I would appreciate any suggestions on what I should fix. I've been fairly new to Dashboard building that I need help to my bearings. Co
How do I generate reports in a loop for each member (branches) and send it to single excel file? I have a cube view report which I'm trying to run for multiple entities member (100+ locations). Any idea will be appreciated.
Hi, I have a list of "segments" in the text 2 property for each Entity. For each Entity I would need to see these "segments" as columns in a cube view, so I need to return a "member list" however these "segments" are separated with a pipe ("|") delimiter in the text 2 property. The above "segments" in the Text 2 line are already defined as UD2 members in the Dimensions section. I was investigating the use of an XFBR formula however I can only return the first member list in the Text 2 property and not a list. Any advise would be helpful. Thanks
Dear Community, I have a use case where the user would like to change a value by clicking a button. when I click on the "+" icon, it will add 1 into my parameter shown in the label, and when I click on "-", this would remove 1. Very simple, it can be done just with an input but I would like to do it with icons just for fun 🙂 Basically, this looks like this : I was thinking of using an XBRL but not sure on how it would fit ? Regards,
Often global companies may report a metric like units sold or volumes in a stat account. But that unit of measure may vary by region or country. Below is one option for handling the conversion of stat accounts like units sold or volumes. For example: Metric Ton to US Ton Kilograms to Pounds Liters to Gallons Etc Here are some high level ways to tackle this in an application. Considerations: Entities are tagged with currency already Normal Revenue/Expense account types will naturally get “AverageRate” table PVA method (all else equal) Normal Assets/Liability account types will naturally get “ClosingRate” table VAL method (all else equal) You need to identify which accounts (aka UNITSSOLD) need a translation rate table that differs You need to identify which entities are sending which volumes to drive translation to use different rate table Your conversion rates do not vary over time so you really just need to store these
Hello! I received a request to add a maximum and minimum line to a cube view. The cube view shows entities in columns and a variety of accounts in the rows (not together in a hierarchy, so no .base or .children, just a list separated by commas). Max/min aren't available in the "getdatacell expressions" area so I emailed support to see if it's possible and they directed me to a ranking BR in GS. I loaded the BR, added a row to my CV and updated the pull but still am getting no data. Honestly, I don't think this BR and pull are the solution for what I'm trying to do but I don't know of any other way. Do any of you have samples of pulling something similar? Were you able to get a max and min in a CV via CV math or some other way? Appreciate any help I can get - thanks! Here's the KB article provided for reference: And the GS CV is in CVs > XFR Member filters (E) Member list using business rule > XFR Member List (C) Ranked Entity Sales.&nbs
Hello community, We are trying to prevent the end users from uploading a data file on an import workflow step that is certified.To do so we have started using the the TransformationEventHandler in the Extensibility Rules. We are able to get into the right code:Select Case args.OperationNameCase Is = BREventOperationType.Transformation.ParseAndTrans.StartParseAndTransformFrom here, we have access to the workflow step arguments TransformationEventHandlerArgs (for example the file that has been uploaded etc).We know that we can get access to the certification status from DataQualityEventHandler business rule using:Dim CertifySignOffInstance As CertifySignOffInstanceInfo = DirectCast(args.Inputs(2), CertifySignOffInstanceInfo)and Dim signOffState As Integer = certifySignOffInstance.SignOffStatewhere signOffState = 110 or signOffState = 130 means that the workflow is certified. Which is great. The question here is how can we get access to the CertifySignOffInstance from&
Does anyone know how to extract data using Data Management pulling C#Elimination and a dynamic entity filter such as E#TOTALCO.Descendants? A parent entity is required but I have been unsuccessful at different options for the parent filter such as E#Default, E#TOTALCO.Descendants, E#|PovParent|.
Originally posted by Chul Smith 1/11/2018 Is a re-implementation necessary to change their calendar in their app? or can they just change it? They're on monthly, would like to stay on monthly, but change from calendar month to 4-4-5 month
Is there a way to customize the charts in TM dashboard to show category 2 values as X axis?
As the title mentions - I have these months (Apr, May, Jun) that we haven't reported any numbers. How can I suppress the values within Cube view? I want this to be dynamic that if current reporting month is April 2022, then suppress all the future months from then onwards (show zero or blank).
Hi, I am looking for a Business Rule (DataQualityEventhandler) to send e-mail notifications when "Set IC Transaction Status" is used. I know how to send e-mail when the "Set IC Transaction Status" is used. The challenge is to get the comment and other information from the ICMatchStatus table and to pick up the e-mail addresses to send to. So, I want to check for the entity in the ICMatchStatus table and all users with access to that entity should then receive the e-mail notification. I want to use the e-mail on the users to create the e-mail list for sending e-mails. It's more or less the same as with the journals. If a journal is for example created, then an e-mail is sent to the users that can approve the journal. The e-mail will then also contain the journal they are suppose to approve and/or post. This I have, but the ICTransactionStatus is a bit Regards, Peter
Hi, We have a requirement to get the Text fields for 5 columns. So, getting these we have used the "Data Attachment Members in the View Dimension: Annotation, Assumptions, AuditComment, Footnote and VarianceExplanation" and able to get the required text with using Member formulas. Could you please let us know if there are any performance/other impacts with using more cell text options use in Cube views. Thanks, Madesh
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.