cancel
Showing results for 
Search instead for 
Did you mean: 

WebI Report using BW Query

Former Member
0 Kudos

Hi,

I am using WebI Report using BW Query. I don't see some Formulas in Universe which is there in BEx Query.

Did anybody face the same problem before?

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi,

I meant that you should post in the forum the calculation contained in the formula that you cannot see in your universe.

But let's start from the begining since you are new to SAP: Did you generated the universe yourself? If the formula was added in the query after the universe was created then you must refresh your universe (In the Universe designer please select the option "Refresh structure" under the "view" menu) in order to get the newly created formula (I assume we are takling about a calculate figure here) in your universe also.

Regards,

Stratos

Former Member
0 Kudos

Thank you Engo and Stratos. I have created Universe after creating Formula in BEx query. The formula is converting KG's into Tons in the BEx query. Even I have refreshed the Universe two times but I don't see Formula in the Universe.

Former Member
0 Kudos

Sorry, I forgot to mentioned the calculation of Formula.

Here is the Formula:

NDIV0(NODIMC('Gross Weight'))

IngoH
Advisor
Advisor
0 Kudos

Hi,

so do you see the measure at all in the Universe ? a Forumla should just become a measure in the universe.

ingo

Former Member
0 Kudos

Ingo,

This is interesting. I found that formula in Measure in Universe but the name is different, but When I ran the report, I am getting the correct result.

IngoH
Advisor
Advisor
0 Kudos

Hi,

so thats good news. Different in what way ? You should see the description of the formula

ingo

Answers (2)

Answers (2)

IngoH
Advisor
Advisor
0 Kudos

Hi Nisniki,

you saying that a formula you created in the BI query is not showing in the Universe ?

thanks

Ingo

Former Member
0 Kudos

Yes, the formula Created in BEx Query, I am not able to see in Universe.

0 Kudos

Hi,

just pick one of the BW query formulas you are missing in the universe and post it here. May be the problem has to do with the operators you are using in the formula.

Regards,

Stratos

Former Member
0 Kudos

Hi,

Thanks for the reply. I am new to SAP, how can I pick the formula from BEx query and paste it to Universe?