SAP IDT static value object without querying the database

[Former Member]

Hi All,

Please see the attachment to get a better idea.

I want to add a dimension/measure 'Version' in blx with a constant numeric value say 100. Then I want to display this in the Reports.

But this is not working as expected. I am trying to add a query like "SELECT '100' AS ... " but its not working either.

Is there a way this can be achieved ? Will adding a static LOV help ?

Thanks,

Shrutika

[amitrathi239 · Accepted solution]

Hi,

You need to add first 100 static value in the data foundation layer.Right click on the table->Insert calculated Column.Add in the DF and then create object in the BLX layer.

Amit

[Former Member · Accepted solution]

Hi,

Thanks a lot! 100 works fine!

Now if the Version I want to add contains multiple decimals Ex. 3.2.1

How do I do that ?

I tried using to_char() But it is giving error saying "right parenthesis is missing"

I am new in IDT/WEBI.

Many Thanks...

[amitrathi239 · Accepted solution]

Hi,

Can you explain in detail what are you trying.

If you want to display 3.2.1 as a static value then use '3.2.1' in the insert calculated column.

Anything number without quotes and string in single quotes.

Amit

[Former Member · Accepted solution]

Hi Amit,

I wanted to display the Version of the package in the WEBI reports. Just to keep track.

Thanks a lot for your help! I wanted it to work exactly like this!

Regards,

Shrutika

[Former Member · Accepted solution]

Hi Amit,

I added DT_VERSION derived table in the HANA dfx layer with expression :

SELECT 'VER 1.2.3' AS VERSION

FROM DUMMY

But when I click 'Show Script' for the version Dimension the query which gets displayed is:

SELECT

  "DT_VERSION"."VERSION"

FROM

  (

  SELECT 'VER 1.2.3' AS VERSION

FROM DUAL

  )  "DT_VERSION"

Because of this I am getting error in the report :

invalid identifier: DT_VERSION.

Do you know why this is happening ? I would expect it to simply show:

SELECT 'VER 1.2.3' AS VERSION

FROM DUAL

[Former Member · Accepted solution]

If you're using HANA, shouldn't you be using SELECT 'VER 1.2.3' AS VERSION FROM DUMMY instead?

[Former Member · Accepted solution]

Hi Mark,

Thanks for pointing it out.

Sorry.. I might have copied the wrong query. We use both the DBs Oracle & HANA.

It is DUMMY.

SELECT

  "DT_VERSION"."VERSION"

FROM

  (

  SELECT 'LMS 6.2.5' AS VERSION FROM DUMMY

  )  "DT_VERSION"

[Former Member · Accepted solution]

Fair enough. I'd create it simpler.

Scrap the derived table.

Create an object as 'LMS 6.2.5'

Associate it with the table DUMMY using the Associate SQL Tables button in the object creation dialogue.