I have a cube with two partitions set up, one for 2004 and one for 2005. I
also set up drillthrough on both partitions and tested fine in AS
enviornment. But when I use the windows xp pivot component to show the cube
and try to drillthrough for year 2004 data, it doesn't work. It shows no
records at all. It works fine for 2005 partition.

Any help on this?

Hi,

How do you do the drillthrough?
According to Microsoft the regular Pivot Tables (directly from Excel upto
2003) does not have this functionality by default. Only has it thru VBA
programming.

Do you use the Office Web Components?

"tzc" wrote:

Hi Tiago,

I use the XP web components embeded in aspx page. It works fine for 2005
data. But it doesn't work for 2004 since it is the second partition of the
cube.

Any idea?

Thanks.

tzc


"Tiago Rente" wrote:

Drillthrough returns a recordset collection. Your front-end client has to
interpret it properly. What you are seeing is that the front-end is able to
read the first partition, but not the rest of the records in the recordset
collection. See:
http://www.microsoft.com/downloads/d...DisplayLang=en
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Tina" <Tina (AT) discussions (DOT) microsoft.com> wrote

Have you adjusted the drillthough options for the partition?

When you edit a partition, on the very last screen there is a button for
advanced options. Down the bottom of the advanced options you will see
another button for drillthrough options.

If you have not edited these you may find that you will need to add the
fact table for the new partition to the drillthrough options and de-
select any columns that are coming from the other partitions fact table.

HTH

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <604C4DE0-C8DB-4697-B517-7939BD104AAB (AT) microsoft (DOT) com>,
Tina (AT) discussions (DOT) microsoft.com says...

Darren,

I did adjusted the drillthrough options for both of my partition 2004 and
2005 and tested it in Analysis Server enviornment. It works just fine. But
when I use the Pivot table Web component embeded in my .aspx fiile to do the
drillthrough, it returns no data at all for partition 2 which holds 2004 data.

I am wondering if I need modify some codes in drillthrough.htc file to make
it works. Any clue on this?

Thanks.





"Darren Gosbell" wrote:

Have a look at how it handles multiple recordsets. When a cube has
multiple partitions and you do a drillthrough it returns a recordset for
each partition.

At a guess the file would need to have something like the following
pseudo code, the key statement being "Set rst = rst.NextRecordset' where
it gets the next recordset from the 1 or more recordsets that was
returned.


================

Dim rst As ADODB.Recordset

'\\ Set rst to the recordset returned from the
'\\ Drillthough

Do While Not rst Is Nothing
For iRecCount = 0 To rst.RecordCount - 1

'\\ Code in here to display results \\

Next iRecCount
Set rst = rst.NextRecordset
Loop

================

Hope this Helps.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell