Navigational attribute in selection screen gives no applicable data

[Former Member]

Hi Gurus

In the report i am using the navigational attribute in the selection screen.e.g Brand (attribute of material)

My problem is whenevr i enter value in the navigational attribute (brand) in the selection screen and execute its says no data found.

If i do not fill this parameter and fill only the parent attribute (material) in the selection screen , then i can see the results and from its properties (drilling down )i can see the values of brand .

If the values of brand exist why via selection screen its not giving vales, However Via material i can drill down and see brand values.

I have done all the necessary steps to make this attribute as navigational.

On top of this i have this same navigation attributes as one of the characterisitc in the cube.

Thanks

DD

[Former Member]

va

[monikaszewczuk]

Hello,

I've the same problem... for new nav. attributes for 0Material.

Settings for nav. attibutes in BEx Q.D. are OK.

But in BEx Analyzer:

1- not display all values for this attributes. Some values are displayed, some don't.

I try display it with and without selection screen. The result is the same.

2- I try to display (normal) attributes - not nav. In this case everything is OK.

But I've 2 columns: normal attribute for all values and nav. attribute only with some values...

(the query is something like: 0Material + 0Material_NOTnav_attr + 0Material_NOTnav_attr)

It isn't a normal...

I don't know... Maybe it's depend of the time?

I can't clear all master data for 0Material, because they're used in some cubes. I had old characteristic without nav. attr. but with master data. I added nav. attr. in 0Material and activated it. Next I load master data (full method). Then I added nav. attr. in infocube, activated it, delete and load data into the cube (Init + Delta).

If I display data for the cube in RSA1, I can see nav. attr. for all records. I can't see it in BEx Analyzer...

Can U explain it?

Thx,

MSzN

[Former Member]

May be u can check whether the small character check is enabled or not, that may have created the problem. Suppose the Nav attribute is mantained in Small Case and u are trying to put that in Upper case the values will not get displayed.

Hope this helps u

[Former Member]

Hi,

Please check the property of Nav. attribute in Query Designer and confirm are same as below

In advance tab

Access Type for Result Value as Posted

Only Posted Value For Navigation

then go to RSRT

Generate Report

and execute ...

-

---

Thanks

BVR

[Former Member]

@Durgesh

Just make sure that the attribute which you have used in the report layout and for which you have confirmed that there exists some data and the attribute used on selection screen are sa

Checked its same

@BVR

In advance tab

Access Type for Result Value as Posted

Only Posted Value For Navigation

then go to RSRT

Generate Report

and execute ...

Checked its same way.....

However i have just checked, I took other Brand randomly it appeared.So that means Nav attribite is Sel screen is working.

My Question is still unresolved for this particular Brand. If i put in sel screen: NO Result

But if i enter its corrosponding Material it comes and by drilling down i can get the brand. No idea why this brand is not coming if i go via nav attribute in sel screen

.

Its in the masterdata too thats the reason is coming by drill down. Please HELP

[Former Member]

Hi Dheeraj,

Actually that should not happen, you can filter values based on navigation attributes also there is no restriction as such.

Just make sure that the attribute which you have used in the report layout and for which you have confirmed that there exists some data and the attribute used on selection screen are same.

Regards,

Durgesh.