Skip to Content
0

Listbox and Calendar input in Crosstab of Design studio 1.6

Oct 03, 2017 at 12:30 AM

81

avatar image

Dear Gurus,

I've a peculiar requirement.

1. The application should be input enabled. I've done this, successfully.

2. This Input enabled application has a Crosstab. Now, in this crosstab I need to get a Listbox for a particular column and calendar input for other particular columns.

For ex: List box for Status column,

And Calendar input for Start Date.

3. My data source for this application is BEx Query.

Please let me know how can I achieve this.

Thank you,

Warm Regards,

Ravi Kanth

10 |10000 characters needed characters left characters exceeded

Hi Ravi,

By "input enabled application" do you mean you are trying to create a planning application using BW Integrated Planning or is your requirement something different? In a planning application, as far as I know, only key figure values can be edited in the Crosstab but it seems you have a requirement to edit dimensions. Can you clarify the purpose of selecting/editing the Status and Date dimensions in your Crosstab?

Regards,

Mustafa.

1

Hello Mustafa,

Thank you very much for response.

In my case, business wants to input Status and Start Date in Report. So, I could able to manage these as Input enabled and it is working fine.

But when it comes to input of Start date, it accepts only 1 format "MM-DD-YYYY" but business wants to have different format for different region. So, we thought of providing as calendar input where calendar will popout to select the date.

For Status: Business wants to select status as "Not Started or Completed or Failed".

So, my requirement is to make this available in a CROSSTAB of an application in design studio.

FYI.. In Webi I can easily achieve as Webi goes by Column based for any report. But in Design Studio the scripts are applied for entire CROSSTAB.

Please help.

Thank you.

Regards,

Ravi

0
Naga Ravi Kanth Batchu

Hi Ravi,

I am still a little unclear about what you have currently been able to implement. When you say "I could able to manage these as Input enabled and it is working fine" does that mean you have successfully assigned the input-enabled BEx Query to a Crosstab? If so, can you post a screenshot of your application with input-enabled Crosstab?

Thanks,

Mustafa.

0

Hi Mustafa,

Please find the attached screen-print for reference.

The highlighted columns need the Calendar input (Start date) and List box (status).

Please help me.

Thank you

Ravi

kai-input.png (17.7 kB)
0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Naga Ravi Kanth Batchu Oct 03, 2017 at 08:39 AM
0

Hello Gurus,

Is there anyone to help?

Thank you

Share
10 |10000 characters needed characters left characters exceeded
Naga Ravi Kanth Batchu Oct 04, 2017 at 12:22 AM
0

Dear Guru's,

Anyone has any idea how to achieve this?

Thank you.

Share
10 |10000 characters needed characters left characters exceeded
Naga Ravi Kanth Batchu Oct 05, 2017 at 05:15 AM
0

Dear Gurus,

May I please know anyone has encountered this requirement?

Thank you

Ravi

Share
10 |10000 characters needed characters left characters exceeded
Naga Ravi Kanth Batchu Oct 09, 2017 at 07:37 AM
0

Dear Gurus,

Does anyone has any idea whether it could be achieved or not?

Thank you

Share
10 |10000 characters needed characters left characters exceeded