Design Studio 1.4: Search by InfoObject Attribute

[former_member209541]

Does anyone know if the functionality exists yet to Search (or even Display) Attributes in the Filter or Variable Selection screens within Design Studio 1.4?

I've confirmed that this functionality exists int he most recent version of the BEx Analyzer.

I've also checked Analysis for Office and Analysis for OLAP and both allow Attributes to be displayed in the Search screen, but you cannot search based on the attribute.

This was previously asked in the post below (for DS Release 1.2), where there is also a link to Ingo's Document containing "Supported BEx Query Elements".  I checked the most recent version of that Document but the closest thing I found was (under Variables for BEx Query):

List of Values: Search in Key Values

List of Values: Search in Description Values.

The question appeared already in the following POST:

https://scn.sap.com/thread/3496711

Ingo's Document can be seen here:

http://service.sap.com/sap/support/notes/1869560

Thanks,

Paul

[IngoH · Accepted solution]

Hello Paul,

to my knowledge - even in DS 1.5 - the attributes are not shown but to be honest I would also not expect too much "functionality" from the standard prompting screen in Design Studio simply because the product is there to create dashboards and a prompting screen is not something you should be using in a dashboard.

With DS 1.5 you can have attributes in the data set now but agreed it does not solve the problem you trying to solve which is the ability to see the attributes as part of a filter / prompting dialog.

regards

Ingo Hilgefort, Visual BI

[former_member209541 · Accepted solution]

Thanks for the investigation / feedback!

Looks like we'll have to find another way, I think I can do it with a replacement path variable.

Fair point about Design Studio being intended for Dashboards, however in this case we are jumping from a Dashboard to a more detailed report and I was hoping to stay within the same tool.  The infoobject for selection is "ADDRESS Number" (6-digit number) which is impossible to use for selection/filter.  The attributes STREET NAME or CITY are perfect for selecting/filtering, hence our requirement.

Obviously this is a newer tool and there are other higher-priority features to be added.

Thanks everyone!

[Former Member]

The only way I see is to simple create a variable for the attribute as well.

Best regards,

Victor

[former_member110741]

Hi Paul Browser ,

Even inn Analysis Office we have a option to display attributes in Filter but i did not find any option to filter using attribute selection search

As tammy mentioned already in design studio also i do not see any option using attribute search in Filter Member dialog

but Yeah, in BEx analyzer is available using attribute search

Thanks & Regards,

Subhash

[TammyPowlas]

Hi Paul - I don't see a way to include display attributes as part of the filters in even 1.5:

You can see the Member Display shows "Text and Key" and other types of options but not display attributes

In terms of variables, are you able to add the display attribute as part of the BEx variable?  Various threads on SCN contradict each other, one saying you can using the replacement path and others saying no you can't do this.