Adding custom fields to OLAP Cubes
We are trying to add some custom fields - like Manual Activity Support Group, to the Out of Box cubes. The fields are in the Datawarehouse, but not showing in the cubes.
We logged this with Microsoft and got this response:
Actually we don’t recommend to extend cube partition groups or dimensions as there will be many schema changes happen in the AS database. It will definitely impact the future patches (UR, SP, etc) and other unpredictable potential issues. According to the complexity, if you can take the risk and offer around 30 hours, we can help research and provide you the sample management pack for how to add custom properties in default cubes. Please let me know your opinion.
Has anyone done this, and if so how?