| Author |
drillthrough with different partition
|
|
|
| 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?
| |
| Tiago Rente 2005-09-15, 11:23 am |
| 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:
> 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 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:
[color=darkred]
> 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:
>
| |
| Dave Wickert [MSFT] 2005-09-16, 7:23 am |
| 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/...&DisplayLang=en
--
Dave Wickert [MSFT]
dwickert@online.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@discussions.microsoft.com> wrote in message
news:604C4DE0-C8DB-4697-B517- 7939BD104AAB@microso
ft.com...[color=darkred]
> 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:
>
| |
| Darren Gosbell 2005-09-16, 7:23 am |
| 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <604C4DE0-C8DB-4697-B517- 7939BD104AAB@microso
ft.com>,
Tina@discussions.microsoft.com says...
> 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:
>
>
| |
|
| 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 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_do
t_com>
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <604C4DE0-C8DB-4697-B517- 7939BD104AAB@microso
ft.com>,
> Tina@discussions.microsoft.com says...
>
>
| |
| Darren Gosbell 2005-09-29, 8:24 pm |
| >
> I am wondering if I need modify some codes in drillthrough.htc file to make
> it works. Any clue on this?
>
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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
|
|
|
|