cancel
Showing results for 
Search instead for 
Did you mean: 

Extra rows in report

Former Member
0 Kudos

Hi

I have an issue with a report which is based on a multiprovider.

In the report, I have columns GL account, nav attribute of GL account Expense type, Fiscal period and KFs.

When I run the report, for the same GL account I see two entries - one with Expense type value populated, and another with Expense type blank

I looked at the GL account master data and it does not have any blank Expense types. Why do I see this on my report?

Please advise.

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

Expense type is a navigational attribute of cost element.

So I checked the master data table, and there are no blank expense types.

Former Member
0 Kudos

May be some other key is causing to have duplicate data in target.

Can you try to restrict # for expense type in report?

Abhijit

Former Member
0 Kudos

Did you check the mapping is good for Expense type in Multiprovider? Though it is a nav attribute, I still beleive it is good to check data through"Multiprovider" as it might show you blank values if mapping is not good.

Good Luck!!

VJ

Former Member
0 Kudos

- Cube might have been loaded with blank Expense Types

- Technically KF values are available with blank Expense types

-- Display data in the multiprovider or cube to check exactly where Expense types are not filled

VJ