Dear HANA Gurus,
Facing a couple of issues with a recently created analytical view on HANA, using Efashion scenario. Trying to explain it below:
When I create a business layer over AN.view, the show values works fine. UNV is also published successfully to the platform. I can see the UNV added there in BI 4.0
However, when from IDT, I check the Integrity of the universe, it fails a check at Business Layer.
The error message looks like below:
"Severity";"Rule Name";"Status";"Object"; "OK";"Invalid Business Items name";"OK";""; "OK";"Business filter validity";"OK";""; "OK";"Business object validity (Binding)";"OK";""; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'At Calendar Year Week Id'. Check the object properties.";"At Calendar Year Week Id"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'Yr'. Check the object properties.";"Yr"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'Qtr'. Check the object properties.";"Qtr"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'Mth'. Check the object properties.";"Mth"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'At Outlet Shop Id'. Check the object properties.";"At Outlet Shop Id"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'Manager'. Check the object properties.";"Manager"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'City'. Check the object properties.";"City"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'State'. Check the object properties.";"State"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'At Article Article Id'. Check the object properties.";"At Article Article Id"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'Family Name'. Check the object properties.";"Family Name"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'Category'. Check the object properties.";"Category"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'Article Id'. Check the object properties.";"Article Id"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'At Article Colour Color Code'. Check the object properties.";"At Article Colour Color Code"; "ERROR";"Business object validity (SQL/MDX)";"It was impossible to execute the business object 'Color Label'. Check the object properties.";"Color Label";
When I checked the guide 'Error Messages Explained â– BusinessObjects XI 4.0', it just mentions below, but fail to comprehend, what exactly needed to be done here in IDT!!!
It was impossible to execute the business object '{0}'. Check the object properties. (CIM 01403)
Cause
The business object bindings cannot be executed on the database.
Action
Modify the business object binding.
Second issue happens at the Dashboard Design. When I create a new Query definition in the Query Browser of the Dashboard Design, I can see the Universe created in above step.
However, when I select that universe, it raises a weired message saying, something like
"Universe ASTD*garbage*SqlbRew not found. (XLS 0006) The datasource cannot be generated for the specified datasource name "bus_layer"
-> ("bus_layer" is my universe/ Business layer name at IDT)
I can open another universe in the Dashboard's query browser, so not an connectivity or authorization issue.
Any help would be highly appreciated.
Thanks
manish Madhav