Question:
Does anybody know how to do this???
I have a Cube with Area and Product Line. The balanced Scorecard is one for all the company. So that, has no detail for Area or Product Line. However, the client ask me to tell him whem Revenue for one of the Product Lines is less than X.
The problem is that I don't know how to make the difference between the Product Lines. I allways get the sum of them in any way I define the query.
Is there anything I can do in the BSC??? Is ther any query desing that can help me???
Please, give me any suggestion you can think of.
Thank you very much in advance,
Raespu
_________________
Raśl Escudero
Answer:
Make your query design in a way that the result is only the Product Line you want to compare.
The BSC is not connected to a Infocube, each of you indicators can have diferent sources.
Regards,
nelson