cancel
Showing results for 
Search instead for 
Did you mean: 

Navigation attribute for selection

former_member238061
Contributor
0 Kudos

Hello,

I want to restrict data within a query line by customers of a specific industy code.

However, the industry code is a navigation attribute only.

SAP does not allow me to restrict the values.

Goal I want to accomplish:

Data:

customer          industry code     sales

4711                    A                    100

4712                    A                    200

4713                    B                    300

Query:

line 1     total sales                                       600

line 2     total sales code A                            300

line 3     percentage A to total                        50% (= 300/600) as a formula (line 1/line 2).

Line 2 is the problem.

Any tips to get around are welcome.

Thanks a lot in advance

Thomas

Accepted Solutions (1)

Accepted Solutions (1)

christophepos
Explorer
0 Kudos

Hi Thomas,

If your Industry Code is a Navigational attribute (on the Customer InfoObject, on the InfoCube and on the MultiProvider if used) then it should behave like any characteristic included in the InfoProvider and you can navigate on it and filter on it as well.

Can you double check whther you activated it on all needed levels?

Kind regards,

Christophe

former_member238061
Contributor
0 Kudos

Hi Christophe,

thanks a lot.

However, it is not navigation. It is selection/filtering within a query line.

KR

Thomas

christophepos
Explorer
0 Kudos

Hi Thomas,

When you have a navigational Attribute, you can use it to filter a key figure using Restricted Key Figures in the query definition:

Defining Restricted Key Figures - Business Intelligence - SAP Library

Have you considered this?

Kind regards,

Christophe

former_member238061
Contributor
0 Kudos

Hello Christophe,

thanks.

The system behaves the same way.

My steps:

1. define restricted key figure

2. select revenue as key figure

3. select customer and try to select navigation attribute "trade" thereof

Result: Navigation attributes are not offered, only characteristics variables and values.

KR

Thomas

christophepos
Explorer
0 Kudos

Hi Thomas,

This would however indicate that your attribute is not marked as navigational on the InfoProvider you use as a source.

Normally you would see your attribute in the same dimension where 0CUSTOMER is sitting, but than with a technical ID looking sort of like this: 0CUSTOMER__0IND_CODE_1 for example.

So can you double check that you have flagged the attribute as navigational both on the InofObject and on the InfoCube and MultiProvider used?

InfoObject:

InfoCube:


And same goes for the MultiProvider is you use this. And in the Multi you also have to make the assignment off course.

Hope this helps.

Kind regards,

Christophe

former_member238061
Contributor
0 Kudos

Hi,

...all set as shown in your screenshots.

The query designer offers:

When entering a new selection (query line) the query designer offers:

Also drag-drop does not work.

T.

christophepos
Explorer
0 Kudos

Hi Thomas,

And you do not see the attribute in BEx as I mentioned before with the double underscore? If that is not the case I suggest you log an incident with SAP because when all the flags are set correctly in the back end, the navigational attribute should appear there as shown in below screenshot.

Kind regards,

Christophe

former_member238061
Contributor
0 Kudos

Hello Christophe,

thank you very much. It is fixed now.

I forgot the multi provider.

Now it works.

With kind regards

Thomas

Answers (0)