Hi ,
I created an OLAP cube . I then created the dimensions and measures
etc. to the letter . When I ran the 'Browse Data' after creation I
originally got the 'Cannot browse data in Cube 'Test'. Unspecified
error' msg . I installed SP2 and then it ran properly . But now an
addtional problem has come up . The OLAP Cube Browser displays the
headers properly but all the data cells show #ERR !!! When is
right-click - cell properties,it gives me 'Unable to display cell
properties . The handle is invalid. Error occurred during attempt to
get a cell value . ' I know tht the correct DSN and db connectivity
etc. is implemented beacuse the headers are displayed correctly and
those are retrieved from the db .
What do I do at this point ?

--
Dev Noronha


Posted via http://dbforums.com

ok , i redid the entrie thing .... setting fact table, dimensions ,
measures, set storage option to MOLAP ,aggregates and processing ....
and now it works . i dont know wht i did wrong in the first try though .
any suggestions , pls write in .

--
Dev Noronha


Posted via http://dbforums.com