I have a cube that uses a shared time dimension based on fiscal year
starting april 1. the cube used to have the time dimension on calendar
year and now that i changed to fiscal year i get errors when i process.



Data source provider error: Incorrect syntax near the keyword 'from'



somehow i got the cube to process after this error but now when i drop
the dimension on the pivot table i see errors in my counts.. i have a
measure that does a distinct count from the fact table! please help!



thanks!


--
Posted via http://dbforums.com