Question Re: EPM Report Property Filter Issues in Financial Management Q&A

EPM Report Property Filter Issues

former_member424490 — Thu, 24 Mar 2016 09:47:37 GMT

Hi All,

We have got a problem about reports with using account property filter.

Briefly, after copying live system to test system, our reports with using account property filter which is running accurately at live system, aren’t running at test system.

For example, when we make a report by choosing account with the member and the descendants at test system, there is no problem.

On the other hand, when we make a report by using account property filter at test system, some account values aren’t coming accurately.

However, in both cases which I metioned above are running accurately at live system.

Could you help us in urgently to solve the problem?

B.R.

Re: EPM Report Property Filter Issues

Shrikant_Jadhav — Thu, 24 Mar 2016 09:58:51 GMT

Hi Hasim,

What do you mean by


 some account values aren’t coming accurately..

If you are talking about transaction data, Have you tried to create report without filtering and selecting members manually ?

Share the screenshot.

Shri

Re: EPM Report Property Filter Issues

former_member424490 — Thu, 24 Mar 2016 12:10:36 GMT

Hi again,

I want to explain our problem with below example. I hope it will be more clear for you.

We inserted a property being called "Budget Input" to Account dimension.

When we make a report by choosing account wtih the member and the descendants at test system, there is no problem. As you see at below example, the value of account "1200011" is coming.

However, when we make a report by using account property filter at test system, some account values aren’t coming accurately. As you see at below example, the value of account "1200011" isn't coming.

On the other hand, when we analyze the value of account "1200011" at BW side, we see accurate value.

I hope, these examples are more clear for you to solve the problem.

Thanks in advance

Re: EPM Report Property Filter Issues

former_member186338 — Thu, 24 Mar 2016 12:16:29 GMT

Hi Hasim,

What is the property ID? "Budget Input"?

Then try to rename it to something without space inside!

Vadim

P.S. You can use Property description with space, but the ID have to be without space...

Re: EPM Report Property Filter Issues

former_member424490 — Thu, 24 Mar 2016 12:27:58 GMT

Hi Vadim,

Our property ID doesn't include any space, we use space only at property description.

I think, our problem is not related with/without space. You can see our property ID at below image.

Thanks in advance

Re: EPM Report Property Filter Issues

akos_beres — Thu, 24 Mar 2016 12:31:44 GMT

Hasim,

can you share the page axis or the context selections for both of the reports?

Akos

Re: EPM Report Property Filter Issues

former_member186338 — Thu, 24 Mar 2016 12:35:42 GMT

Then - no good idea

Try only property filter (without BS member and descendants). What you will have in resulting report?

Vadim

Re: EPM Report Property Filter Issues

former_member424490 — Thu, 24 Mar 2016 14:54:41 GMT

Hi Vadim,

Thank you for your response.

I tried only property but result does not change.

There is also strange situation maybe help for solution.

I create new report with member recognition using base accounts like 1200011, 1200061.

It works fine but add parent these accounts below, again report is empty.

Re: EPM Report Property Filter Issues

former_member186338 — Thu, 24 Mar 2016 15:01:04 GMT

Ups... looks like SP issue!

Please provide full details for core BPC and BW versions and SP

Also EPM SP

Vadim

Re: EPM Report Property Filter Issues

former_member424490 — Thu, 24 Mar 2016 15:13:17 GMT

Dev

prd

epm 10.0 sp 24

But production system reports work properly.

Re: EPM Report Property Filter Issues

former_member186338 — Thu, 24 Mar 2016 15:25:35 GMT

I suspect BW SP (very old by the way). After BW upgrade T think the issue will be solved (have something like your issue in past!).

Vadim

Re: EPM Report Property Filter Issues

former_member424490 — Thu, 24 Mar 2016 15:35:53 GMT

Thank you for your help Vadim, I will talk our basis team, after upgrade I am going to inform you. But production is ok, are you sure about the upgrade is solution? Both system is same level with all components.

Best regards.

Re: EPM Report Property Filter Issues

former_member186338 — Thu, 24 Mar 2016 15:50:37 GMT

May be there is some small difference... You can spend a lot of time trying to find it!

And SP upgrade is good for many other reasons

Re: EPM Report Property Filter Issues

former_member424490 — Thu, 24 Mar 2016 16:10:17 GMT

I hope upgrade help us.

Thanks a lot Vadim, you are the king of BPC