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
>

Drillthrough

Hi,
While enable drillthrough on a cube. There is a option to extra add tables.
How is the relationship mananged for these table; do i need to join it to the
fact table or the dimension tables.
How to remove a table added through this option.
Thanks a lot in advance.
Regards,
Yash
You need to write the join clause in the Filter tab. If you uncheck all
columns used by the additional tables and save they will be gone
Regards,
Plamen
"Yash" <Yash@.discussions.microsoft.com> wrote in message
news:5D9CD437-D326-415E-880F-EF1D590D3B88@.microsoft.com...
> Hi,
> While enable drillthrough on a cube. There is a option to extra add
tables.
> How is the relationship mananged for these table; do i need to join it to
the
> fact table or the dimension tables.
> How to remove a table added through this option.
> Thanks a lot in advance.
> --
> Regards,
> Yash
>

Drillthrough

Hi,
While enable drillthrough on a cube. There is a option to extra add tables.
How is the relationship mananged for these table; do i need to join it to th
e
fact table or the dimension tables.
How to remove a table added through this option.
Thanks a lot in advance.
--
Regards,
YashYou need to write the join clause in the Filter tab. If you uncheck all
columns used by the additional tables and save they will be gone
Regards,
Plamen
"Yash" <Yash@.discussions.microsoft.com> wrote in message
news:5D9CD437-D326-415E-880F-EF1D590D3B88@.microsoft.com...
> Hi,
> While enable drillthrough on a cube. There is a option to extra add
tables.
> How is the relationship mananged for these table; do i need to join it to
the
> fact table or the dimension tables.
> How to remove a table added through this option.
> Thanks a lot in advance.
> --
> Regards,
> Yash
>