cancel
Showing results for 
Search instead for 
Did you mean: 

Update the default query script parameters in the datafoundation

Former Member
0 Kudos

Hello,

Currently, I have been working with Business Objects Semantic Layer (SL) SDK API. The issue that I am facing right now is in updating the default query script parameters in the data foundation of a universe. Let me explain it with the help of the following screenshot:

  Out of all these parameters, I am mainly interested in updating/adding the value of ANSI92 to be Yes.

The reason for the requirement is as follows:

Using the SL SDK API, I am trying to create outer joins in the data foundation for a universe. The underlying database which I am using in Vertica, which supports ANSI92 format of SQL queries. Now, since the default value for ANSI92 is set to "No", it causes the generation for ANSI89 format of SQL queries. Due to this, the query script generated for the BO reports doesn't have outer join clauses.

Please suggest a good solution.

The reply is eagerly awaited.

Accepted Solutions (0)

Answers (1)

Answers (1)

nscheaffer
Active Contributor
0 Kudos

Why are you trying to do this with the SDK? Do you have A LOT of universes you need to do this to?

Noel

Former Member
0 Kudos

Hello Noel,

I am creating a web service, which will allow a user to create a universe (and all the components, like connection, data foundation and business layer). This behavior, I am achieving using Semantic Layer (SL) SDK.

The SL SDK APIs have done a great help in almost all the use cases. But, as I try to include a join, an outer join to be precise, using the API, I am able to check the outer join checkbox. But, the query doesn't show outer join clause.

For this, I need to set ANSI92 to Yes. It is at this point, I can't find any help from the SL SDK API.

I understand, I can set the flag by accessing IDT, but as the universe will be created by the user, who won't have the access to IDT, I want this functionality through the SDK only.

I hope, my concern is clear to you.

Reply awaited.

nscheaffer
Active Contributor
0 Kudos

That makes sense. Sounds like a difficult project. I have never done any SDK work. I hope you are able get things worked out and meet your objective.

Noel