Stack Overflow
Stack Overflow

Questions tagged [drillthrough]

81 questions
1
vote
0 answers

Can you remove drill through filter from measures in Power BI?

I am trying to use the drill through filter to take my user to other data related to that date. Essentially I have an overview page and I want the user to click on a date and drill through to the next page, where it will show them test scores…
May32
  • 11
  • 1
1
vote
0 answers

Power BI Drill Through on multiple rows

I have a table with a category that currently drills through to a home page. I was wondering if there was any way to select multiple categories on this list then drill through with that selection. Ctrl left clicking then right clicking does not…
BusinessCertain
  • 25
  • 4
1
vote
2 answers

How to turn the drillthrough filter off in a single visual in Power BI?

I'm working with Power BI Desktop. I have a report page with a visual component that applies the drillthrough action. When I use the drillthrough, I get into the next report page. In the next report page, I have several visualizations. But there is…
Kalllkkis
  • 13
  • 1
  • 1
  • 3
1
vote
0 answers

Custom Formatting removes natural drill through capability - manual solution needed

There is a need to create custom formatting for an indented Financial Statement with subtotals. This is not out of the box Power BI functionality and to reach a solution, the inherent aggregation and drill down functionality has been stripped from…
Spencer
  • 11
  • 1
1
vote
1 answer

Combining multiple drill through reports into one

First time posting here so please be kind. I've come from using PowerBI to achieve pretty much everything I need to with a couple of clicks to using SSRS 2008... and I'm having a hard time. Here's what I'm trying to do: I have a main report that…
luciefi
  • 11
  • 2
1
vote
1 answer

SSRS Drill down report not using same credentials as parent report

I have created a drill down SSRS report where I have put text boxes and 5 sub reports and one as main report.For main report datasource I have selected "Display the following text to prompt user for a user name and password:" and have checked "Use…
Malik Kattubadi
  • 11
  • 1
1
vote
1 answer

PowerBI: Use non-shown values for Drillthrough

I am trying to build a Power BI report for data from a SQL database where I have to show detail pages using Drillthrough. The only viable way to connect the datasets is using the database row ids. From a user's perspective the row ids would not add…
Christian Held
  • 2,321
  • 1
  • 15
  • 26
1
vote
1 answer

Power BI - Drill through filter isn't working for date columns

I'm pretty new in Power BI and have a problem with the drill-through filter. Here is what my table looks like: When I add a drill-through filter on another report page, I can't use on this page right click-> drill-through whereas if I add a…
mafioso
  • 1,630
  • 4
  • 25
  • 45
1
vote
1 answer

Drill Through/ Drill Linking/ Drill Down using Pentaho Report Designer

I'm using Pentaho Report Designer Version: 8.0.0.0-28. I have one summary report (1) and one detailed report (2). Let's say I have this scenario: I have these columns in (1): Employees, Total hours (2): Employees, Day, Total hours per day I…
metk
  • 69
  • 1
  • 10
1
vote
0 answers

SSAS DefaultMaxDrillThroughRows is set 10000 but showing 1000 only in sql server

When I am browsing the deployed cube in SSAS server, the drillthrough action is returning only the first 1000 records. I have already checked the DefaultMaxDrillThroughRows value for the server and it is set as 10,000. Yet the records being returned…
pso
  • 819
  • 12
  • 25
1
vote
1 answer

SSRS drilldown in text box tag cloud

I have made a tag cloud using custom code from SQL Jason which displays the words using custom code`Public Function BuildHtmlTag(ByVal Keywrd as String, ByVal Num as Integer, ByVal FColor as String) AS String HtmlTag = HtmlTag & "" & Keywrd & "…
user4916009
1
vote
2 answers

Remove duplicates from OLAP Drill in SSAS

I am using Visual Studios BIDS to modify an existing OLAP cube. In SSMS: There is an underlying fact table (FactTableMain) with a very fine grain that contains 10 different measures to track the status of an application (they act almost like a…
SacredPanda
  • 23
  • 4
1
vote
0 answers

SSRS Report, Changed Parameter value can not be passed to drill through report

I have been requested to create a SSRS report. Report have one parameter X with value X1(default value) and X2. Add a textbox display @X and set Action on that textbox go to report to itself. Pass @X as parameter. Run report X1 displayed in textbox.…
Joel Wang
  • 11
  • 2
1
vote
1 answer

SSRS Drillthrough Report with one or more charts from Main Report

I am totally new to SSRS. I am not sure if my title explains what I want. I am creating few Dashboards for my Healthcare Database. Therefore I created a Patient summary report and a Patient details report. Patient summary has: One Pie chart that…
Gayu
  • 487
  • 5
  • 21
0
votes
4 answers

Is it sensible to store long, unique text strings in OLAP cubes for drillthrough retrieval (especially in SSAS)?

I'm motivated to store some long text strings in an OLAP cube, long on the order of 1,000s or 10,000s of characters -- but I'm wondering if this will lead me astray. (I'm also curious to learn a little more about how OLAP engines handle strings.)…
Chris
  • 9,986
  • 8
  • 48
  • 56
1
2
3 4 5 6