cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi All,

Can someone help me ?

Regards

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos
TammyPowlas
Active Contributor
0 Kudos

can you share screen shots of the binding/properties of the cross tab?