on 10-08-2007 4:16 PM
Hi Guru's,
I have a problem with an infocube. The problem is that i have my infocube which contains data (around 4 billion) and i need to add a characteristics : This is a characteristics which contains a Time.
At the beginning i thought to add it in a new dimension defined in Line Item but my problem is that i have already 13 dimensions defined. And today they are correctly defined (the maximum dimension represent 3% of my star schema the rest are aroudn 0%)
So do you have any idea (except design another infocube)
Thanks
Regards
Cyril Leredde
Hi,
that's the challenging part of data warehousing in BW!!
I am afraid you'll have to find a compromise: find a dimension which contain suitable characteristics with which the time will not impact it cardinality.
If you can do the above, you won't have to reoganie your datacube (reload and so on)
Or try to find a two dimensions which you could merge in order to have your time stored alone if is doesn't make sense to combine the time with any of the characteristic yet in the cube. This will surely end or a reorganization of your cube (delete+reload).
But 4 billion records.... I recommend to not let a cube reach these levels, precisely because then it is very difficult to manage changes like yours...
Can you paste a list of your characteristics here if you don't mind?
Is there a chance to logically partition this cube? Are your reports based directly on this cube or on a multi above?
let us know....
Olivier.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
The problem if the information i want to add is a transactionnal information and it is quite difficult (in a modeling point of view) to add a transactionnal information in a master data to add it after as navigation attribute.
My information is a time. this informatin is good for storage in DSO level but in my case i need to load it in my last level : infocube.
Thanks
Cyril
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Cyril,
Why cant you add one more object to exising objects(in cube) and use as a navigational object, instead of enhancing infocube..?
Hope it Helps
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok that's i thought
So i will create another infocube specially for this new needs.
But about your answer i don't think that infocube with 4billions of data is too heavy (it depends on your system)
Thanks
Cyril
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
of course, everything is relative; first I don't know the 4 billions; are these records? bytes? bits?
Assuming records; if your system is big enough to perform the change of a table with some millions records in an acceptable time for your business then go ahead with the restructuring of the cube, that's the best solution.
Coming to the idea of creating a cube specifically for this, that wasn't exactly my idea. I though that you could perhaps keep the actual cube as it is and create a copy of it. You would amend the copy with your new IObj and load new data only on this new cube (or partition it differently e.g. the whole 2007 in the new cube...)
It would also be good to know if you need to populate your new time field... Indeed, it is not the same just to add an IObj than to add it and fill it; in the latter you'll have anyway to reload the cube provided you still have the data.....
Olivier.
Message was edited by:
Olivier Cora
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.