vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| hi all, i was finally excited when i got to process the whole cube without the errors. but now im facing another catastrophe!! when i try to browse the processed cube, dragged the gross revenue measure and the hierarchy on the rows, i get repeated values on the measures ! pls check out image below: http://www.picoodle.com/view.php?img....png&srv=img34 |
| ||||
| Sounds like same problem I just answered another post with: Sounds like you need to adjust your Dimension Usage tab in SSAS. If you don't create the correct relationship - you will get funny results - such as the same value in your counts all the way down as you browse the cube. When I recently implemented a many to many cube this was a real challenge for me - but I got it. Concentrate on one dimension at a time - like just get the Gross Revenue one working first. In my many to many cube I use mostly the "Many to Many", and "Regular" relationship types. I've yet to come across some good articles on the Dimension Usage tab for SSAS - so if anyone knows of any blogs, books, or graffiti - I would like to hear. "ChiWhiteSox" <ChiWhiteSox@discussions.microsoft.com> wrote in message news:C1857CF6-DE27-422E-BD3E-2CD5AB37A8E0@microsoft.com... > hi all, i was finally excited when i got to process the whole cube without > the errors. > > but now im facing another catastrophe!! > > when i try to browse the processed cube, dragged the gross revenue measure > and the hierarchy on the rows, i get repeated values on the measures ! > > pls check out image below: > > http://www.picoodle.com/view.php?img....png&srv=img34 |