Ragged Dimension

I have a created a ragged dimension on OLAP manage but it is not being
displayed properly in Excel. Whereever empty level is there, excel displays
same value as parent. Any idea why it is happening ?Hi,
this is the expected behavior, if your dimension based on a flat dimension
table. To avoid this try a parent child dimension table.
hth
NGE
Am Thu, 11 Dec 2003 19:58:06 +0530 hat Zubin Dhamodiwala
<zubin@.godrej.com> geschrieben:

quote:

---

> I have a created a ragged dimension on OLAP manage but it is not being
> displayed properly in Excel. Whereever empty level is there, excel
> displays
> same value as parent. Any idea why it is happening ?
>

---

Erstellt mit M2, Operas revolutionrem E-Mail-Modul:
http://www.opera.com/m2/|||Disadvantage with Parent Child is that you cannot levels in it. It works
with only two column in a table, a key and parent id. But my dimension have
multiple levels and they are unbalanced.
"Nice Guy Eddie" <a_hard_days_night@.web.de> wrote in message
news:oprz2a0xqw1ak0mc@.news.misag.com...

quote:

---

> Hi,
> this is the expected behavior, if your dimension based on a flat dimension
> table. To avoid this try a parent child dimension table.
> hth
> NGE
> Am Thu, 11 Dec 2003 19:58:06 +0530 hat Zubin Dhamodiwala
> <zubin@.godrej.com> geschrieben:
>
>
> --
> Erstellt mit M2, Operas revolutionrem E-Mail-Modul:
> http://www.opera.com/m2/

---

|||Hi,
I'm not sure, if I understand...In a parent/ child table you can have
levels and you can have unbalanced trees. Why not?
Example:
Dimension table
col_child (pk) col_parent
child_1 parent_1
parent_1 parent_11
child_2 parent_11
Result:
parent_11
parent_1
child_1
child_2
You have tree levels and a unbalanced hierarchy...
Greetings, NGE
Am Fri, 12 Dec 2003 16:29:05 +0530 hat Zubin Dhamodiwala
<zubin@.godrej.com> geschrieben:

quote:

---

> Disadvantage with Parent Child is that you cannot levels in it. It works
> with only two column in a table, a key and parent id. But my dimension
> have
> multiple levels and they are unbalanced.
>
> "Nice Guy Eddie" <a_hard_days_night@.web.de> wrote in message
> news:oprz2a0xqw1ak0mc@.news.misag.com...
>

---

Erstellt mit M2, Operas revolutionrem E-Mail-Modul:
http://www.opera.com/m2/