Hi Hope this example helps you understand Hierarchy and how to implement it.
I'm not clear how to feed ReportsPath.
However, I have a SQL table with all measures saved rows by rows. These table has a primary key composed of projectid, year and month.
Do I transform my SQL table in another one? I need to put into the chart year and month as two dimensions.
Do I need to implement an hierarchic structure data or does it exist another manner to reach my goal?
I think that using an hierarchy it isn't the right solution. I don't have a table with each row for each node.
I have tried to simulate the effective SQL table in this simple mode:
load * inline [
MARGIN, MarginAmount, INVOICED, InvoicedAmount, COSTS, CostsAmount
MARG, 2, INV, 3, COST, 2
MARG, 3, INV, 5, COST, 5
MARG, 1, INV, 3, COST, 5
MARG, 2, INV, 1, COST, 1
When I put on a pivot chart MARGIN, INVOICED and COSTS as dimensions and sum(InvoicedAmount) as an expression, I have INVOICED as the child of MARGIN dimension and COSTS as the child of INVOICED dimension, but also COSTS is a child of MARGIN.
Any helps to me, please?