Skip to Content
0

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

Oct 30, 2017 at 06:20 AM

152

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
Former Member

Hi All,

Can someone help me ?

Regards

0
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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Oct 30, 2017 at 06:24 AM
0
Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

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

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


Share
10 |10000 characters needed characters left characters exceeded