cancel
Showing results for 
Search instead for 
Did you mean: 

Row has measure value but no dimension object value

former_member672670
Participant
0 Kudos

Hie Guys,

I'm running into a strange situation in my report. The report has 2 columns - Department Name & No. of employees. All the rows have values for no. of employees but some rows do not  have values for department name. Any idea why this could be happening? Thanks.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Jeewan,

As some of our experts said, it could be the issue with few of database records itself having no dept name.. Check with your source data first..

Former Member
0 Kudos

Jewan, Firstly check your query in database.

If  DEPT_NAME values are NULL in database, Just apply filter on DEPT_NAME at your report level and select all DEPT_NAME except NULL.

Former Member
0 Kudos


Jewan can you  run your query in DB  and see how many records you are getting , as you have the values at DB or not  .

Former Member
0 Kudos

Hello Pandey,

I think Department name have null values... try filter on department and apply "is not null"..