We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  • Hackerrank Home
  • Prepare
    NEW
  • Certify
  • Compete
  • Career Fair
  • Hiring developers?
  1. Prepare
  2. Databases
  3. OLAP
  4. OLAP Operation Types
  5. Discussions

OLAP Operation Types

Problem
Submissions
Discussions

Sort 11 Discussions, By:

votes

Please Login in order to post a comment

  • sean1813
    3 years ago+ 3 comments
    -- ROLLUP: a*b*c + (a*b)             + (a)     + 1
    -- CUBE:   a*b*c + (a*b + a*c + b*c) + (a+b+c) + 1
    
    24|
    Permalink
  • mittal_ankit91
    5 years ago+ 0 comments

    correct answer is d((4, 7, 3, 84, 160, 117))

    7|
    Permalink
  • sweedal19
    3 years ago+ 0 comments

    Simple explanation to this problem. https://github.com/andylamp/stanford_dbclass/tree/master/13%20-%20on-line%20analytical%20processing

    Correct answer is : option D] (4, 7, 3, 84, 160, 117)

    4|
    Permalink
  • jaydilippatel
    9 months ago+ 0 comments

    (4, 7, 3, 84, 160, 117)

    0|
    Permalink
  • roshnimiranda98
    1 year ago+ 0 comments

    need to do trial and error for this...

    if we consider a,b,c,d,e,f

    then,

    d = a*b*c ;;

    e = (a*b*c) + (a*b + b*c + a*c) + (a+b+c) + 1 -- CUBE ;;

    f = (a*b*c) + (a*b) + a + 1 --ROLLUP

    0|
    Permalink
Load more conversations
  • Contest Calendar
  • Blog
  • Scoring
  • Environment
  • FAQ
  • About Us
  • Support
  • Careers
  • Terms Of Service
  • Privacy Policy
  • Request a Feature