Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiload data across the years..

2919252May 13 2008 — edited May 21 2008
Hi All,

I'm trying to load the multiperiod data which is across two years, during the check -in process, Import process and Export process, FDM interface shows that it identified the two years correctly along with the months but the Export file which FDM creates before loading into Planning cube, does not show the changed year. When using the MultiLoad option within same year, it works fine but doesn't work if it's across the years.

Did anybody encountered this issue and if so, can you please let me know how to resolve it. Any help would be appreciated.

Thanks
User625353

Comments

thatJeffSmith-Oracle

Can you share the entire SQL?

If i generate the DDL for EMPLOYEES, i have 7 instances of 'INITRANS 2 MAXTRANS' in the code, with no errors produced.

jnp1234

The ddl producing the error is like (I can't post the exact ddl here):

CREATE TABLE "ZZZZZZ"

( "ID" NUMBER NOT NULL ENABLE,

"CREATEDTIME" DATE,

"CHANGEDTIME" DATE,

"STATUS" VARCHAR2(16 BYTE) DEFAULT 'READY',

.... columns deleted

 CONSTRAINT "ZZZZZZ\_PK" PRIMARY KEY ("ID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 268435456 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ZZZ_I_8M" ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 262144 NEXT 268435456 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ZZZ_T_256M"

LOB ("MESSAGE") STORE AS BASICFILE (

TABLESPACE "ZZZ_I_8M" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10

NOCACHE LOGGING

STORAGE(INITIAL 262144 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;

I also have this ddl producing an error:

pastedImage_0.png

CREATE TABLE "TAX_ACCOUNT_BULK_CNT"

( "BULK_NUMBER" NUMBER,

"CHANGEDTIME" DATE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

COMPRESS FOR OLTP LOGGING

STORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "FX_T_256K" ;

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 18 2008
Added on May 13 2008
#business-intelligence-applications, #financial-data-management, #performance-management-applications
2 comments
1,939 views