Hi! If I'm in the Analisis Studio and I have two datamart on diferent level, can I build two cubes and build report
ageinst them on the same report.
Is it pocible!?
Thanks vary mach
ribula
Hi!
Are enybody works with stock datamart and has prestanda problem. Mi quastin if it is Oracle help to make solution bater. The big volum on tables and demanding to find first delivery transaktion for some location product and find last sales transaktion for the same product must be vary haevy...
I am working for a manufacturing company and I am creating a datamart for stock and delivery analysis.
We have the big amount of delivery and the sales transaktion.
The problem is that delivery has a big gap before the first
transaction will came.
We need to keep track and calculate stock...
Thanks vary match for explain!
Mi expiriens with DW during 10 y
The problem is, when I make choise use Tipe 2 or when is better use FAKT for make history.
As usaly vi have vary big dimensions (castomer,Agrement, product_agriment, department e.t.c, between 10 mil up to 30 mil rows)
It's not god...
Hi!
Vi have a long disskation obout stategi to bild dimention.
Most of all dimentions vi have are vary big...
(Big Bank with allot customers).
Vi allrady resolve to bild Type 1 when dimensions is
5-10 mil rows
Should vi have type2(slow change di on small one?
When Type2 is god to use or not...
Hi!
I think You can use Starshema with 2-3 dimensions,
Time, Status, Custemer. On Customer put First,Last name e.t.c and index this item. On Status open,closed, avalible, not avalible e.t.s.On Time lavel You can chose
dayli lavel e.t.c
On Fact put Count(*) as number av records.
Bild dimention...
Hi!
If somebody can help mi with some overview figure which describe Data warehouse IT Arkitekture , base components and Enterprice DW Solution/concept.
I just write IT Strategy document for DW
Regards
I.S
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.