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 |
|
arifsharif_2001
Starting Member
1 Post |
 Posted - 2008-07-14 : 03:41:06
|
| hi, this is arif iam facing problem while drilling the cubethe sample Cube which is provided: AdventureWorksDWCube Name:adventureworkdwDimension :GeographyHeirarchy:city,country,state province,postal code,geographyheirarchy country:australia,canada,france,germany,united kingdom,united statessimilarly state heirarchy is having state related to above countries,city heirarchy is having city related to above state,Postal code heirarchy is having postal code related to above city heirarchy. heirarchy:Geography: consist info in this format in an web application:i want to display the information in this formatCountry-->state-->city-->postal codefor example:United States--> alabama-->birmingham-->35023United States--> alabama-->florence-->35630 i have added adomdclient reference to my web projecti created the connection string and initialize.i even populate the cube in dropdownlist.when i have selected the cube name, iam populating all the dimension.when iam selecting the dimension(in drop down list), it is populating the heirarchy in another dropdown after that iam unable to drill down in heirarchy. iam using c#any one can help me out in this issue with sample.. regardsarif shareef |
|
|
|
|
|
|
|
drill through the cube (ssas)