Public Dimension and data import from BW

[puneetc]

Hi Experts

While extracting the data from BW into the public dimension in SAC, it fetches the correct result when a filter value for a dimension is given while building the query in import job however when the query is built without any filter it brings the # value for one dimension member

BW holds the correct data and shows all the record just that while pulling it to SAC import jobs it populates correct value when the filter value for the dimension is given however when the query is built for larger set by removing the filter, the same record has a dimension member as # as an example

Project id Description Investment code

ABC test test1

When while building the query in import job in SAC if we given Project id as ABC in the filter section it populates data correct for all the fields and if we dont give any filter it populates the investment code as #

Please help

[Enda]

removing 'S/4HANA Cloud front end' tag as Not Applicable