just sql override in SQ t/r: select col1..,sum(sal) from table

how to calculate sum(sal) with out using aggregator satge

Question Posted / jz

Answer Posted / jz

just sql override in SQ t/r:
select col1..,sum(sal) from table_nme group by (col)

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

537

How to know the time taken for particular report execution?

518

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

593

Explain what are components of reportnet?

557

How to load the time dimension?

546

Briefly state different between data ware house & data mart?

560

Explain what are necessary tasks to install reportnet software?

481

How can you clear the cache?

527

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

503

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

540

What is mean by aggregate aware?

541

Difference between PowerPlay transformer and power play reports?

2070

What is Active Datawarehousing?

570

Explain how many ways you create ports?

613

Can we start and stop single session in concurent bstch?

530