Creating a Custom SQL Query
Hello Folks,
I am working in a project in Brazil and, we need develop the following load to Hyperion Planning:
We have the PeopleSoft ERP (MSSQL - relational database) as source.
Our target is Hyperion Planning.
The customer has all SQL queries statement written in Hyperion Application Link (HAL), and we need migrate all HAL projects to ODI. In short, I must apply this query as source object and load in Hyperion Planning.
Follow below the SQL query:
SELECT RTRIM(ID_CR)AS ID_CR,
RTRIM(DSC_CR)AS DSC_CR,
RTRIM(ID_PARENT)AS ID_PARENT,
'0' EXPENSES,
'1' INCOME,
'0'DRE,
RTRIM(STATUS)AS STATUS
from DIM_CR where tipo_cr = '1'
union
SELECT RTRIM(ID_CR)AS ID_CR,
RTRIM(DSC_CR)AS DSC_CR,
RTRIM(ID_PARENT)AS ID_PARENT,
'1' EXPENSES,
'0' INCOME,
'0' DRE,
RTRIM(STATUS)AS STATUS
from DIM_CR where tipo_cr = '0'
I have been written here that it is necessary develop a custom KM to apply a query in ODI. Is it true? Is There another way to solve this issue?
I have been learned a lot with you. I appreciate a lot your help.
Wallace Galvão,
Brazil