Drillthrough Filters

Hi,
Can anyone explain me how to work with the filter tab on Cube drill through
options?
I added an extra table and specified the joining clause in this tab. It
works fine for the first time; but after saving the cube it gives invalid
alias or alias cannot be located. I tried putting the same alias name for the
table but it doesn’t work.
Thanks in advance.
Regards,
Yash
Run SQL Profiler to see what the exact SQL statement being generated looks
like.
My guess is that you have an edit issue in your filter statement.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Yash" <Yash@.discussions.microsoft.com> wrote in message
news:F34694EB-D644-4671-AF0D-2C1896CDDDEE@.microsoft.com...
> Hi,
> Can anyone explain me how to work with the filter tab on Cube drill
through
> options?
> I added an extra table and specified the joining clause in this tab. It
> works fine for the first time; but after saving the cube it gives invalid
> alias or alias cannot be located. I tried putting the same alias name for
the
> table but it doesn't work.
> Thanks in advance.
> --
> Regards,
> Yash
>

Drillthrough Filters

Hi,
Can anyone explain me how to work with the filter tab on Cube drill through
options?
I added an extra table and specified the joining clause in this tab. It
works fine for the first time; but after saving the cube it gives invalid
alias or alias cannot be located. I tried putting the same alias name for th
e
table but it doesn’t work.
Thanks in advance.
--
Regards,
YashRun SQL Profiler to see what the exact SQL statement being generated looks
like.
My guess is that you have an edit issue in your filter statement.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Yash" <Yash@.discussions.microsoft.com> wrote in message
news:F34694EB-D644-4671-AF0D-2C1896CDDDEE@.microsoft.com...
> Hi,
> Can anyone explain me how to work with the filter tab on Cube drill
through
> options?
> I added an extra table and specified the joining clause in this tab. It
> works fine for the first time; but after saving the cube it gives invalid
> alias or alias cannot be located. I tried putting the same alias name for
the
> table but it doesn't work.
> Thanks in advance.
> --
> Regards,
> Yash
>

Drill-down Cross tab reports

Hallo all,
I have to create drill down cross tab reports.
How can I create drill-down cross tab reports using Sql server reporting
services 2005? I am very much in need of help. Can any one help me how i can
create ?
Please kindly some links if any drill down cross tab reports examples
available online?
I am very much thankful to all,if any of you provide me some input to step
further as soon as possible.
regards
miikaOn Mar 12, 6:01 am, aka <a...@.discussions.microsoft.com> wrote:
> Hallo all,
> I have to create drill down cross tab reports.
> How can I create drill-down cross tab reports using Sql server reporting
> services 2005? I am very much in need of help. Can any one help me how i can
> create ?
> Please kindly some links if any drill down cross tab reports examples
> available online?
> I am very much thankful to all,if any of you provide me some input to step
> further as soon as possible.
> regards
> miika
In SQL Server Reporting Services (SSRS), cross-tab reports are called
matrix reports. You should be able to get started on a basic matrix
report via the report creation wizard. As far as drill-down reports,
here is a link that might help.
http://msdn2.microsoft.com/en-us/library/aa964132.aspx
Also, I am offering a Practical SQL Server 2005 Reporting Services
class in the Nashville, TN area available starting April 23rd, if you
are available at that time. You can email me at:
emartinez.pr1@.gmail.com for specifics (incl pricing, course outline,
etc).
Regards,
Enrique Martinez
Sr. SQL Server Developer