Greetings to you, more experienced colleagues!
Now I am in hard-working process of Cognos Controller implementation in Kiev, Ukraine (Eastern Europe), started from 04 oct 2010.
At this point we have CC-server, that is working in LAN of our customer.
All process is working well, but I have a few troubles, that begin to pose a threat to the implementation of the project. The most hot trouble - is to setting up the process of data import via staging tables. The simple case of data import (without any operation) was successful.
But, I have need to change some data (f.e. account code). My continuous attempts was not successful, because of understanding lack in application of operation in import specification.
Last result is:
I have the import specification, named "XSTAGEFACTS03".
I set (on Fields(1) tab) the field ACCOUNT to use existed operation _ACCOUNTS1.
Operation _ACCOUNTS1 have 2 chain-rows
first - GetItem (with and/or without any kind of optioanal arguments).
second - LOOKUP (with existed table LOOKUP01 and 'ON NO MATCH EXCLUDED' as argument).
This described example still not working, for my very sorry. The question IS -
1. How to use operations in import specification?
2. Where can I find more intelligibly document, that describe this situation?
Pinned topic The doc of "import specifications" isn't rich with examples or explanation
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-11-23T15:22:32Z at 2010-11-23T15:22:32Z by NaVal@UA
paulyoungcga 2700034G4W2 Posts
Re: The doc of "import specifications" isn't rich with examples or explanation2010-11-23T13:55:01ZThis is the accepted answer. This is the accepted answer.You can contace me at email@example.com. There are several documents available on developerworks that can help you with the import specification
Paul Young, CGA
NaVal@UA 270003MRYY2 Posts