Search
Search

# Problems with BEX

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

##### Former MemberNovember 09, 2007 at 03:11 AM0 Likes
View more on this topic or