Вопросы по кубам
1. Parent –Child dimension error.
Esti tablica kotoraea soderjit Parent-Child Relationship. Naprimer:
Create table Profile
(
profile_id int not null,
parent_id int null,
profile_name varchar(50)
)
Rows:
1,null, Root
2,1,Companies
3,2,Ford
4,2,BMW

Esti drugaea tablica: MediaType – soderjit toliko media_type and media_name
Rows
1, TV
2, Radio
3, Press


Esti fact table. Naprimer:
Create table Article
(
article_id int not null,
profile_id not null,
media_type int not null,
size int not null,
)

Rows:
1,1,1,10
2,2,1,19
3,3,1,25


Delaiu Parent-Child Dimension dlea tablici Profile. Vse ok
Delaiu Star Dimension na tablicu MediaType.
Delaiu cube na table Articles. Measures: article_id, size. Dimension: MediaType and Profile.

Kogda delaiu process CUBE daet sleduiusiu osibku :
A member with key ’1’ was found in the fact table but not was found in the sets of the leaf member in the dimension Profile.
To esti ne otrabativaet link na Root v tablice Profile.
CTO DELATI ?


2. Problema s NULL values in the fact table.
Naprimer, dlea prevedusego primera, dopustim cto fact table imeet sledusie stroki:
1, 1, null, 10
2, 2, null, 19
3, 3, 1, 25.

V takom slucae u menea finalino budet toliko 1 stroka v CUBE. Napriper esli zahocu posmotreti SIZE dlea vseh profiles uviju toliko profile 3 i size=25 (hotea vse danie dlea profile 1,2 toje esti )

Kak resiti problemu s NULL values v fact table ?