OLAP Analysis: Rolling Up Numbers

3.01K viewsDataLink
0

Ok, say I have a database that lists product types, sales price, profit, and date of sale. Just as a simple example.

When I do an OLAP analysis, and only have the follow categories:
product type
sales price
profit

And do *not* include the date of sales, how does Quantrix “roll up” the numbers? Does it just add up all the months of profit (plus or minus), and display that for every product type? When it does the roll up, is there a way for us to specify the method, like taking an average, etc? Thanks!

0

Mike,

Thanks for the clarification! I misunderstood how that last step in the import process was to be used. Now that I get it, it will come in very handy!

You are viewing 1 out of 2 answers, click here to view all answers.