Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asad.lte
Starting Member
32 Posts |
 Posted - 2010-04-28 : 04:42:17
|
| hi guys,I got a query which got generated from a cube ,and m expected to write a query on that to get the expected result,is it possible r not.(drill down mechanism) parent (with amounts)& childs (no amount) |
|
|
asad.lte
Starting Member
32 Posts |
Posted - 2010-04-28 : 05:42:29
|
| Hi Kh,i need ur assistance on this query.plz help me |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-28 : 05:47:48
|
| you mean an MDX expression?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
asad.lte
Starting Member
32 Posts |
Posted - 2010-04-28 : 07:31:49
|
| hi visakh,i got a query which got generated thru a cube .it is having 10 columns and i was asked to write a query .from tht query we need to drill down data .for example productname childrenname fee1 productnamedistinctcount*Aftermarket 10 1 1*dealtransfer--- book1 125 2 book2 25 book3 35 total 185 grandtotal 195i want subtotal for the particular parent and the grand total (drill down mechanism ) i tried with cube n rollup but not solved |
|
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2010-04-28 : 09:17:03
|
i think you should do it in excel using that cube you generated...it will be more fast and easier to see
Hope can help...but advise to wait pros with confirmation... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-28 : 10:28:21
|
quote:
Originally posted by asad.lte
hi visakh,i got a query which got generated thru a cube .it is having 10 columns and i was asked to write a query .from tht query we need to drill down data .for example productname childrenname fee1 productnamedistinctcount*Aftermarket 10 1 1*dealtransfer--- book1 125 2 book2 25 book3 35 total 185 grandtotal 195i want subtotal for the particular parent and the grand total (drill down mechanism ) i tried with cube n rollup but not solved
show the query------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
asad.lte
Starting Member
32 Posts |
Posted - 2010-04-28 : 13:10:50
|
| hi guys,this example might help u frm all sides.1)there are 4 managers.2)under each manager there are 3 employees ,5 employees etc .3)wat am expecting is the total salary for the whole employees.4)the query shud giv salary for the whole and if v drill down just employees it shud giv the employee total sal and if v want to c full salary it shud.hope this wud help u |
|
|
|
|
|
|
Is it possible to write a query for a cube