ContributionsMost RecentMost LikesSolutionsRe: Connect MS Fabric Lakehouse? Hi, We've done this recently via a SQL Endpoint to Fabric. The client created an Azure Service Principal Account with access to the relevant views and tables and we used those details in the Connec...Re: Changing the UI Language I don think there are any options to change the language of the main UI. Re: 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 ...
