cancel
Showing results for 
Search instead for 
Did you mean: 

Display a particular column only when certain criteria is satisfied

Former Member
0 Kudos

Hi Experts,

I have a requirement from a user with which i am struggling. The person wants to see an entire report but see a particular column only when certain criteria is satisfied. I am not talking about filtering the entire Query but just a certain column.

Ex.

Data in Cube

Req | Candidate | Candidate Status | Grade

1 | C01 | Draft | A

1 | C02 | Withdrawn | B

2 | C03 | Hired | B

3 | C04 | In Process | A

3 | C05 | Hired | C

Result in Query

Req | Candidate | Grade

1 | <Blank> | A

1 | <blank> | B

2 | C03 | B

3 | <blank> | A

3 | C05 | C

Basically, user wants to see candidate information only when Status is Hired. Rest of the time, it should be blank.

Is this possible ?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

try to create a virtual characteristic for Candidate

and assign candidate values to the virtual characteristic only if candidate status is "HIred".

And make use of this virtual characteristic in the query.

--- Thanks...

Former Member
0 Kudos

You can just maintain one more chracteristic in the cube & populate it whenever status is B & use this object in the query.

Former Member
0 Kudos

Hi,

From My view this is not possible in Query.

You can do this in Backend or

You can create 2 Query

1.Query whith candidate name who is hired.

2.Query without candidate name whose status is not hired.

3.Merge these these report using Excel Macro.

Thanks and Regads,

MuraliManohar