 | |
newbee - how to see real data
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
newbee - how to see real data -
02-24-2004
, 07:20 AM
#2
| |||
| |||
|
|
Hi people ! I wonder how is possible to see more detailed data from excel by clicking (selecting) the cell. I made report with PivotTable and data from OLAP |
measured data) by clicking the cell in excel. For ex. if I have report Sales
with dimensions Customers and Product, and cell which contain 5 sold
productA, how can I retrieve this 5 rows with detailed Sales data
(ProductName,StoreName,Time, Adress,etc....). It's possible to conect every
cell with microsoft query, to pass parameters and get whatever you want...
or some other way ?
Quote:
|
thanks for answers! Vlado Kaligari ************************************************** ******************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... |
#3
| |||
| |||
|
|
Sorry, you can't do drillthrough in SQL 7.0 - this was introduced with SS2K (Analysis Services). Once there, there is a good explanation and example of this on Microsoft's website - http://msdn.microsoft.com/library/de...us/dnexcl2k2/h |
Quote:
|
You should just be able to clone the VBA code (it's not too bad). Also know that you have to enable drillthrough permissions in the cube, itself. HTH, Erin wrote Hi people ! I wonder how is possible to see more detailed data from excel by clicking (selecting) the cell. I made report with PivotTable and data from OLAP Services / SQL 7.0 and I want to retrieve all the rows (that contained measured data) by clicking the cell in excel. For ex. if I have report Sales with dimensions Customers and Product, and cell which contain 5 sold productA, how can I retrieve this 5 rows with detailed Sales data (ProductName,StoreName,Time, Adress,etc....). It's possible to conect every cell with microsoft query, to pass parameters and get whatever you want... or some other way ? thanks for answers! Vlado Kaligari ************************************************** ******************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... |
#4
| |||
| |||
|
|
There also some requirements for the pivottable version - isn't there ? Erin <erin_welker (AT) hotmail (DOT) com> wrote in message news:#CuQWTv#DHA.1732 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Sorry, you can't do drillthrough in SQL 7.0 - this was introduced with SS2K (Analysis Services). Once there, there is a good explanation and example of this on Microsoft's website - http://msdn.microsoft.com/library/de...us/dnexcl2k2/h tml/odc_xlextendolap.asp. You should just be able to clone the VBA code (it's not too bad). Also know that you have to enable drillthrough permissions in the cube, itself. HTH, Erin wrote Hi people ! I wonder how is possible to see more detailed data from excel by clicking (selecting) the cell. I made report with PivotTable and data from OLAP Services / SQL 7.0 and I want to retrieve all the rows (that contained measured data) by clicking the cell in excel. For ex. if I have report Sales with dimensions Customers and Product, and cell which contain 5 sold productA, how can I retrieve this 5 rows with detailed Sales data (ProductName,StoreName,Time, Adress,etc....). It's possible to conect every cell with microsoft query, to pass parameters and get whatever you want... or some other way ? thanks for answers! Vlado Kaligari ************************************************** ******************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.