Multiple OLAP Pivot Tables on one page

  • Thread starter Thread starter Paul Hodder
  • Start date Start date
P

Paul Hodder

I have built a few htm pages using Frontpage that displays various
OLAP pviot tables. So far so good.
However recently I tried adding a second pviot table to one page and
it looks as though you can only have one connection to the olap cube
per page.
Is there any way around this ??

Cheers

Paul Hodder
 
Paul. You could create the different Pivot tables on separate pages (ex:
pivot1 and pivot2 ) and then open the main page and insert them as include
pages. If you're using asp pages you could also include them as

<html>
<body>

<!--#include file="pivot1.asp"-->
<!--#include file="pivot2.asp"-->

</body>
</html>

I haven't tried it but it should work.

Dave
 
Thanks Dave .......... worked a treat, although if the dimensions are
expanded you lose the header information as you scroll down. I think
adding the a hyperlink to the real page so as to view the data in more
detail would work OK.

Thanks for the help

Paul
 
Back
Top