freeze the column for drilldown.

[Former Member]

Hi ,

There is a multi provider which has no of cubes.

One of the cubes has char: profit center, As is PACE profile,target PACE profile

and as-is head count(RKF)

Now in the report, i have profit center and as-is head count in the initial view and As-is PACE profile and target PACE profile in the free chars.

now my requiremnt is whenever I add As-is PACE in the report ,As is head count should change according to that.But when i add target PACE profile then As-is head count should not change.It should still show the value for as-is PACE profile.So my requirement is to ignore the drilldown of target PACE profile in the report and retain the changed values for as-is PACE profile.In other words. As-is headcount will never change for the target PACE profile.

Does it require anything in the cionstant selection of the RKF?

Please help me in this dregard.

[Former Member]

Try working on exception aggregation based on AS iS pace .

Or use constant selection on Target pace.

-Vikram

[Former Member]

HI Vikram,

thanks for the reply.I am planning to use constant selection on target PACE.

In the context menu i selected the button constant selection for the char PACE target profile in the RKF.

After doing that also i am getting the same result.Am i missign any thing?

[Former Member]

Add as is pace as well in the selection.

-Vikram

[Former Member]

If i add both as is PACE and Target PACE (both are hierarchy) in the selection i am getting the whole nos in the hierarchy -no split up.If i have 10 value for the PACE hierarchies i dont have split up among the nodes.it always shows 10 for all nodes and leaves.

If i have restriction only with Taregt PACE then whenever i add target PACE in the reprot it shows whole nos no split up.

but when i drill down with as-is PACE then it shows soem nos with split up among nodes.