Home > Archive > MS SQL Data Warehousing > March 2005 > Drillthrough Filters









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Drillthrough Filters
Yash

2005-03-31, 7:01 am

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

Dave Wickert [MSFT]

2005-03-31, 8:01 pm

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@microso
ft.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
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com