Skip to Content
avatar image
Former Member

Modify HANA variable text in Webi Prompt

Hello Experts,

I am using SAP 4.1 SP4 in our project. We have HANA as data source for Webi Reports.

Variables created at HANA side are visible at data foundation layer of the Universe and same we can use as Webi Prompt.

But the HANA Variable or Webi prompts are appearing with full HANA package name, which is not good to exposed to the user.

Is there any way we can modify the prompt text at Universe or Webi level?

Thanks,

Supriya


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 27, 2015 at 01:31 PM

    Supriya,

    Have you consulted this document?

    http://scn.sap.com/docs/DOC-27676

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Supriya and Experts,


      Greetings!!

      We have the similar situation. Users are not comfortable with long prompt texts. We went with above work around but was stuck up. We have a HANA model which has nearly 300 columns, so when we try to create a derived table it actually takes complete select * query from HANA and validates in IDT. This query is resource hungry and resulting the HANA system to be down. Do we have any other way than executing this query to build the required universe?

      Did you have any impact on the performance when dfx was changed to a derived table?

      Appreciate your early response. Thanks.


      Arun

  • avatar image
    Former Member
    Apr 28, 2015 at 02:10 PM

    Hi Supriya,

    Were you able to change the names of the HANA variables that are seen from the view?

    Regards,

    Sameer

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Chong,

      Yes, you have to replace HANA input Parameter or variables by BO prompts in the derived table definition for Webi Report. It comes just fine for tools like AOLP or Design Studio.

      Regarding you question on better integration of BO with HANA, in 4.2 SAP has introduced lot of things, like Direct connection to SAP HANA with Relational and OLAP connection, HANA Online.

      Thanks,

      Supriya Das