Missing data fields in Query designer

[Former Member]

Hi Guys,

A query exists on an ODS. There are few characteristics and navigational attributes in the ODS. In Query designer, on the left hand side under Dimensions,

i can see 'Data part' (for Data fields of ODS) and 'Key section' (for Key fields of ODS).

All but 2 fields (One data field and one navigational attribute of the ODS) are seen under 'Dart part' of the query designer.

Data field - Accounting Document number

Navigational attribute - Actual Acquisition Fiscal Year

What may the reason for those 2 fields not appearing.

Any help is greatly appreciated.

[former_member188975 · Accepted solution]

Hi Govind,

Is Accounting Document number marked as attribute only in RSD1?

[Former Member · Accepted solution]

Hi Bhanu,

The 'attribute only' field for 0AC_DOC_NO is unchecked in RSD1.

Thanks,

Ram

[Former Member · Accepted solution]

Hi Govind,

Not sure if your is the same..

I had a similar problem before..but that was due to some changes made..

Logging out and again loggin into BEx made all the fields appear..

Ashish.

[Former Member · Accepted solution]

Ashish,

No help.

[Former Member · Accepted solution]

Hi Govind,

One more suggestion..no logical reason for this ..but try creating a new query on the same ODS.

Apart from that even I have no idea how this can happen..

Good Luck and let us know if you can get a reason for this..

Ashish..

[Former Member · Accepted solution]

Hi,

Still no help. Those 2 objects do not show up in the new query either.

Thanks.

[Former Member · Accepted solution]

Hi,

I executed a query on the ODS using LISTCUBE. To my surprise, i can find both 0AC_DOC_NO and ZACQ_YR here. If i can find both these in LISTCUBE, why don't i find the same in the query designer. Even though i built a new query on the ODS in the query designer, i still can't find them in the query designer.

Thanks