hi,
this is arif iam facing problem while drilling the cube
the sample Cube which MS has provided: AdventureWorksDW
Cube Name:adventure work
Dimension :Geography
Heirarchy:city,country,state province,postal code,geography
heirarchy country:australia,canada,france,germany,united kingdom,united states
similarly 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 format
Country-->state-->city-->postal code
for example:
United States--> alabama-->birmingham-->35023
United States--> alabama-->florence-->35630
i have added adomdclient reference to my web project
i 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..
regards
arif shareef