1

Mondrian is indeed a good example, in that it's a ROLAP engine (in which MDX statements are translated to SQL which are then fired to the underlying database (other than it caches results, so ends up being a Hybrid approach instead of pure ROLAP). However, the "translation" between MDX and SQL isn't a straightforward one. A lot of MDX statements require ...


1

you can do this with help of MDX Custom filer on filter option when we generated report for cube. there you write query regaring dimension table and fact table with help of select measures.[attribute] on rows from cube name where conditon apply . and so on...


Only top voted, non community-wiki answers of a minimum length are eligible