system
#1
This is really an issue with SAP Inventory.unx - so maybe not relevant to the DI component.
In reports that run against INVENTORY_DAILY_VIEW, there is a prompt in the universe that requires user to choose source (MARD, MCHB, MSKU, etc).
When I refresh this report, it attempts to populate the LOV by running query:
SELECT Distinct “INVENTORY_DAILY_VIEW”.“SOURCE_CODE”
FROM INVENTORY_DAILY_VIEW.
this query (the LOV) times out. it is a very ineffecient query, because inventory_daily_view produces cartesian results on dates.
Has anyone else had experience with this issue?
Environment: BI4.0SP2, DI4.0SP?, databases are Oracle 10g.
abooth (BOB member since 2011-07-08)
system
#2
Update on this issue for anyone that has this issue:
I was able to resolve the issue by changing the LOV to query against the INVENTORY_SOURCE_CODE table.
abooth (BOB member since 2011-07-08)
system
#3
I used Inventory_Fact table but Inventory_source_code table is better I guess.
abooth,
Is the view normal view or materialized view? I think the view is too slow.
edgoa (BOB member since 2012-11-20)
system
#4
It is a normal view (as installed) - but it should probably be a materialized view.
Yes, the view is very slow.
abooth_msdf (BOB member since 2014-06-02)