Post reply

Does MSSQL have DIMENSION functionality as Oracle, please?

  • February 25, 2015 at 6:54 am

    #301600

    Hello,

    Does MSSQL provide such a functionality, please? Dr. Google keeps pointing me to MSSQL Dimension Tables or Warehouse pages

    when I search for. Below attached Oracle's example to clarify what I mean. Much obliged!

    SELECT SUBSTR(country,1,20) country,

    SUBSTR(prod,1,15) prod, year, sales

    FROM sales_view

    WHERE country IN ('Italy','Japan')

    MODEL RETURN UPDATED ROWS

    PARTITION BY (country)

    DIMENSION BY (prod, year)

    MEASURES (sale sales)

    RULES (

    sales['Bounce', 2002] = sales['Bounce', 2001] + sales['Bounce', 2000],

    sales['Y Box', 2002] = sales['Y Box', 2001],

    sales['2_Products', 2002] = sales['Bounce', 2002] + sales['Y Box', 2002])

    ORDER BY country, prod, year;

  • February 25, 2015 at 8:20 am

    #1779931

    I can't remember anything like this in T-SQL. It can be simulated with other instructions, but the real functionality would be using MDX. Unless someone else can think of something else.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply