Parent-Child hierarchy - SSAS - Excel - Probem while browsing cube

Question

 

When you browse the SSAS cube using Excel ( Pivot ) and include non hierarchy member in Row Labels, it does not display parent members.

Example

Dimension : Metrics

Measure : Transaction Amount

When you Add Metrics hierarchy ( parent child )  at Row Labels, you get something like this.

                                                                                                Transaction Amount

Metrics                                                                                 3000

                Total Income                                                      3000
                                Income from Software                  2000
                                Income from hardware                 1000

Now, if you remove Metrics hierarchy ( parent child ) and add Metrics description attribute of metrics dimension to Row labels, you get something like this.

Metrics Description                         Transaction Amount

Income from Software                  2000
Income from hardware                 1000

So, basically Excel ignores parent members like Total Income.

Is there any way to display parent member while using metrics description attribute?

Many Thanks

---

Mayur

Answer 1

Hello,

pivot dispaly what you drag in the Pivot. If you have only Metrics description attribute, you don't see the Total income attribute.

In your case you maybe see the total activating the "grand total" on the pivot.

HTH

bye

---

Norman

Answer 2

hi,

I have metrics dimension with 4 attributs.

Metrics           - Key
Metrics Code  - Regular

Metrics description - Regular

Metircs Hierarchy - a Parent child hierarchy ( based on metrics table itself )

My question is when i select a Metrics hierarchy it shows me the totals correctly. but if i drag the metrics description in Excel Pivot it does not show the parent attributs.. it only shows child attributs. What I am missing here.  Please help . Thanks in advance.

---

Mayur

Answer 3

Hi Mayur,

This behavior is by default, Metrics Description is just a attribute,which is not user-hierarchy, so Metrics Description has no Parent level. If I misunderstand you, please feel free to let us know.

Thanks,

---

Challen Fu

TechNet Community Support

Answer 4

Thanks Challen, I understood what you are saying but Can i change this default behavior with setting some properties ? because I have expected that if I drag "Metrics Description" then it should display all records inside metrics dimension table at one single level ( no matter whether its a parent or a child ).

Many Thanks

---

Mayur