Hi there,
I am new to cubes so am wondering if I create and process a simple cube with a dimension called CUST_TYPE_DIM on the CUST_TYPE column using the following table and 5 rows then why when I query the cube do I get the attached counts? Surely the counts should be Internal = 3, External = 2?
Code:
create table CUSTOMER(
CUST_ID int,
CUST_NAME varchar(20),
CUST_TYPE varchar(20))
insert into CUSTOMER
values(1,'Harry','Internal')
insert into CUSTOMER
values(2,'Barry','Internal')
insert into CUSTOMER
values(3,'Sally','External')
insert into CUSTOMER
values(4,'Larry','External')
insert into CUSTOMER
values(5,'Jerry','Internal')
Thanks in advance.