Does Drill Through work fine in AS2005?

Hi,

I had designed several cube in AS2005. And I counfused by some problem of drill through.

1. The large amount of dimensions makes drill through broken?

Drill Through works fine in the cube that includes 20 dimensions. But, In the same cube, the amount of dimensions is increase to 25. The drill through works no response...

2. In some case, the drill through do not response correct row data.

A MDX syntax that response measure is 8 (In my project, that means there would be 8 row data in the fact table.).
And I use the same mdx syntax to drill through, that only response 1 row data!

Any idea? or it's the bug?

thanks,

Drillthrough is certainly very different in AS 2005 compared to AS 2000.

It returns you the rows at the deepest granularity of the measure group. If the rows in the measure group are for the same cell coordinate, then they will aggregate up to a value of 8 in 1 row.

If you need to see all 8 rows, then you should define a degenerate dimension (could also be ROLAP) which is at that deepest granularity -- e.g. at TransactionID. You can hide this dimension so normal cube browsing operations will not see this deepest granularity.

When you define the default drillthrough action for the cube you can specify this granularity attribute in the RETURN clause and fetch the data for the 8 unique rows.

Its difficult to say what may cause the different behavior when you move from 20 dimensions to 25. Perhaps looking at profiler would help to see what is happening. Also, you need to make sure that drillthrough is being done on a reasonable size of dataset -- drilling through on a cell that has millions of fact rows will perform very badly.

HTH,

Akshai

Documenting a Database

Hi,
I have designed and developed a database. Now I want to prepare some
documentation so that other developers can continue working on that.
How can I do this? Are there any standard ways to describe the entities and
procedures using some tools or etc.
Thanks in advance,
Leila
Hi
With the Enterprise Edition of Visio you can produce reports and diagrams
for your database, other modeling tools will provide similar functions.
You can also add extended properties to document your database such as
http://www.aspfaq.com/show.asp?id=2244
John
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23527A5D7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have designed and developed a database. Now I want to prepare some
> documentation so that other developers can continue working on that.
> How can I do this? Are there any standard ways to describe the entities
> and
> procedures using some tools or etc.
> Thanks in advance,
> Leila
>
|||I can't pass this one up. How did you design a database without
documentation? Oh, nevermind!!!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uDoASTE7EHA.4040@.TK2MSFTNGP14.phx.gbl...
> Hi
> With the Enterprise Edition of Visio you can produce reports and diagrams
> for your database, other modeling tools will provide similar functions.
> You can also add extended properties to document your database such as
> http://www.aspfaq.com/show.asp?id=2244
> John
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23527A5D7EHA.3616@.TK2MSFTNGP11.phx.gbl...
>
>

Documenting a Database

Hi,
I have designed and developed a database. Now I want to prepare some
documentation so that other developers can continue working on that.
How can I do this? Are there any standard ways to describe the entities and
procedures using some tools or etc.
Thanks in advance,
LeilaHi
With the Enterprise Edition of Visio you can produce reports and diagrams
for your database, other modeling tools will provide similar functions.
You can also add extended properties to document your database such as
http://www.aspfaq.com/show.asp?id=2244
John
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23527A5D7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have designed and developed a database. Now I want to prepare some
> documentation so that other developers can continue working on that.
> How can I do this? Are there any standard ways to describe the entities
> and
> procedures using some tools or etc.
> Thanks in advance,
> Leila
>|||I can't pass this one up. :) How did you design a database without
documentation? Oh, nevermind!!!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uDoASTE7EHA.4040@.TK2MSFTNGP14.phx.gbl...
> Hi
> With the Enterprise Edition of Visio you can produce reports and diagrams
> for your database, other modeling tools will provide similar functions.
> You can also add extended properties to document your database such as
> http://www.aspfaq.com/show.asp?id=2244
> John
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23527A5D7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > I have designed and developed a database. Now I want to prepare some
> > documentation so that other developers can continue working on that.
> > How can I do this? Are there any standard ways to describe the entities
> > and
> > procedures using some tools or etc.
> > Thanks in advance,
> > Leila
> >
> >
>
>

Documenting a Database

Hi,
I have designed and developed a database. Now I want to prepare some
documentation so that other developers can continue working on that.
How can I do this? Are there any standard ways to describe the entities and
procedures using some tools or etc.
Thanks in advance,
LeilaHi
With the Enterprise Edition of visio you can produce reports and diagrams
for your database, other modeling tools will provide similar functions.
You can also add extended properties to document your database such as
http://www.aspfaq.com/show.asp?id=2244
John
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23527A5D7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have designed and developed a database. Now I want to prepare some
> documentation so that other developers can continue working on that.
> How can I do this? Are there any standard ways to describe the entities
> and
> procedures using some tools or etc.
> Thanks in advance,
> Leila
>|||I can't pass this one up. How did you design a database without
documentation? Oh, nevermind!!!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uDoASTE7EHA.4040@.TK2MSFTNGP14.phx.gbl...
> Hi
> With the Enterprise Edition of visio you can produce reports and diagrams
> for your database, other modeling tools will provide similar functions.
> You can also add extended properties to document your database such as
> http://www.aspfaq.com/show.asp?id=2244
> John
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23527A5D7EHA.3616@.TK2MSFTNGP11.phx.gbl...
>
>

Document Map not appearing in Web Application

I have designed a report and everything is fine except when I view it in my vb.net application. When I view the report through the normal Reporting Services portal my document map appears fine without issue. However when I run it through my application the document map does not appear and the button is not available.

Here is the setup

I have a sql table that stores

* ReportID
* Title
* Keywords
* Serverpath

I then have an aspx page that simply has the webform report viewer with the following code. So I have a data grid populated from the reportinfo table with a Link on each title that passes the ServerPath to the reportviewer page. The URL that is genereated after I recently added the commands to the end of my report path through suggestion of another forum and that still didn't resolve the issue. Anyone out there have any suggestions on how to get the document map to show in the reportviewer webform?

The only thing I can think of is it has 3 parameters is there something special I am missing?

URL Genereated

http://perfectassistant.director-software.com/adminpages/reports/reportviewer.aspx?Path=/PAData/Student%20Information/Member%20Ensemble%20Listing%20Report&rc:Toolbar=True&rc:DocMap=true&rc:Area=Report

Page Load Code

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not IsPostBack Then

Dim rptPath As String

rptPath = Request("Path")

Dim rs As New ReportingService

ReportViewer1.ServerReport.ReportServerCredentials = New ReportViewerCredentials("USERNAME", "PASSWORD", "")

ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://SERVERNAME.com/reportserver")

ReportViewer1.AsyncRendering = False

ReportViewer1.ShowDocumentMapButton = True

ReportViewer1.DocumentMapCollapsed = False

ReportViewer1.ServerReport.ReportPath = rptPath

End If

End Sub

Document Maps don't show when you have the HTML viewer control set to AsyncRendering=false.

See this article for an explanation why (it has to do with the fact that we don't use frames):

http://msdn2.microsoft.com/en-us/library/ms252090.aspx