NaValAtUA
Technical User
- Nov 22, 2010
- 1
- 0
- 0
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?
OR
2. Where can I find more intelligibly document, that describe this situation?
Thank you!
Valery.
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?
OR
2. Where can I find more intelligibly document, that describe this situation?
Thank you!
Valery.
