Question:
How do you supress repeated key values in a WEB query?? I know this switch can be found under 'properties' in BEx, but I am not able to locate it anywhere on the output of my query on the WEB. It is not possible to change query design at this point. I have already searched the forum with no luck. Any ideas?
Answer:
the web is simply a front end for your foundation which is your query. Why is it not possible to make that setting at the query level where it belongs.. and where I think you are only able to...
Answer:
If you make the setting on the query definition, it will still suppress the repeated text in the web. In order for you to have the repeated text shown in the web, you must change the properties of the table item in the web template. There is a setting to show repeated text.
Tip: When you download to excel it will show all repeated texts if you just use the query definition check.
Hope this helps.
Thanks,
jlaruss
Answer:
Thanks for you're reply jlaruss. The users want to be able to have an option to turn ON/OFF the feature to 'Suppress repeated key values' like in BEx. I am not able to find this feature in the web query. Changing it at run-time and having one of the two is not acceptable. Does this option really not exist on the web query? or is it just hidden in some hard to find place?
Answer:
Thanks for you're reply jlaruss. The users want to be able to have an option to turn ON/OFF the feature to 'Suppress repeated key values' like in BEx. I am not able to find this feature in the web query. Changing it at run-time and having one of the two is not acceptable. Does this option really not exist on the web query? or is it just hidden in some hard to find place?
Did you look at the properties box for the table web item The option to supress repeated texts is right there, as a check box.
Now, to help you even further, you design the query to NOT suppress the repeated key texts, leaving you the option to turn it off in the table web item properties.
Well, how can I give my users this option though you may well ask
If you cannot provide a URL link (read button, form, javascript, whatever front-end coding you want) to turn that property on and off for users (I don't know off the top of my head if you can or not), you can instead provide two table web items, one with the option checked and one with the option NOT checked. Then you can use javascript, DHTML, or CSS to hide or display the appropriate table when users select a button or option.
But my users don't want to select the option each time, oh alas what am I to do You can't please everyone all of the time. You would have to provide two different queries or two different query templates for them to link into. And publish both of them. *OR* you could provide your own personalization and see about writing a cookie to their computer which saves a preference. (I don't know if you can enhance the personalization in BW or possibly enhance the personalization in the user profile to store this information.
- Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
You can do exactly what you want, but it will take either a button changing the properties of the web item or a javascript function added to the context menu getting the properties of the table iteam and changing it to "X" or "". These are just two examples, there are other ways to do this. This is the actual code that sets the suppression for the repeated texts. Hope this helps.
SAP_BW_URL item=’TABLE_1’ SUPPRESS_REPETITION_TEXTS=’X’
Thanks,
jlaruss