on 12-16-2014 3:00 PM
Hello
I need to use collected data in table SFC DATA from BO
but DATA are not loaded into ODS .
it's not recommanded to use WIP tables
Can you recommand me ?
thanks
Hi!
You are right that it is not recommended.
Of cause, you can extend the default universe and add links to whatever table. But it might affect performance of live production. So, you have to consider this and test somehow closely to the real conditions.
Another issue about SFC Data is that it is split between WIP and ARC tables. So, if you need a universal solution, you will have to join both resources that might be quite expensive.
You might want to replicate in any way the data from WIP table to some other location, for example, in ODS, and then point the report to that place.
Regards,
Sergiy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.