Answered

Customize Production Cube

(1) Share

Report

Posted on by lispyj

2,745

I need to add the ProdPoolID field as an additional dimension of the ProductionTable Measure Group on the out of box Analytics page. I can extend the ProdTableExpanded view to add the field, but that is as far as I can get.

Is this even possible? If not, what do I do? Duplicate the entire Production Cube?

Categories:

BI and Analytics

All responses (3)

Answers (1)

lispyj 2,745 on at

Like (1)

Report

Customize Production Cube

A final wrap up post for this thread.

I think what confused my here is that adding to the view via Extension in AOT does not seem to make the field available in an Entity Store element that is based on that view. If I have that incorrect, please let me know!

The steps to correct this small issue are mind boggling. Again please correct me if there is a better way.

- copy the production cube in the AOT and make the edit, deploy ( I had to copy both the production cube and the Production Order aggregation)

- in the Entity Store UA, refresh the new store to populate the data.

- copy the pbix of the Production Performance power bi report from the Resources node of the AOT

- add the copied pbix as a new resource in the AOT

- change the Datasource of the pbix from old Production Cube to New

- Extend the Production Performance Form

- Add a new group at the same level in the form design as the PowerBIReportGroup and set the Width and height to largest available.

- Hide the original PowerBIReportGroup

- Create an extension class on the form to initialize the new report ( See Add analytics to workspaces by using Power BI Embedded - Finance & Operations | Dynamics 365 | Microsoft Learn)

- Build and deploy

I still have some tweaks of the form display, but this is what I have so far.
Verified answer

Bill Ngo 261 on at

Like (0)

Report

Customize Production Cube

.Hi Lispyj,

You need to duplicate the entire ProductionCube into project because by design, system does not allow to extend Cubes. Below is the step by step instruction.

1. Extend ProdTableExpanded view into your project instead of ProdTableExpanded table.

Drag and drop the ProdPoolid field from the data source's prodtable table into the View's fields.

2. Now you can duplicate ProductionLevel in the Aggregate Dimensions into project and change the name as ProdPool. Modify this Aggregate Dimensions ProdPool as follows:

3. Duplicate ProductionCube in the Aggregate Measurements into project and change the name as you need (e.g ProductionCubeTEST).

- Click Right mouse in the ProductionCubeTEST node to create New measure group. you can to keep/delete Company and Date_ dimension or not it is up to you.

- Click Right mouse in the Dimensions note and create New dimension name ProdPool > in the Dimension name, search and select ProdPool dimension declared in step 2 above.

Now you have a new ProductionCubeTest to be able to filter by the ProdPoolID in your box Production Performance analytics.

I hope the above steps are helpful instruction for you.

Rgds,

Bill
lispyj 2,745 on at

Like (0)

Report

Customize Production Cube

I keep trying ways to do this and failing. My goal is to use the out of the box Production Performance analytics, but I need to be able to filter by the ProdPoolID, a standard field on the Production Table.

Can anyone lead me through the process of making this happen? I have added the field to the ProdTableExpanded, which is the basis for the Production Order Dimension in the Production Cube. I don't seem to be able to extend the Dimension or Attribute, so I need to know where to go from here.

Can anyone give me a step by step instruction?