OLAP Data Grid
hi,
i'm building multidimensional cube has multiple measures, , trying figure out how provide users ability "slice , dice" running multiple queries against same cube. may getting greedy in terms of olap api can do, have folllowing questions:
1) possible in same query both filter on members in non-displayed dimensions , use non-default measure in cells? can 1 or other in same query using slicer axis, not both.
2) if i'm using max or min aggegratror, possible determine tuple populate cell, or have go flat data , find answer there?
any appreciated!
i'm building multidimensional cube has multiple measures, , trying figure out how provide users ability "slice , dice" running multiple queries against same cube. may getting greedy in terms of olap api can do, have folllowing questions:
1) possible in same query both filter on members in non-displayed dimensions , use non-default measure in cells? can 1 or other in same query using slicer axis, not both.
2) if i'm using max or min aggegratror, possible determine tuple populate cell, or have go flat data , find answer there?
any appreciated!
1. can build cross join of non-default measure , filter members achive this.
2. not possible find flat data resulted in max or min value. tweaking max/min aggregators , storing id of flat data item might possible link data.
2. not possible find flat data resulted in max or min value. tweaking max/min aggregators , storing id of flat data item might possible link data.
More discussions in Flex (Read Only)
adobe
Comments
Post a Comment