cancel
Showing results for 
Search instead for 
Did you mean: 

BPS Lead Column Settings

Former Member
0 Kudos
56

Wondering if anyone else has encountered this:

We have Layouts where we would like a dynamic selection of Cost Elements in the Lead Column plus 10 more rows that are locked as comparison.

To accomplish this, I made the setting "Key Figures in Data Columns, rows defined individually." I then made the Lead Column dynamic for Cost Element. This seems to work well, it pulls Cost Elements from the Planning Package and lists them before my 10 defined rows.

The problem is that we want to make the setting "From Transaction Data"...not every Cost Element. This setting seems to be ignored since I set the dynamic Lead Column. This is not correct. Every Cost Element is pulled-in, even those with '0', making the Layout very unfriendly.

I'd appreciate any help!

Cheers-

Luke Rudnick

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Luke,

Did you check in the cube to see if those zero records actually exist? If they exist in the cube, then they would be included in the layout.

Mary

Former Member
0 Kudos

Hi Mary-

I checked...no zero records. I think it's not working as it should. Opened an OSS.

Hope you are well.

Luke

Answers (1)

Answers (1)

Former Member
0 Kudos

I don't see where is wrong in your procedure, but one solution to bypass the situation is to use a variable. You define a variable for Cost Element and restrict it to your desired values. Use this variable in your dynamic lead column.

Hope to see what's the real problem lying behind.

FF

Former Member
0 Kudos

The problem with using a Variable is that the set of desired Cost Elements is different for each Cost Center. We only want to display Cost Elements for which there is transaction data. That setting normally works fine, but not in this case.

Regards,

Luke