Situation: measure calculation is "a/b*c", where "c" is number of days per quarter (accumulative: Q1 = 91, Q2 = 182, and so on). The "a" and "b" is available in the system. What should I do to have the "c" dependable upon the quarter, so that BSC measure in SEM can see it? And ofcourse I need only one calculated key figure (not separate for each quarter), because in SEM I can only connect one BW figure to a given SEM measure.
Anybody any experience like this?
Thanx in advance!!!
P.S. I couldn't find SEM forum - please let me know where to go with this question, should this forum not be the one. 😉