maher_samet
Active Member
Hi List,
Excel is a powerful tool that can use OLAP to retreive data for analysis, and we are using SQL7 for OWB7332. But OneWorld has 2 things that cannot give us the opportunity to extract the data correctly: Decimal shifting for currency,amounts,quantities...( see DD for numerics) and Dates (its own coding).
To define an OLAP cube, we need to get correct data from a database: We thought about exporting data from OneWorld ODA data source to an SQL database using the SQL7 tools (DTS). We want to define the cube using this new database which will have the correct quantities and amounts and real columns dates.
But when we use this tool (DTS-import and export of data delivered with SQL), and specify the ODA datasource (as the source), we have to enter user and password ! Which ones ? for any user/password combination, we have an error and we cannot continue ! (try yourself)
Has anyone got an idea how to do to make this data transformation ?
Is there any other solution to make a cube based on real dates ?
Maher SAMET
Config: NT4/SP6a, SQL7/SP2, OW-B733.2/SP17.1
Excel is a powerful tool that can use OLAP to retreive data for analysis, and we are using SQL7 for OWB7332. But OneWorld has 2 things that cannot give us the opportunity to extract the data correctly: Decimal shifting for currency,amounts,quantities...( see DD for numerics) and Dates (its own coding).
To define an OLAP cube, we need to get correct data from a database: We thought about exporting data from OneWorld ODA data source to an SQL database using the SQL7 tools (DTS). We want to define the cube using this new database which will have the correct quantities and amounts and real columns dates.
But when we use this tool (DTS-import and export of data delivered with SQL), and specify the ODA datasource (as the source), we have to enter user and password ! Which ones ? for any user/password combination, we have an error and we cannot continue ! (try yourself)
Has anyone got an idea how to do to make this data transformation ?
Is there any other solution to make a cube based on real dates ?
Maher SAMET
Config: NT4/SP6a, SQL7/SP2, OW-B733.2/SP17.1