cancel
Showing results for 
Search instead for 
Did you mean: 

Values In BEx Query ...

Former Member
0 Kudos

Hi Experts,

This may be a simple question but I'm stumped at the moment. Does anyone know how to get the values to repeatedly display throughout the column? I've built a report on the standard payroll cube. I'd like for the values of 0employee, dates, subgroup, etc to display all the way down for each record. Example:

Employee PayDate Gender Language Wagetype Amount

1234 1/1/04 M EN 1001 $1000.00

1002 $100.00

1003 $30.00

Instead I'd like:

Employee PayDate Gender Language Wagetype Amount

1234 1/1/04 M EN 1001 $1000.00

1234 1/1/04 M EN 1002 $100.00

1234 1/1/04 M EN 1003 $30.00

Any help would be appreciated.

Thanks,

Meezy

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Meezy.

Just go to the query properties -> display -> uncheck hide repeated key values.

Hope it helps.

BR

Stefan

Former Member
0 Kudos

you rock Stefan.

Thanks,

Meezy

Answers (0)