#nodata error in SAP BPC

[Former Member]

Hello Experts,

I am using SAP BPC NW 10.0.

I am getting #nodata error in a report only in quality environment.

The error is on the column having the EPMMemberDesc() formula implemented as a local member in the report.

The same report displays all the dimension member description in development environment but shows #nodata error for few members in quality environment although member description for the dimension members are available for all the dimension members.

Also , excel is correctly showing the active connection of the environment too.

Please suggest the possible solutions that can be applied.

Best Regards,

Remya

[Shrikant_Jadhav · Accepted solution]

Hi Remya,

Use EPMMemberID in formula.

Do you have same member ID in other dimension ?

Shrikant

[Former Member · Accepted solution]

Hi Shrikant,

Actually I need both the member IDs and their descriptions in the report.

No the IDs are unique used only in the same dimension.

Best Regards,

Remya

[anil_agrawal]

Freinds,

I found that if we have a same description to multiple member then only for those description we see #NoData rest description will show correctly.To resolve this either make description unique or use EPMMemberID function to read ID.

Thanks

Anil

[former_member186338]

"make description unique" - impossible in most cases.

"use EPMMemberID function to read ID" - correct!

Vadim

[Former Member]

Hello Experts,

The isssue was with the Master data loads in the quality system.

Members of Account dimension were also getting loaded in Entity dimension in our quality system.

On using EvDES() function we were able to retrive the descriptions correctly.

Thank you all.

Best Regards,

Remya

[Shrikant_Jadhav]

Hi Remya,

As I have suggested in my first reply "Do you have same member ID in other dimension ?".

It's good that problem is resolved,

Kindly close threads if queries are resolved.

Shrikant

[Former Member]

Hello Experts,

Sorry for the delayed response.

As suggeted by Gajendra, I have created the local member using "EPMMemberDesc(EPMDIM_CURRENT_MEMBER(ACCOUNT)".

No issue with cell reference too.

To be on the safe side I have even provided the second optional parameter i.e Connection name in the function(EPMMemberDesc(EPMDIM_CURRENT_MEMBER(ACCOUNT),OPEX)").

@Vadim : We dont have descriptions in multiple languages.

The starnge part here is description for few members are visible but not for all.

Also ,the same template functions correctly in our development system but not in the other system.

Regards,

Remya

[former_member186338]

To be 150% sure - please set in user options: Use EPMMemberID in EPM formulas!

Vadim

And what do you have in B28?

[Former Member]

It contains the Account dimension members(Row axis of the report) from B28 onwards, implemented as :EPMMemberDesc(EPMDIM_CURRENT_MEMBER(ACCOUNT),OPEX)")

We have implemented similar formulas in multiple reports in diffrent models with different dimension and it works fine.

So I have an element of doubt is it related to that particular dimension in the system?

Regards,

Remya

[former_member186338]

Sorry, but once again:

"what do you have in B28?"

What exactly!

Vadim

[gajendra_moond]

Hi Remya

Please share a screenshot of this dimension with its members and their description. Just want to be sure if descriptions even exist for the codes showing "#nodata"

[former_member193143]

Hey Remya,

Completely agree with Gajendra, if you use cell reference and then added a extra column then you need to change the local member formula to point out the correct cell.

Lets consider an example here below

intially I created a report like below.

Same report in Formula view.

later inserted a column then see the behaviour of the report.

See the formula view after inserting a new column. its still pointing to F14 only.

In order to avoid this kind of errors please use same formulas as gajendra suggested.

Thank you ..

Saida Reddy Gogireddy

[former_member186338]

Sorry, but isn't it strange that only some descriptions are #NoData???

[gajendra_moond]

Agree. I wondered the same. One possible reason could be that values from some other column are being referenced for description and that column is being calculated using some formula which is not behaving correctly. That is why we need more details. However would like to see if using EPMDIM_CURRENT_MEMBER would result in the same error.

[former_member193143]

Hello Vadim,

yeah its strange for me also, don't know why its showing like that...

May be those member id's are picking up from cache memory, which are picking correct member id's.

after some changes may be new members comes into picture.. but its all my guess not sure what's the exact reason..

Remya can you please try to clear your metadata cache and try to refresh your report..?

and post the result still you getting the same result or not ..?

regards,

Saida Reddy Gogireddy

[gajendra_moond]

Hi Remya

Kindly provide more details as requested by others.

Also in your local member formula, instead of using EPMMemberDesc() and providing excel cell reference, use =EPMMemberDesc(EPMDIM_CURRENT_MEMBER(Your Dimension ID))

You do not need to provide cell reference then.

Another possible reason of the error is the incorrect formula you have written in Local Member Formula.

[Former Member]

Hello Vadim n Rohit ,

Please find the screenshot of the report.

A/C CODE :contains the Account IDs (Account dimension members)

DESCRIPTION : implemented as local menber using EMPMemberDesc(<cell reference for Account ID>)

As stated, description for few are displayed but not for all.

Best Regards,

Remya

[former_member186338]

"with detailed explanation" - !!!!!

Show formulas in the cells!

Do you have descriptions in multiple languages?

[Former Member]

Hi Remya,

Can you check the row nos ref in your Local formula, and also can you show us Formula you have written.

As per attachment, you Id and Descriptions are starting from row nos 28, So pls check the row ref in local member formula.

Rohit

[kamalkishoreg]

Hi Remya

I am thinking error may not be because of the setting, It could be b'coz of master data. Like may be short description is not available for all of them?

Its worth a check.

Thanks

Kamal Kishore Gajula

[Former Member]

Hi Remya,

As said by Mr Shrikant, use EPMMEMBERID in formula. If still you are not able to get the description, can you please share screen shot of ur report/template.

Regards

Rohit

[former_member186338]

Possible solution: provide a report screenshot with detailed explanation!

Vadim