Reporting requirement .

[mohd_abdullah]

Hi Experts.

How can I achieve the following

Suppose there are 5 status for tickets say New open inprocess invalid closed

The user want to see the date on which the ticket was on the above status

Eg

Ticket Number	New	Open	Inprocess	Invalid	Closed
001	01-01-2012	02-01-2012	03-01-2012		05-01-2012
002	01-01-2012	02-01-2012		03-01-2012	03-01-2012
003	01-01-2012	03-01-2012	04-01-2012		06-01-2012
004	01-01-2012	02-01-2012		04-01-2012	04-01-2012

This i have achieved by restricting Date field with the respective status

NOw the user want to see only those tickets which have gone through the status Inprocess.

Experts please let me know how  can I achieve this.

Regards.

[former_member188080]

Hi,

You have correct data in Infpprovider level

Ticket number   Status     Date

so if you have this

just pull Ticket number in row

then get the KF structure for date

and put status charateristics at the top of the Key figure structure..

or 2

you can also create restricted KFs with 5 status and put them in column and put ticket number in row..

Thanks and regards

Kiran

[mohd_abdullah]

Hi Kiran

Thanks for replying friend

You are absolutely correct . I have the same data at the Infoprovider level

I have already developed this report . I have followed the 2nd approach u mentioned in the above post.

Please can you refer the 3rd post of this thread to know exactly what I want .

Waiting for your valuable input.

[former_member188080]

Hi,

You can just right click on the ticket number and restrict on those ticket numbers 001 and 003.

Thanks and regards

Kiran

[mohd_abdullah]

Bro that was just an example .

In practical we have more than 12 lacks tickets..

[former_member188080]

Hi,

See here there are two things

1. You can provide the variable in the selection screen for those incident number. Select variable with selection option

2. Or you can elaborate the question if 1 is not true for u ...

Thanks and regards

Kiran

[mohd_abdullah]

Hi Kiran

Thanks for taking time to reply my question . For clear understanding  I have attached screenshot for the same . Please go through this .

Waiting for your reply.

Regards.

[Former Member]

Hello Mohd,

Why don't you just exclude values 'not assigned' from your selection in Column In Process in Query Designer?

This should led to the required results.

Best regards

Klaus

[former_member188080]

Hi,

I got u

You need to write the customer exit or you can make direct exclusion as shown above on say termination date..

you can put this in filters..

and just take not assigned and exclude it.. it will help u..

You can also have variable on termination date where you can have selection range and you can exclude it..

Thanks and regards

Kiran

[mohd_abdullah]

Hi

Thanks Kiran and Klaus .

Terminated is a restricted keyfigure ie "New selection" done on Date Infoobject which is a keyfigure ie 0DATE_KYF and so I cannot keep it in filter .

And I have done the following (refer screenshot) but it did not work .

[former_member188080]

Hi,

I think you need to do it on keyfigure and not on charaterstics Incident ok..

You can use formula variable for this and you can try to put this logic there..

Thanks and regards

Kiran

[vinay_lohakare5]

Hi,

You need to show only the tickets which has gone throught the status Inprocess i.e. In your example you will only have 2 tickets: 001 and 003.

Restrict the key figure with In-process.

if you also have to show the tickets which passed through Inprocess and has invalid or closed status the you can restric the KF with all the 3 status.

Thanks,

Vinay

[mohd_abdullah]

HI Vinay

The status in the above report are all Selections ie Date(Keyfig) restricted with respective status. (Status "New" = "date" restricted with status New and so on)

As you said "Restrict the key figure with In-process." which is already done and so we are able to Inprocess field in the report.

Now as you said I want to display only ticket number 001 and 003 . Actually in my report the field INVALID is not there I have mentioned it here for clear

understanding .

Actually I am getting report output as follows.

Ticket No	New	open	Inprocess	closed
001	01-01-2012	02-01-2012	03-01-2012	04-01-2012
002	01-01-2012	02-01-2012		02-01-2012
003	01-01-2012	02-01-2012	03-01-2012	05-01-2012
004	01-01-2012	03-01-2012		03-01-2012

But the expected output is

Ticket No	New	open	Inprocess	closed
001	01-01-2012	02-01-2012	03-01-2012	04-01-2012
003	01-01-2012	02-01-2012	03-01-2012	05-01-2012

Any idea how to get this ?

Regards.

[vinay_lohakare5]

Hello,

You can put the block level filter : Inprocess <> blank or not null.

or

WEBi report filter can also help.

Thanks,

Vinay

[mohd_abdullah]

HI Vinay

can you please tell me in brief how to " block level filter" .

Regards.

[vinay_lohakare5]

Hi,

Select the table.

If the filter area drag the Inprocess Measure and restrict it to get only the not null values.

or

Apply the same filter at the WEBi query level.

Thanks,

Vinay

[mohd_abdullah]

HI

Select the table ??

where ??

Query designer??

No table in Query designer

[vinay_lohakare5]

Hello,

The answer was with respect to WEBi , . sorry.

If you can convert them in to RKF then you can apply condition in BEX.

Thanks,

Vinay