cancel
Showing results for 
Search instead for 
Did you mean: 

Measures Getting Disappeared Once Pulling The New Dimensions In the Report.

Former Member
0 Kudos

Hi Experts,

I am facing an unusual error in my Web I report,

I've created a web i report using the Universe, the problem i am facing is once i drag any new dimension in the existing report the measure fields (key figures) are getting disappeared. ...once i deselect the new dimensions, the key figures are getting populated back.. i tried creating new report and universe, but unfortunately got same error.

My version of client tool is 14.0.6: is it a bug in this path level?

Please Advise.

Regards.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I solved this issue,

The data was getting disappeared coz of connection restriction  issues due to which it was displaying partial results in web i.

I changed the universe parameter controls and tried running the report again in web i, it worked!

Thanks everyone for the response!

Answers (2)

Answers (2)

sateesh_kumar1
Active Contributor
0 Kudos

Hi Nayab,

What is your backend ?

can you check your key figures are set to Database Delegation at universe. If yes reset to that any aggregation and check.

Former Member
0 Kudos

Back end details

SAP tales ==> BW InfoCube ==> Universe ==> Web i.

I tested things on BW side..it is working fine and populating data properly.

sateesh_kumar1
Active Contributor
0 Kudos

Hi  ,

Can you test the same with OLAP connection ?

what is the key figure aggregation in BI.

How you tested in BW side , i'm not seeing Bex query in your flow.

Former Member
0 Kudos

How are the measures defined?

Have you got a Sum() function round them?

What is the projection of the measure? Has it been set to sum? If not, do so.

arijit_das
Active Contributor
0 Kudos

After the values disappear, did you try refreshing the report ?

It can be a context issue too. The key figures are cumulative / non-cumulative ? If non-cumulative, are you pulling the right dimensions across which the key figure to be viewed?

Former Member
0 Kudos

I tried refresh the report many times, got same error, but once i remove those dimension the key figures appeared again (without even refresh)

As per the right dimension thing, my logic flow for the report is fine ( as per functional specs)

Even if i am running the report on very simple level i am facing that error; for example

I select the  basic dimension i.e Company Code with key figures Sales, Value.

Once i run the above criteria i am getting key figures like getting sales and value for company code.

Now when i am trying to put another dimension let say division in order to segregate sales and value on division level further....the key figures are getting disappeared. And once i remove division again key figures are back to chart.

former_member225163
Active Participant
0 Kudos

could you provide some additional information on this? Is there any merge dimension?

Former Member
0 Kudos

Nope, there there no merge dimensions in the output...as i said i am running this report on very basic level.

Like what ever i am having in Universe i am pulling it in the output, with out calculations and merging anything.