No data available - Execute on BI Platform

[Former Member]

Dear all,

we are facing a strange mistake I hope somebody else has already seen and solved.

We are using a universe as datasource and everything works fine in local execution mode. But if we try "Execute on BI Platform", we get an error "no data available". Error log says:

Cannot load InfoProvider "DSL/ ...... " (data provider "DS_1": No service implementation available)

But what's really strange is: It only shows this error if I filter the data in a special way. We have separated our data in quarters, and only for one company in one quarter it does not work. The query retrieves perfect results in Web Intelligence and on SQL Server, but in Design Studio it lacks.

Is anyone familiar with that or similar issues?

Thanks in advance

[Former Member · Accepted solution]

Hi Daniel,

We got a similar error also having an SQL Server as a source.

Our problem was that the data source was setup to be run on background. When we tried to open and setup the Initial View, it gave the same error

Cannot load InfoProvider "DSL/ ...... " (data provider "DS_1": No service implementation available)

After trial and error, we discovered that the issue was with the background processing and the initial view of the datasource

What we did was:

1) setup data source to Load in Script = false

2) setup the initial view (even if you don't want to set something in the initial view, just move the measures from columns to rows and viceversa)

3)  setup data source to Load in Script = true

4) open initial view to check that it shows data

Now it works fine. Strange, but it works fine.

Hope it helps

[Former Member · Accepted solution]

Hi Juan,

thanks a lot for your answer. You are right, this was part of the original problem, but nevertheless the query did not retreive data at all.

I finally found out the reason:

The dimension filter was applied on a company's name which contained a german umlaut: "Ä"

BI Platform seems to be unable to process these mutated vowels. We had a similiar issue some weeks ago with dimensions containing elements with comma - we were not able to filter for these values.

A filter on an element named "123 Bond Street" works.

A filter on an element named "123, Bond Street" does not work.

Thanks a lot for you replies, I hope this information can help somebody else.

Daniel

[Former Member · Accepted solution]

Is there any Word from SAP when this is getting fixed?

We have Swedish customers who can't use the Swedish signs 'Å, Ä, Ö' which is not acceptable.

[former_member62103]

Hi

I've had a similar error when trying run on a BI platform using a UNX as a data source.  Works fine when run locally but fails with a "No connection factory for type DSL\DSL".  So the clue is the DSL part.  So I created another APS in the CMC but in addition to the Analysis Application Service added the DSL Bridge Service (UNX universes use this).

Started new APS, stopped the original one, restarted the DS client and was able to successfully run my DS document on the BI Platform.

Why is it that when the DS App extension is installed on the BI platform, the install process does not configure APS servers?

Surely the whole point is to run the DS document from the BO Portal and have it available to BO users?

Cheers

Jon

[stefan_jesse]

Hi,

this is a known problem which has been fixed just recently. Please have a look at SAP note 2216929. The fix will be delivered with 1.5 SP2.

Regards,

Stefan

[TammyPowlas]

Is the BI add-on for Design Studio installed on the BI Platform?

Did you upload the Design Studio application to the BI Platform?

[Former Member]

Hi Tammy,

yes I did. Every application else works fine on BI Platform, also every other filter.

[TammyPowlas]

Do the logs show anything for this application/filter? 

[TammyPowlas]

The other question is whether you are using the OLAP connection created in the CMC to connect?

[Former Member]

Hi Tammy,

thanks for answers. No, the logs don't show anything... in DS I just get the popup "no matching data found in getdata( ... )", if I use that function.

We are using a relational connection created in Information Design Tool,which works perfectly in WebIntelligence and so in Design Studio, for all kind of data - except this part. It is also no problem to retrieve this specific data on SQL server itself and in WebI.

What I really do not understand is, that it works in Local execution mode, but fails on BI Platform. It is also the same issue on any computer and for any user, already tried this out...

[TammyPowlas]

Could you create the connection in the Central Management Console instead of the IDT to see if it works that way?

[Former Member]

The connection already exists in CMC. Furthermore, I can't see an option to create a relational connection in CMC at all?

[TammyPowlas]

To clarify, is the universe a data source?

[Former Member]

Yes, single-source universe.

[TammyPowlas]

What is the database behind the single source universe?  Not all databases are supported for universes for Design Studio - they are listed in the help at help.sap.com/boad

[Former Member]

It is MS SQL Server 2008R2, which should work.

[TammyPowlas]

Hi Daniel - at this point, I recommend opening an incident with SAP Support to investigate further, and reference this thread