Drop merge filter (pull subscription)

Hi everybody,
I'm trying to remove a rowfilter (and 'JOINS') from one of my publication.
When I first tried this on a testdatabase everything seemed to work. But it's
not working on the productiondatabase. I always receive this message:
Cannot drop filter 'Table1_Table2' from publication 'NamePublication'
because its snapshot has been run and this publication could have active
subscriptions.
I don't know how to solve this. Any help would be appreciated!
Thanks!
Benno,
try scripting it out, delete the publication then run the script, be sure to
disable the snapshot agent, then remove the filter.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
thanks for your reply bu I'm afraid I don't understand all of it: do you
think I should delete the publication (without deleting the subscriptions?)
and than recreate it (using the script I created first)? And how would you
delete the publication: EM or stored procedure?
Thanks!
"Paul Ibison" wrote:

> Benno,
> try scripting it out, delete the publication then run the script, be sure to
> disable the snapshot agent, then remove the filter.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Benno - that's right. If you script out the publication and subscriptions,
you can then delete the subscriptions and the publication. Aftert that you
use the script to create the publication. Delete the filters you don't want
then add the subscriptions and initialize.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
can I create and drop the PULL subscriptions "remotely". I don't want to
visit all subscribers to drop the subscription and recreate it afterwards...
Thanks!
"Paul Ibison" wrote:

> Benno - that's right. If you script out the publication and subscriptions,
> you can then delete the subscriptions and the publication. Aftert that you
> use the script to create the publication. Delete the filters you don't want
> then add the subscriptions and initialize.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
|||Benno,
in the case of merge replication, the script to be run at Subscriber
includes:
exec sp_addmergepullsubscription
exec sp_addmergepullsubscription_agent
If you can connect to and register in EM all the subscribers and run this,
then it can all be set up from one location.
The corresponding script to set up all these subscriptions is also
obtainable for EM: Right Clich the publications foldes and select to
Generate SQL Script...
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

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 Through bringing back too many results

I have created a Matrix Report through the Report Builder and specified a filter on a Date field so it only shows the current months work. This works for the initial Totals within the Matrix but when you click on the Totals to show the Drill Down it will show all the results regardless of the Parameter.

How do I make the results in the Drill Through look at the Parameter I am passing to the Report?

Many Thanks

I'm not sure I understand your scenario, and I can't repro the behavior you describe using my best guess. Can you clarify:

1. What fields are in your report?

2. Did you actually create a report parameter by setting Prompt on the filter condition, or did you just create a normal report filter?

Any other info you can provide to further clarify your scenario would be helpful. Thanks!