Discuss the features and functionality of OneStream.
Recently active
Is there any way to get the cube view profile and Group Name of the CubeView using Business Rules?Thanks.
Hi, Did anyone have any situation when they deleted a DM Job by accident? How can you retrieve that? There's no Orphaned area for DM jobs for us, unfortunately. I can't find any back up for it. Would save us a lot of time if we avoid rebuilding it. Thanks in advance. Regards, Irina
Hi Team,I wanted to insert a text to data cell (for example 'Add comment'). Is it possible to be done by using api.data.calculate?This is how I see this:Dim Comment As String = "Add comment"api.data.calculate("V#Annotation:A#xxx:F#xxx:O#xxx:I#xxx:U1#xxx:U2#xxx:U3#xxx:U4#xxx:U5#xxx:U6#xxx:U7#xxx:U8#xxx=" & Comment) Thanks a lot!
Recently I heard in these forums that FDX methods (like FdxExecuteCubeView) should be used from a BR whenever the performance of the data is critical. Can someone help me understand why they are faster? We've already built quite a lot of client-integration software using cubeviews. The cubeviews are being executed via the REST api. We are retrieving data with "api/DataProvider/GetAdoDataSetForCubeViewCommand". Now that I have discovered the "FDX" methods, it puts me in the troublesome position. I realize that a ton of our integration software should probably be re-written to use those FDX methods. The re-write may take some time. Why won't onestream just extend the "normal" cubeview interface of the REST api, and add an option to run it in FDX mode? That would be similar to the "turbo" buttons they used to put on a the tower of a PC to make it run faster (for those users who had a preference between a fast computer and a slow one.) It would be h
I want to execute a list of DB Stored procedures after executing a DM step in OS. Is it possible to call a DB Stored Procedure from OS?After the Stored Procedures are run, I want to execute a list of DM Jobs for data imports to cube.Appreciate any pointers how I can implement this.
First time poster here! I created a data source called Vista that has 4 different entities using it. Each of those 4 entities has their own Workflow Profile and each entity is “assigned” to their respective Workflow Profile. In the Data Source, how do I address this in the Entity field? Is there a formula I can use to pull the Entity name from the Workflow Profile that is selected by the user? So if the user is importing the “Chicago” entity (which is assigned to the “Chicago” Workflow Profile), can the Data Source somehow read that?
We have users that frequently desire to mass updates to their transformation tables. We use the TRX download/upload process to export current mappings and upload changes. This works great except the TRX buttons are only available to administrators. I believe that these should be available to admins along with anyone within the assigned maintenance group. Is there a way to provision this?
Hi, I can't seem to find a method in the api that accepts a substitutionvariable object and returns the string value of that substitution variable. Or just get a dictionary of all predefined substitution variables and their values. Is this or something similar available?
I have tried with the suppressions to make the cells that have 0 disappear but it has not been effective. In the first cell I would show how the data is arranged, and in the second image how I would like it to be
We are trying to create a form with external vba code to refresh automatically once the onestream addin- refresh workbook.
I am trying to create a dashboard with GridView as the component. In Gridview am using Dataadapter (SQL Query). I want to pass parameter to the GridView when displaying the data in the dashboard. Can someone help me on this. Thanks & Regards, Madesh K
You can only enter data for up to 12 months in any given Workflow. Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
hi,Am looking to trigger the Finance Business rule from the DM step.Below is my snippet , but the DM step is not triggering the finance BR . Thanks
Hi all, what do you usually suggest to clients as last step of a budget/forecasting cycle, to Close the workflow hierarchy or to Lock its workflows? I am just checking if there is any disadvantage by using one against the other. Also, is there a way of automating the closing/locking so that it is trigger on a certain date? I was thinking I can may create a rule encapsulated in a data management job and schedule that, but is there an easier way? Thank you
HelloI have created a "level 2" transformation rules on ICP dim in order to force certain accounts to be filled in specific fixed IC elements.Do I have: - "level 1" with One-To-One Mappings. - "level 2" with a composite filtering on the account A#[140305] "Level 2 Composite" is completely ignoredWhere am I making the mistake?Thanks in advance for the helpMarcello
Hi,I have created some new balance sheet accounts relating to Right Of Use Assets, I have copied the structural dimensions from my existing fixed assets, so that every member property field matches. I use a generic cubeview for recording opening balance adjustments, when I key into all my other balance sheet accounts, then the derived value flows through the remainder of the year. This happens regardless of which is the first month I key into. However, for my new ROU accounts, it does not do it. The values just show as 0 and I have to key in the actual value manually each month thereafter. Here is some sample data to show what is/is not happening. Also, it does not matter which month is the first month.So what have I missed in creating these ROU account codes in the member properties ? They use the same flow constraint as my other fixed assets, so it's not that.Where else do I need to look ?CheersMark
This may be a long shot but I was wondering if there was any kind of functionality to have a message appear if you leave a dashboard page/try to close out of it. The use case is that I have a dashboard that has a button that is hitting when a conference call happens and it updates security groups so certain users can't make updates during the call. I have another button the user SHOULD hit when the call is done and this will put the security back to what it was originally. If the user of the dashboard forgets to hit that other button at the end of the call then the security never changes back. Was hoping to give a pop up message or something that forces the user to hit that end call button so the security goes back to what it was.
I'm getting the message "'Function GetLiteralParameterValue(si As SessionInfo, isSystemLevel As Boolean, parameterName As String) As String' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibility with old XF versions. Please change your code to use supported functionality.'." Anyone know what object & method should I be using instead? strSomeString = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si,Nothing,"pm_SomeParameter")
Is it possible to update the Application Security roles with in an extender Business rule? I want to be able to update the Modifydata role with the push of a button.
Hi AllI am updating the Admin Consolidations Dashboard (ADM) so that only some users can execute a Force Consolidate. I can hide the radio button group if the user does not have access but I am struggling to update the radio button group (Consolidate/Force Consolidate) so that the correct option is selected. The list of values for the radio button is controlled by a parameter (pm_ConsolType_ADM). In the LoadDashboard event I have updated this parameter using SetLiteralParameterValue (using v6.8). I am assuming that this is how the radio button selection is controlled as I can't find anywhere else where it can be set. If I click on the 'Reset parameter selections' it works.I have tried unsuccessfully to Redraw the dashboard like this:Dim selectionChangedTaskResult As XFSelectionChangedTaskResult = New XFSelectionChangedTaskResult()selectionChangedTaskResult.ModifiedSelectionChangedUIActionInfo.DashboardsToRedraw = "2_1_AutomationTasks_ADM"Any help you can give me is much appreciate
Hi All,I am trying to create a simple view using SQL in BR. it works if do it directly in SQL server so no issue with the syntax. When i am trying to do the same using a BR it gives this error: anyone seens this and know the reason and how to resolve it?Code:
Hi, I have this loop that use multiply unbalance to get the UD3 member segmented in the accounts, this is the current rule but it's not delivering good performance: I try to recode the rule like this but is not calculating as the loop: Thanks for your time,
When I use the Pre-Aggregated Member settings, it is copying the data twice. I've tried multiple settings and multiple scenarios.For example, I have tried just O#Top=O#Forms. After I run the consolidation, there is data in both O#Import and O#Forms, doubled. It also happens with multiple Dimensions. I've tried O#Top=O#Forms,U5#Top=U5#PlanningLoad and the data is doubled in both Dimensions
I would like to create a derivative transformation rule that will add _Qty to the end of the Account and pull the ActualQuantity field from the data source as the Amount.My DataSource has a field for ActualQuantity.I have a Derivative Rule that looks like this:The complex expression on the derivative rule is:this returns 0 instead of the amount in the ActualQuantity field. Thank you in advance.
Hi,I am experiencing a strange behavior with a piece of code in the drill back of a connector rule.I have the following piece of code: If StageTableFields.StageSourceData.DimUD1.XFEqualsIgnoreCase("Zero") Then whereClause.Append("And (Department IS NULL) ") 'Else ' whereClause.Append("And (Department = '" & SqlStringHelper.EscapeSqlString(sourceValues.Item(StageTableFields.StageSourceData.DimUD1).ToString) & "') ") End If When the ELSE condition is excluded as above the first IF works:However, with the ELSE condition included (see code below) the retrieve from the Zero values does not work anymore: If StageTableFields.StageSourceData.DimUD1.XFEqualsIgnoreCase("Zero") Then whereClause.Append("And (Department IS NULL) ") Else whereClause.Append("And (Department = '" & SqlStringHelper.EscapeSqlString(sourceValues.Item(StageTableFields.StageSourceData.DimUD1).ToString) & "') ") End If Any idea why this is happening? Thank you
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.