Freeze Panes in BEX WAD

[Former Member]

Hi Experts,

I would like to freeze panes in columns in SAP WAD, for that I used the modification module com.sap.ip.bi.rig.Scrolling.

However, I couldn't have a control on how many columns I want to freeze (may be I don't know)

Assume that I have a query output with columns as below

A     B     C     D     E     F

Here, in the query, A,B and C fields are in rows. D, E and F belongs to key figure structure.

Using the above module, freezing of panes is done till column C. (Only I can able to freeze A, B and C columns).

My requirement would be to freeze columns till E, where D and E are in the columns of the query.

Is there any parameters I need to specify to freeze columns till E in WAD.

Kindly suggest on how to achieve this.

Br, H

[yasemin_kilinc · Accepted solution]

Hi Harish,

You can do it using the parameter "column"  of scrolling.

Add COLUMN as new parameter to the module. Select it as boolean. In the placeholder list select value as Structure Member, then select the last key figure you want to show in the freezed pane. In your case select E. I think that will work

Regards

Yasemin...

[Former Member · Accepted solution]

Hi Yasemin,

I couldn't use the placeholder structure member, as the column F is a local formula.

I tried with place holders Structure Member and Structure with no success.

Any suggestions is highly appreciated.

Thanks again.

Br, H

[yasemin_kilinc · Accepted solution]

Hi Harish,

Regardless of being a locak formula, you can still freeze columns. Try placeholders with structure member and set structure member value 2. Then first two columns in your key figure structure are freezed.

Hope it helps

Yasemin...

[Former Member · Accepted solution]

Hi Yasemin,

I have the column structure with F as a local formula.

I did the the steps mentioned by you and have given the structure member as the technical name of the formula. Still I couldn't freeze panes for this formula.

Even I tried with the the below alternative as well.

Instead of giving placeholder as structure member, I used Integer type and gave the column width of the formula as the value. Using this also, didn't helped me.

Where would have I gone wrong?

Your help is highly appreciated.

Br, H

Message was edited by: Harish Kumar

[yasemin_kilinc · Accepted solution]

Hi Harish,

There is a screenshot in the attachment which I have tried for you in my system. The dataprovider is a query where there exists 3 key figures. First one is a formula, second one is a selection and last one is again a formula. When I set the settings as seen on the attachment, it freezes the first two columns of the key figures (the formula and the key figure) The last one is not freezed. In the value part I gave the number of the columns to be freezed, not the technical name of the key figure or formula.

Hope it helps...

[Former Member · Accepted solution]

Yesemin,

First of all, thanks a lot for taking your time on this.

Please see my screenshot below.

Still it didn't froze as expected. Since you told it worked perfectly for you, I'm checking on other parameters, which hinders this freezing.

Also attached is the ANALYSIS_ITEM parameters. Please have a look. Thanks.

Br, H

[yasemin_kilinc · Accepted solution]

Hi Harish,

In my template I select single module. Please check if "active" is checked as "on" on single module properties. Then I set the type as ...scrolling...

Other analysis item properties remain same as default.

"Use scrollbars" in paging properties of your template seems disabled, which is not the default setting. I will suggest you to add a new analysis item, and with the default settings try the scrolling module with single module.

Hope it helps

Yasemin...

[MGrob]

Hi

Did you go through those two documents posted here?

http://scn.sap.com/people/andrey.uryukin/blog/2010/12/07/analysis-web-item-parameter-modification

Is it for one specific report or you try to achieve this dynamically..

hope it helps

Martin