Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
walidwalid
Starting Member
12 Posts |
 Posted - 2008-10-07 : 06:35:16
|
I tried to create a report in reporting services 2005 connected to a cube created using analysis services 2005.I want to display some data from dimension called Exp_2006 which has a hierarchy called Exp_2006 this hierarchy has self join relation.See the figure (1) :[URL=http://up5.m5zn.com/photos/00320/tz5gg0ob5t8j.jpg] [/URL]When I tried to to drag this hierarchy in a table the data did not appear.I think that the problem because of the hierarchy.See the figure (2) :[URL=http://up5.m5zn.com/photos/00320/u8vi1u4f6hb2.jpg] [/URL]So how can I display the data from this hierarchy.Thanks for Administrators,moderators and Members. |
|
|
|
|
|
Problem in displaying hierarchy dim in Report