Business Intelligence

PerformancePoint Planning: Deleting a Custom Member Property..

Posted on 25th November 200823rd June 2020 by Sacha Tomey

25
Nov

Update: I’ve posted a solution to Deleting a Custom Member Property here

I’ve done this countless times; I’ve created my perfectly named Custom Member Property when it suddenly dawns on me that I’ve forgotten to give it the right data type. No problem, right? Wrong! From within PBM, can you change the data type? No! Can you delete the member property? No! Can you rename the member property? No!

So, what are the options? Well, you could wait for version 2 (I truly hope you can edit/delete member properties in V2!), you could hack the back end database in the vague hope of removing the member property safely, or, as I have been doing in the past, create a new member property with a less than perfect name and try not to clench teeth and fists every time I glance at the original.

Well, I’ve had enough, and decided I’m going to take action.

Strangely, the Microsoft.PerformancePoint.Planning.BMO assembly contains a method called DeleteDimensionAttribute on the Dimension attribute collection.

I wonder…

Anyone tried?

Sacha Tomey

Pareto Charts in Power BI and the DAX behind them

The Pareto principle, commonly referred to as the 80/20 rule, is a concept of prioritisation.

Databricks: Cluster Configuration

Databricks, a cloud-based platform for data engineering, offers several tools that can be used to

AI Assistance in Microsoft Fabric

The exponential growth of Large Language Models (LLMs) couples with Microsoft’s close partnership with OpenAI

10 reasons why it’s worth the effort to understand the value of your data

“If leaders really want to create a data driven culture, the journey starts with them!

Content Safety in Azure AI Studio

Azure AI Content Safety is a solution designed to identify harmful content, whether generated by

Model Benchmarks in Azure AI Studio

In the constantly changing field of artificial intelligence (AI) and machine learning (ML), choosing the

International Women's Day

Celebrating International Women’s Day: from Classroom to Code

As we celebrate International Women’s Day, I want to share my journey of breaking stereotypes

Pretty Power BI – Adding Pagination to Bar Charts

Good User Experience (UX) design is crucial in enabling stakeholders to maximise the insights that

One thought on “PerformancePoint Planning: Deleting a Custom Member Property..”

Pingback: PerformancePoint Planning: Deleting a Custom Member Property – A Solution – Adatis

Comments are closed.