cancel
Showing results for 
Search instead for 
Did you mean: 

Reporting requirement .

mohd_abdullah
Contributor
0 Kudos

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 NumberNew OpenInprocessInvalid Closed
001 01-01-201202-01-201203-01-201205-01-2012
00201-01-201202-01-201203-01-201203-01-2012
00301-01-201203-01-201204-01-201206-01-2012
00401-01-201202-01-201204-01-201204-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.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member188080
Active Contributor
0 Kudos

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
Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Contributor
0 Kudos

Bro that was just an example .

In practical we have more than 12 lacks tickets..

former_member188080
Active Contributor
0 Kudos

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
Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Contributor
0 Kudos

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
Contributor
0 Kudos

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 NoNewopenInprocessclosed
00101-01-201202-01-201203-01-201204-01-2012
00201-01-201202-01-201202-01-2012
00301-01-201202-01-201203-01-201205-01-2012
00401-01-201203-01-201203-01-2012

But the expected output is

Ticket NoNewopenInprocessclosed
00101-01-201202-01-201203-01-201204-01-2012
00301-01-201202-01-201203-01-201205-01-2012

Any idea how to get this ?

Regards.

vinay_lohakare5
Contributor
0 Kudos

Hello,

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

or

WEBi report filter can also help.

Thanks,

Vinay

mohd_abdullah
Contributor
0 Kudos

HI Vinay

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

Regards.

vinay_lohakare5
Contributor
0 Kudos

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
Contributor
0 Kudos

HI

Select the table ??

where ??

Query designer??

No table in Query designer

vinay_lohakare5
Contributor
0 Kudos

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