on 11-08-2007 10:13 AM
Hi Experts,
We have two interesting problems on the BEX during designing a report.Details below ;
1 - we made six selections like that ;
first (named 'OCAK-try'):
0calmonth --> 001.2008, 001.2009
0currency --> try
keyfigure --> 0amount
second(named 'OCAK-euro'):
0calmonth --> 001.2008, 001.2009
0currency --> euro
keyfigure --> 0amount
third (named 'OCAK-USD'):
0calmonth --> 001.2008, 001.2009
0currency --> usd
keyfigure --> 0amount
forth(named 'EUR')
we created a calculated key figure with fixed value and assigned this selection.
fixed value : 1,69
fifth(named 'USD')
we created a calculated key figure with fixed value and assigned this selection.
fixed value : 1,39
formula (named 'OCAK') :
OCAK-try + OCAK-usd * USD + OCAK-eur * USD
when we check this formula we got the error with text 'Error at structure'. We could not catch the error code.(!!!!This is the first interesting problem!!!!!)
we defined new calculated key figure named 'TRY' and assigned the value '1' and inserted a new formula including exchange rate of try and changed the formula like that ;
formula (named 'OCAK') :
OCAK-try * TRY + OCAK-usd * USD + OCAK-eur * USD
2-After that adjustment i wrote above we wanted to see total sum of some lines of this report.
Report output was like that ;
OCAK
1.line --> 3
2.Line --> 5
3.Line --> 12
total sum --> 1.line2.line3.line
We thought that total sum will be equal to 20.However, total sum ( = 1.line2.line3.line ) was equal to 60.
We tried for only first line it was 3. (total sum = 1.line)
We tried for first and second line.it was 16. (total sum = 1.line + 2.line)
!!!!This is the second interesting problem that we got at same BEX report!!!!
Our BI version is 7.0
What can be the problem?
Thanks,
Kevser Aydin
check sap note 1007360 and the related notes. also check sap note 1089582
we are getting odd results in very simple formula and also some rows in a query have no data when it should.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.