Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dlb777
  • Content: Threads
  • Order by date
  1. dlb777

    Cross between same dimension

    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...
  2. dlb777

    EXEL Pivot table problem with Distinct Count

    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...
  3. dlb777

    How to measure non aggregate type?

    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...
  4. dlb777

    Dynamic Measure

    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...
  5. dlb777

    How to design Table for Cube?

    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...

Part and Inventory Search

Back
Top