Drill Down In Excel -- I Know What Drill Through Is!!
Oct 28, 2005
Can anyone help me with this?
This is my problem:
I have a cube that I created in AS2005, I have a hierarchy and drillthrough action defined. When I create a pivot table in Excel based on that cube and I try to drill down on the cell in the pivot table I can not drill down to the next level. I get an error message: Cannot show or hide detail for
this selection. My hierarchy is based on Dimension Facility. Facility State is root level, facility zip is next level. When I'm in AS2005 and browse the cube, I'm able to drill down and drill through and see the hierarchy just fine. (Also, I find interesting that when I create a cube in excel, based on a two relational tables, I'm able to drill down. ) I have the Analsysis Services Add-on installed on my machine, so I have the Cube Analysis Menu item. But I can't seem to even drill-through. So, for now all I want to know is why can't I drill-down (i.e. double clicking on a cell and having the data related "explode" in the spread sheet) like it shows in the article written by William Pearson, titled September 12, 2005
Introduction to MSSQL Server Analysis Services: Reporting Options for Analysis Services Cubes: MS Excel 2003 and More. Any help is greatly appreciated!!
Queen
View 3 Replies
ADVERTISEMENT
Apr 24, 2008
I've created a drill down rpt in RS2000, but when I setup subscription and receive it as Excel, the file doesn't contain any drill downs.
Does anyone have any idea the reason for this??
thx,
John
View 1 Replies
View Related
Oct 4, 2007
hy all,
when i export to excel reports having a drill-down, in the excel file i don't have the possibility to drill down data.
i have memory that once it was possible.
does anyone know how to help me?
is it possible that a service pack or any updating could have change configurations?
thanks
by
nicola
View 1 Replies
View Related
Nov 19, 2015
I am having difficulty in exporting a report to Excel that has drill-down grouping created in SSRS 2008 R2. I can export with the report expanded or with just the summary and both look fine, but when it gets to Excel it looses the toggle ability which I need for it to retain.
View 2 Replies
View Related
Sep 18, 2007
I€™m having a problem with Excel 2007 DM and SQL 2005 and I hope someone out there has a solution.
Consider the following environment:
Windows XP SP2 or Windows Vista, Excel 2007, Data Mining Add-in, SSAS 2005 (with session mining models enabled, an AdventureWorksDW cube deployed and drill-through actions available).
Now take the following steps:
1. In Excel 2007 set up a connection to SSAS
2. Connect to the cube and create a new pivot table report (drag and drop whatever you like)
3. Right-click on one of the cell values in the data region and either select a drill-through action, or, select Show Details in the context menu
4. Ensure that you have at least 10 detailed records that are generated on a new worksheet page; you should have a time-based column in your detailed records
5. Select the table of detailed data, then select the Analyze tab (within the Table Tools grouping) which appears in the topmost menu above the ribbon
6. Click the Forecast button in the ribbon and choose both the field which you want to predict as well as the time-based column (from step 4) as well as the number of time periods to forecast
7. Finally click OK.
1. Having followed these steps on both WinXP SP2 and Vista, I keep coming across the exception: HResult:0x800A03EC. Any ideas as to why this exception pops up? If I was using a normal table of data (which was not generated from a Show Details or drill-through action), then the Forecast button works fine.
I googled it and thought the localization settings for SSAS 2005 and Excel 2007 needed to be the same (initially they weren€™t). I€™ve tried removing the auto-filters which appear atop each column in the detailed data table prior to clicking the Forecast button, and, I€™ve also tested for a series of data across a number of time periods with the same result.
Also, a colleague of mine discovered that the column headers that appear by default from a drill-through start with "$[", and, in removing them the Forecast function appears to work.
I would have thought there would be a seamless transition in Excel 2007 between data retrieved from a cube and the DM Add-in featueres (or at the very least, a more meaningful exception message than the one presented).
Is there something I€™ve missed, or, is there a KB article I haven€™t come across yet? As I know for a fact that the problem is reproducible, is there a fix to this problem on its way to us? Is there a useful workaround that doesn't require manual intervention?
Thanks,
A.
View 3 Replies
View Related
Jun 18, 2015
I have a drill down report which need to be exported to excel. But, when exporting to excel it shows many unwanted blank rows for a particular record due to the drill down option.
Is it possible to remove it?
I need to exclude the rows in yellow color when exporting to excel.
View 4 Replies
View Related
Nov 6, 2015
I have an SSRS report with groups that when exported to excel contains drill-in's (plus marks on left side). The issue I have is that for all the groups in the drill-in, those cells become merged. I want to keep the group drill-in but have the cells UNMERGED. I have heard this can be done with the RDL XML but I don't know what to modify to accomplish this.Â
View 4 Replies
View Related
Jun 22, 2005
hi Guys
I want to allow users to have the ability to drilldown. But it doesn't seem possible outside AS ? am I wrong ? As I have built a cube with drilldown enabled and have tested and is working within AS. However after I've opened it up in excel I and tried to drill down it wasn't actually possible. I could only increase / decrease the report's hierachy and that was all.
Anyone know how I can allow my clients to view drill down values ?
any help is appreciated :)
Tom
View 10 Replies
View Related
Sep 8, 2005
Does anyone know if it's possible to use drill-through function, liked it's used in cubes in Analysis Manager, in a webreport in Reporting Services? With drill-through i mean the functionality to see individual rows from the database for a single cell in the web-interface.
Anders from Sweden
View 2 Replies
View Related
Apr 10, 2007
Hi !
I use a OLAP data Source (Analysis Services)
I have a problem, I have a bar chart, where I put an action on the data Properties to move to another report B if there is a clik on.
My report B need a parameter to execute it self.
So In my report A, I add an action which pass the good parameter to the report B.
In my report B, I add a parameter (via report menu, reportParameter item), but I don't how link the two (grid and parameter)...
because, in my report display, I display a grid, and a text area, in the text area I display the parameter which is pass by the drill through, and when I preview it, the value is ok, but not in my table (grid),
I try to add a dimension with ... but I have always an error, and if I put a dimension who is a parameter it is not ok...
I don't understand,
could you help me !?
Thank you
View 8 Replies
View Related
Apr 14, 2007
Hi All ,
I am new to Sql Server and Reporting services ..
I was trying to make a drill down report
I have created Grooup on detail row and set the Visibility with one of the group rows just above ..
But when preview the report I cannot see any data ..
How ever If I Delete the Groups I can see the data ..
Is there anything that I am missing Please help
View 3 Replies
View Related
May 28, 2007
I have a problem on creating a report using Microsoft SQL Server Business Intelligence Development Studio. I am new to this environment, anybody here can help me on how to enable the "DrillDown" on the table?
When I am using the wizard, the option to enable the drill down will appear, but when I am using "Report Server Project", I really don't know how to enable it, and theres was no table properties on how to enabled it.
Could you help me please
Thanks
View 4 Replies
View Related
Jun 5, 2007
Hi All,
I have one dotnet applciation in that i am viewing the report in report viewer. In the same report if the user clicks on one field another report will open. I got a problem with this second report. the image placed on the second report is not coming and if the user clicks on the print button which is on the report viewer the first report is only getting printed. How can I print the second report.
Thanks In Advance
View 1 Replies
View Related
Apr 4, 2007
Hello everybody,
I have a small challenge for you.
I'm developing an application using SQL Integration Services and SQL Reporting Services. I need to have the ability to drill down from a graph created with Reporting Services.
Let me explain: If I have a pie chart, I want to be able to click in one of the slides and see the information details that could be in another graph or in a table.
Somebody know how to do this?
Thanks for your help
View 3 Replies
View Related
Mar 7, 2008
Hi all,What is Drill Down Reports in Reporting Servies.How can i design Drill Down Reports.
Give me any example to desing Drill Down Reports.
Regards.
View 5 Replies
View Related
May 22, 2006
Does anyone know what code I'd use in an expression to conditionally format based on if the drill down is expanded or collapsed?
Thanks.
in an
in-an
inane
Inna
Ian
Edit...
Revert to "inan"conditionally
conditional
conditionals
conditionality
Edit...
Revert to "conditionaly"
View 3 Replies
View Related
Sep 25, 2007
I was wondering if when you click on the + in a drill down report, does the report requery the database, or is the report just re-rendered without having to query again?
depending on the answer, performance considerations would be different.
View 3 Replies
View Related
May 2, 2007
Hi,
I have created a drill down using a table. The drill down has 13 levels in it which causes a big vacant space between the top level and the mesures on the right hand side. I would like to hide the columns so that when i drill down the measure columns should dynamically move towards the right (as i keep on going to the next level) . I have tried using inscope for hiding that particular column by refering to the previous level group in it but it doesn't seem to be working.
Kindly suggest if anyone has done this before.
Regards,
Vikram
View 3 Replies
View Related
Feb 21, 2007
Any way to have the drill through report open in a new window on the web?
View 4 Replies
View Related
Sep 11, 2007
Hi all
is it possible make drill down reports in crystal
my requirement is like
i have n rows in my report
if am clicking the first column in first row it will list details of that row in between first and second row
Same for all the rows
Quick reply is appreciated
Regards
Rameez
View 2 Replies
View Related
Aug 13, 2007
Hello everyone
For starters i'm using Microsoft analysis services, integration services and reporting services.
All goes well when creating some general overview reports.
Once i get to making drill down reports with only 2000 rows of data is already starts to work very slow (sometimes takes hours). It seems a data cube is only fast for calculations like SUM, PARALLELPERIOD, ... but if it comes to amount of data it is extreemly weak! 2000 rows is not even alot, i've seen reporting tools beeing able to handle a million rows with drill down function.
I'm thinking that this microsoft tool is just not able to handle reports bigger than 100 rows in it combined with drill down. Please proof me wrong because we already paid for the microsoft tools and it would be a shame if we were not able to use them because of bad functionality...
The machine we work on is quite strong (dual core 2.4 ghz, 4 gig ram, ...)
And yes i know you can make reports clickable so they take the value with them to a next report as a parameters but thats not what we are looking for, we need this drill down to work properly with larger amounts of data.
View 1 Replies
View Related
Mar 13, 2007
Hi All,
I have a table which has a country, division, category, product, Valuetype, value
data looks like this:
Country division, category, product, Valuetype, value
---------------------------------------------------------------------
UK Division1 Food Pizza Volume 10000
UK Division1 Food Pizza Revenue 2000
UK Division1 Food Pizza ROI 4.5
UK Division2 Food Pizza Volume 14000
UK Division2 Food Pizza Revenue 2400
UK Division2 Food Pizza ROI 4.1
UK Division2 Drinks Cola Volume 14000
UK Division2 Drinks Cola Revenue 2400
UK Division2 Drinks Cola ROI 4.1
I want to build a drill-through report to be grouped on country, division, category and product.
Can someone help me with some suggestions?
Cheers
Josh
View 1 Replies
View Related
Nov 3, 2006
Is there a way to get the Drill through to work with model viewer controls? Any workaround?
Also, where would I find more complex data mining models for review? SQLServerDataMining site, Microsoft data mining tutorial site, and Data Mining with SQL 2005 book, all checked. Anything else?
-Young K
View 10 Replies
View Related
Feb 1, 2007
I've got a report that drills through to itself, passing different parameters when drilling through. The report work flawlessly in development, flawlessly when you call the report server directly via url, but doesn't always drill through correctly when the report is called using the report viewer on web site. I've gone as far as to create a single aspx page web site that only has this report on it and it still doesn't work.
The drill through works about 1/2 of the time when viewing through the report viewer. But the other half of the time it takes you back to a previously visited parameter, instead of the parameter you clicked on.
So a series of clicks might work like this:
Parameter Clicked - Resultant page
A - Correct "A" page
B - Correct "B" page
C - Correct "C" page
D - Incorrectly taken to "B" page.
It seems to be worse if you throw in any click of the back button.
We thought at first it might be a parameter caching issue, but we turned off all caching and even created a time-stamp parameter to force no caching.
Any thoughts are appreciated.
Craig
View 1 Replies
View Related
Apr 4, 2007
Hello - I am using report builder against models.
Which attributes or properties determine what is shown when you do click/drill into the details? I'm using the adventure works database as my guide and expected the (default,Identifying or Aggregate ) attributes to control it, can you summarize how the drill details are determined? My test from adventure works sample:
Pull Territory Name and #customers into the report
Run it and drill into the details on one of the #customers
It returns Acct#, CustType, CustName, #SalesOrders, Sum of a bunch of sales order fields and # customer addresses.
The first three are the default attributes for a customer and the last sets look to be the default aggregates for the other relations to customer - Sales Order & Address.
Is it safe to say that it pulls in the default attributes of the immediate child and then aggregates of it's children? Does it go recursively?
Thanks in advance,
Toni
View 1 Replies
View Related
Jul 6, 2007
So here goes the explnation. The problem is specifying an all parameter in a drill through on the value cell of a matrix for the columns in the matrix that are not expanded.
Here goes the example
Matrix for sales.
Region | Shop | Number of sales. And then financial period would be at the top. Everything is collapsed on load so it looks something like this.
Region1 | | 50
Region2 | | 75
Then you expand Region.
Region1 | Shop1 | 30
Region1 | Shop2 | 20
Region2| | 75
At this point if you click on the 30 for shop 1 is drills through into another report passing parameter Region1, shop1 and financial period. This is perfect. The problem comes in that if you haven't expanded region1 and you click on the 50 it drills into the other report but passes through Shop1 as the shop parameter. How can I get this to pass though an all option for the unexpanded columns in the matrix. This is ofcourse just an example and my matrix has quite a few more column and stuff.
Please guys, any help would be appreciated.
This is Reporting services 2005 linking to SSAS2005 cube.
Thanks in advance
View 3 Replies
View Related
Jul 21, 2006
Hi,
can anybody tell me if it is possible in RS2005 to create a multi-value parameter in wich it is possibility to drill down? Say i want to use a multi-value parameter to show data for one or more specific years or months. Then the multivalue parameter would contain a list of years, with a + sign next to them, making it possible to drill down to the specific months.
Any help greatly appreciated.
Christopher
View 5 Replies
View Related
Sep 17, 2007
Hi,
I am new to reporting services. We are creating a report with drill-down capability. We have a Date dimension hierarchy defined as Year - Month - Day.
On the report, we expect reporting services send MDX query to SSAS to get the total sales just for the the year, say 2007, when we click the year 2007. Then it send query just to aggregate sales for that month when we click a month.
But when we build the reports, it looks like it always aggregate for all levels. So the performance is bad to first open the report.
How do I resolve this issue? Please help.
Thanks,
Jia
View 3 Replies
View Related
Jun 14, 2007
I've created a report with drill downs that are hidden initially. While viewing the report in preview, I'll expand the drill down to see the data.
If I go and print the report, the report is printed as collapsed (which is the initial setting) rather than expanded (which i expanded in the preview).
Is there a way to print in the "what-you-see-is-what-you-get" kinda way expanding and collapsing drill downs?
Thanks in advance!
View 4 Replies
View Related
Nov 7, 2007
1)i have drill through report..
a is the parent report..
b is the child/subreport ..
after i click link at parent report -(a), it will go to the child/sub report -(b),
but when i want back to parent report,dont have button back...
for your infromation,it will hapened when i deploy to server and use report viewer control from data tab in visual studio..
2)when i click the button print at child report(b) , but it will print the parent report, not the child report..
any setting for this problem?
thanks for reply..
thanks in advance...
View 3 Replies
View Related
Jan 8, 2007
is it possible to have drill down feature in matrix report?
A B C
x 1 0 1
y 2 2 2
z 4 0 7
What would be nice is if the user clicked on "7" and a report opened showing the detail for that value.
View 1 Replies
View Related
Feb 7, 2007
I have a drill through that passes four parameters. Three are passed from the current selections in that reports parameters and the fourth needs to be the customer name they click on in the body of the report so it's passed as Fields!fieldname.Value. When I click on the customer name, the drillthough fires but the report simply doesn't load. If I remove the parameter from the field clicked on and just pass the three parameters, it goes to the drill through correctly and that fourth parameter just sets to the default for that parameter in that report.
I can then simply check that parameter and select the value from the list that is exactly the same as the value I was attempting to pass it in the drill through and report refreshes correctly.
Whatever it is, is something in the manner that the value is passed in the drill through specifically.
Any ideas?
View 1 Replies
View Related