Sequence Contains No Elements

[arunkumar_vr]

Hi Experts,

I am new to SAP BPC and is in the process of self learning.

I have created dimensions and a new model. Now I want to fill some master data from flat file to one of the dimensions. For this purpose I am opening the excel add-in and then trying to connect to my newly created model. But it is giving error "Sequence contains no elements". However I am able to connect to the standard models already existing in the system. Please help.

Regards,

Arun.

[Former Member · Accepted solution]

Hi Arun,

You need to process all dimensions properly.Add a dummy member for each dimension in your model and process it.

Also you need to check access has been given properly or not.

Thanks,

Firoz 

[arunkumar_vr · Accepted solution]

Thanks a lot Firoz. I created dummy values in all dimensions and it worked.

[Former Member · Accepted solution]

Hi Firoz,

Even I got the same issue. your solution solved my issue but

What is the need of dummy members here ?

cant we create with out dummy members ?

[former_member186338 · Accepted solution]

For each dimension you need to have at least one member to be able to connect to the model.

Vadim

[Former Member · Accepted solution]

Yes, you are right.

But what is the reason to have minimum one record in dimensions to connect to the model ?

[former_member186338 · Accepted solution]

Internal design of BPC