Search results for query: *

thank you. But it didn't solve the problem. the real situation is like this : i have a program which can input many "Research" So in every research dont have a same question number. Example in research "A" it have 5 question. But in research "B" it has 7 question...

If I have a fact table ex: TBAnswer, have fields "Question", "Answer", "UserID" Dimension table is TBUser, have fields "UserID", "Name", "Address", "Age"(==>>varchar(40)). If I want to count How many user whose answer...

I have a cube named "Global Analysis". It has a measures named "CustomerID" (==>> Integer) I want this measures aggregate function is "Distinct Count". It is ok when i process and i browse the result using olap. When I wany to use Excel as a pivot table, it's still...

If I have a fact table ex: TBAnswer, have fields "Question", "Answer", "UserID" Dimension table is TBUser, have fields "UserID", "Name", "Address", "Job"(==>>varchar(40)). If I want to count How many user whose answer...

I'm working with olap for research/polling data. Example : I have a polling with 3 questions. Number one have 3 answer (a,b,c), Number two have 2 answer (a,b), and number three have 4 answer (a,b,c,d). If i want to build a cube. I need a measure. Usually i use a fixed measure (profit, income...

Hello, I'm newbie in OLAP. I learn OLAP just from the tutorial from the sample database foodmart. I'm confuse. Because when I saw the Tables from that sample database foodmart, its tables is Denormalize. Example : In "Customer" table there is a field named "CountryID&quot...