Edit initial view for datasource not working

[Jan_van_Ansem]

Hi Design Studio guru's,

I was wondering if one of you could help me with the following.

I have successfully added a datasource to my application. The datasource is based on a BEx query, and I can see my data both at design time and at runtime, regardless if I execute locally or on the BI platform. So far so good, all connections and settings seem to be correct.

However, when I right click on the datasource in the 'outline' pane and choose 'Edit Initial View' I get the following pop-up:

"Failed to initialze the editor for data source "DS_1" (see error log for details)"

The error log in the Designer Application does not show any further messages.

I can see the Editor screen under the pop-up, showing the 'measures' and characteristics from my datasource and the different areas for rows, columns and the background filter. It also shows the live preview with the data I expect.

When I confirm the error message the pop-up with the error message and the editor disappear....

If anyone could help me out with this one I would be very greatful - I am running out of ideas.

Many thanks in advance,

Jan.

[Jan_van_Ansem · Accepted solution]

I managed to trace down the root cause. Bizarely it is down to one specific info object.

My query is based on COPA cubes in BW, which contains IOBJ 1CUDIM (Original Curr./Unit).

As soon as I take this IOBJ out of the query, the editor for initial view is working. Put it back in again and it stops working. I have ruled out that it is caused by the number of IOBJ's - even if I have just a few characteristics in my query, the behaviour is the same. 1CUDIM makes the editor crash.

I will log a customer service message in OSS and hope it will be resolved in a next release....

In the meanwhile, if someone else using Design Studio on BW using a BICS connection could test this as well then it would confirm that it is a SAP bug and not related to my installation.

Cheers,

Jan

[jeroenvandera · Accepted solution]

that's indeed a bizarre cause. Nice one to find though!

Jeroen

[Former Member]

Hello Jan,

I have exactly the same issue. As you mentioned as soon as I take Currency unit out, 'edit initial view' works fine. were  you able to come up with any solutions?

Ece

[Jan_van_Ansem]

Hi Ece, 

I am afraid I haven't found a solution. I ended up removing that field from my query. In my case this was not an important field anyway. I haven't logged an issue with SAP just yet either, as it is not so important for me any more. I suggest that would be the next step.... Hopefully it will be 'resolved in the next release' .