ContributionsMost RecentMost LikesSolutionsRe: Cube/Metadata Design Question Have you considered having the Cost Centres in the Entity Dimension? You are going to create a lot of sparsity by having a 2,000 member UD1 dimension used only in part by each Entity. Member Dialog Parameter Type in a Dashboard Hi everyone, Quick question re Dashboards. When you use a parameter in a Cube View there is an option to display the Member Filter using a "Member Dialog" Parameter Type. This shows you the resu...SolvedRe: Derive account based on Data Value in Transformation Rules. One commonly used technique for value-based mapping is to bypass the original Account and create 2 Derivative Rules that prefix/append DR or CR depending on the value (use the Create If option). You...Bound List Name and Description in Display Member? Hi, Does anybody know if it's possible to configure a Bound List parameter to show both the Name and the Description as the Display Member? It's valid for Member Lists but I get an error in Boun...SolvedRe: Fact or Fiction? Every dimension needs to be defined in each Transformation Rule Profile created. Fiction Re: Workflow Overlapped siblings taking long time to load the data to cube The system is checking for overlapped WF Data Units and finding them, you can turn this check off but if an overlapping condition occurs you might find it doesn’t load data as expected. To improve lo...Re: Looking for a validation rule to validate data after transformation and before loading to the cube. Could you not use a Target Derivate Rule for this? A target Derivative Rule allows you to run logic on the post-transformed data. You could sum your records and verify they are equal to zero ...Re: Clear All Import/Forms Data from Cube Try this is in a WorkflowEventHandler Extensibility Rule. Dim returnValue As Object = args.DefaultReturnValue args.UseReturnValueFromBusinessRule = False args.Cancel = False ...Re: Fact or Fiction? Workflow Profiles can only have dependencies through a Parent/Child hierarchy Fiction. See Named Dependancies. Re: Workflow Profile's Substitution Text Settings in BRAPI rule This should work: Dim wfProfileName As WorkflowProfileInfo = BRApi.Workflow.Metadata.GetProfile(si, si.WorkflowClusterPk.ProfileKey) Dim wfText1 As String = wfProfileName.GetAttributeValue(scenari...
