Error with BEx Analyzer

[Former Member]

Hi Frndz,

I 've loaded succesfully transactional data into a cube and able to view it properly.

But when i create a query and try to analyze tht in the fields of keyfigures in addition to the velue loaded ERROR text is also displayed.......but the data which is displayed is correct.

Plz suggest me how to get rid of tht ERROR text in BEX Analyzer

One more thing is in case i wanna create a calculated KF

Say for eg Profit have i to create tht infoobject priorly or at the Query creation time itself i can directly calculte tht value if i've already KF's COST n REVENUE.

Regards

Madhavi

[Former Member · Accepted solution]

Hi Madhavi,

Regarding your second point:

You can create a calculated key-figure directly at Query creation time.

Remember though that this key figure always wil be calculated during query execution. So if you use that key-figure a lot, it is better to add a key-figure to the cube and calculate it in the update rules. This will increase performance.

Udo

[Former Member · Accepted solution]

Hi Udo,

could u plz suggest me how to write a routine here in update rules clearly,

Bcoz when iam trying to write the code profit = revenue - cost and check it,

it displays unknown fields revenu........then i've mentioned structure /bic/revenue/

but still still its thowing me the same msg.....

Plz provide me vth the solution.......

Regards

Madahvi

[Former Member]

hi Mahavi,

you getting this error, because you using wrong currency key. if u using cost n revenue, u must mention currency field in your infoprovider

[Former Member]

HI RAJA,

I've assigned 0currency for both cost n revenu, at the same time when i drag these infoobjects into the infoprovider tree ie to infocube automatically 0currency field is added in the unit dimension..........

anyhow thanks 4 the response

Regards

Madhavi

[Former Member]

Hi,

It seems that currency field is not mapped in update rule or transfer rule . After mapping it properly and uploading data again query will show corresponding currency.

Hope that helps.

Regards

Mr Kapadia

[Former Member]

Hi,

Actually i did'nt find any mapping prob in the Transfer rule as well as the data in the info provider is displayed correctly with out errors..........

[Former Member]

Hi

Goto RSD1 -> Put key figure name and click on display

In the type/unit tab page you will find "Unit/Currency" this is a info object which should be there in info source , if it is not there you need to add it in infosource, data target , update rule . Once this is mapped properly then do the data load and it should get through properly.

Hope that helps.

Regards

Mr Kapadia

[Former Member]

For error text reload your text master data.

For profit c.kF you can create at query creation time.