Custom sum RRS feed

  • Question

  • I have fact table that contains entities named "Akt". Akt entity has a field named Value(decimal). each Akt has one or more Persons who need to work with it. these peoples are stored in crossjoin table (aktSolver) id_akt , id_solver. Demand is to see data sliced by solvers. when I create view in DSV by joining these tables I get separate row in fact table for each solver. because of that my values are multiplied by the number of people who are joined to certain Akt as "solvers". when I use pivot grid I get wrong results. I'm not using parent child hierarchies.

    How can I correct this issue?

    Thanks in advance!!

    Tuesday, April 20, 2010 11:32 AM