Home » Developer & Programmer » Data Integration » MOLAP doesn't get sequence (OWB 11g)
MOLAP doesn't get sequence [message #435928] Sat, 19 December 2009 02:15
Messages: 2
Registered: December 2009
Junior Member
hi, I tried to make time dimension with time dimension wizard in OWB 11g.
I chose MOLAP, but at the end it didn't automatically make sequence to my time dimension and I can't make a surrogate key.
But if I change it to ROLAP, it automatically make the sequence.

I prefer MOLAP, but I'm quite confused why I didn't get the sequence. MOLAP doesn't need any sequence and surrogate key?
So what can I do to make a surrogate identifier if I don't get any sequence?

[Updated on: Sat, 19 December 2009 02:40]

Report message to a moderator

Previous Topic: Can we use excel file as the source for loading the data to staging in an oracle warehousing environ
Next Topic: Materialized View (Refresh on commit)
Goto Forum:

Current Time: Sun Apr 21 12:28:52 CDT 2024