Showing posts with label feature. Show all posts
Showing posts with label feature. Show all posts

Friday, February 24, 2012

Drillthrough to AS2005 cube in excel

Hi,
I am trying to get the 'Drillthrough' feature working in excel 2003 (I
have an action set against my 2005 cube for drillthrough).
I can drillthrough fine in the cube browser but cannot get it to work
in excel.
If I double-click the cell I get an error and have read that I may need
to use the excel addin to do this. However, when I have installed the
addin and the 'required components' I can setup a connection to the
cube but when I try to connect get an error saying I do not have
permissions or my cube does not exist - both of which are false.
Anyone come across this and have a solution?
Thanks,
DarrenHi Darren,
Just write an DRILLTHROUGH MDX Query in Managamnet studio and see your
getting the data.
Let me know if your still having any issue.
Balaji
darrenmr2@.gmail.com wrote:
>Hi,
>I am trying to get the 'Drillthrough' feature working in excel 2003 (I
>have an action set against my 2005 cube for drillthrough).
>I can drillthrough fine in the cube browser but cannot get it to work
>in excel.
>If I double-click the cell I get an error and have read that I may need
>to use the excel addin to do this. However, when I have installed the
>addin and the 'required components' I can setup a connection to the
>cube but when I try to connect get an error saying I do not have
>permissions or my cube does not exist - both of which are false.
>Anyone come across this and have a solution?
>Thanks,
>Darren
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200602/1

Sunday, February 19, 2012

Drillthrough Problem

I have a problem with the drillthrough feature in reporting services.
When I drillthrough from report A to report B it works fine and all
parameters where processed. But if i drilltrhough from report B to report A
now the parameters where ignored and i get an cached version of report A. How
can I run report A with the new parameters of report B after the first
drillthrough?this problem only occurs in the Microsoft CRM report viewer.
"Mike" wrote:
> I have a problem with the drillthrough feature in reporting services.
> When I drillthrough from report A to report B it works fine and all
> parameters where processed. But if i drilltrhough from report B to report A
> now the parameters where ignored and i get an cached version of report A. How
> can I run report A with the new parameters of report B after the first
> drillthrough?

drill-through feature in a pie chart

Hello,

Assume I have a pie chart report named as Report 1. This report breaks down a completion state column in the X table. Here is my question; I want to create another pie chart report names as Report 2, which breaks down the message column in the X table on the basis of a given completion state. In other words, Report 2 should be on the basis of a given completion state, via drill-through from Report 1. Thus, when I click the different slices of the pie chart of Report 1, I should get a separate pie chart report (i.e. Report 2), which breaks down the message column on the basis of a given completion state

Please let me know if you have any idea?

Sincerely,

--Amde

Report2 would need to use a parameterized data set query (to limit the dataset based on the provided parameter value for the completion state). The query parameter would be linked to a report parameter of report2.

Then, in report1, you define a drillthrough action on the chart datapoint to drill to report2 and specify the current completion state value as drillthrough parameter.

-- Robert

|||

Hi Robert,

I am clear with the first statement, however, I am not sure how to specify the current completion state value as drillthrough parameter.

what I did is I create an internal parameter for the completion state in the Report1 and pass it to the Report2 when I define a drillthrough action. But, this didn't work. When I click any of the slices of the pie chart from Report1, Report2 displays the same report all the time.

It would be very helpful if you tell me things I should do both in Report1 and Report2. A step-by-step procedure is very appreciable.

Sincerely,

Amde

|||

Now it is working.

Thank you for your assistance.

--Amde

Tuesday, February 14, 2012

Drill through --relative path

I'm trying to use the drill-through feature to link to a report in different solution, on the same server, but in a different project. Local help files say: "The list of report names includes all reports in the current report server project. If the drillthrough report is on the report server but is not in the project, type the name of the report. The report name can contain a relative or absolute path to the report."

The report will be passing a parameter to the target report through drill-through. The target report is located on different solution and project but on a same server (report manager). Any help will be be appreciated.


Can someone give an example of a relative path? Nothing I've tried has worked, and I've posted this on sqlteam to no avail.

Thanks,

Lalon

if your base directory is "c:/SomeProgram/"

relative_path -> absolute path
"dir1/dir2" -> "c:/SomeProgram/dir1/dir2/"
"../dir3" -> "c:/dir3/"

i don't know what and how you are using the relative paths, but if you are using paths in directly in code, in some programming languages you have to double the '/' ("../dir3" -> "..//dir3")

Amaral