WebI Report using BW Query

[Former Member]

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?

[former_member142702 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

Sorry, I forgot to mentioned the calculation of Formula.

Here is the Formula:

NDIV0(NODIMC('Gross Weight'))

[IngoH · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

Hi,

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

ingo

[IngoH]

Hi Nisniki,

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

thanks

Ingo

[Former Member]

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

[former_member142702]

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]

Hi,

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