Skip to Content
avatar image
Former Member

Lumira Designer 2.0 Design Studio Data shows Edit Initial View preview but not in Cross Tab

Hi,

I have prompt filters in an application, As_of_Date and Region Prompt for two different DS.

DS_3 with Region Prompt shows data in Cross tab by passing Region after clicking OK+ Create Cross Tab

But DS_1 with As_of_Date Prompt doesn't show data in Cross Tab after clicking OK+ Create Cross Tab, however it shows data in Query Refresh and Edit Initial View preview after passing the date to prompt.

So I tried in different way, removed prompt (DS_2) on As_of_Date and fixed the filter value of date, it works, it shows the data in Cross Tab.

I have attached the screen print

Please suggest...

Regards

Sahil

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Hi All,

    Can someone help me ?

    Regards

  • Former Member

    Hi Tammy,

    Sorry for that, struggling since last few days, trying to find the why its happening then posted here.

    BI Platform : SAP BI 4.2 SP 4 Patch 3

    Lumira Designer 2.0 Sp 02 Patch 01

    Data Source: Query based on Universe.

    Thanks and Regards

    Sahil

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 30, 2017 at 06:24 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2017 at 06:32 AM

    Hi,

    Thanks for the response, here are the screens,

    I didn't make any change in property in all three scenario,

    one with date as prompt (Data not showing in CT)

    one with region as prompt (Data showing in CT)

    one with date as fixed constant values(Data showing in CT).

    1: "001 Property Screen Print of CT(DS_1) with Date as prompt " Where data is not coming CT after applying Date prompt but shows data in Edit Initial View.

    001-property-screen-print-of-ctds-1-with-date-as-p.png

    001-binding-screen-print-of-ctds-1-with-date-as-pr.png

    2: "002 Property Screen Print of CT(DS_2) with Date as Constant filter" Where data is appearing in CT after applying Date as constant filter and also shows data in Edit Initial View.

    002-property-screen-print-of-ctds-2-with-date-as-c.png

    002-binding-screen-print-of-ctds-2-with-date-as-co.png

    3: "003 Property Screen Print of CT(DS_3) with Region as prompt" Where data comes in CT after applying Region as prompt filter. ... ( same as 001, only different instead of Date, instead Date I took Region to check, works perfectly fine)

    003-property-screen-print-of-ctds-3-with-region-as.png

    003-binding-screen-print-of-ctds-3-with-region-as.png

    Regards

    Add comment
    10|10000 characters needed characters exceeded