Marc Solomon on 04 Sep 2015 04:57:49
As I write each PBIX I find each time I need to create my date dimension, with some data from my transaction system and several calculated columns.
This is for more than just the date Dimension, I have Dimension tables in the data warehouse I regularly use and want to be able to bring them into the PBIX in the same way each time for consistency.
I think what I am proposing is a Dimension template which can be applied to a PBIX file.
- Comments (1)
RE: Create a dimension template
I would love to see something like dataflows but at the table level and extended to the modeling layer with the ability to preset visible columns, sort by columns, naming, hierarchies, groups, etc. for PBI developers to use a la carte. Ideally, there would be a way to identify the business ID and surrogate ID fields for easy implementation by the developer. Basically, the individual table components of a semantic layer. This would help mesh our centralized and self-service BI teams together using a standard set of data. This could also be a solution for Kimball conformed dimensions and the bus architecture which is currently a gap in PBI.