Showing posts with label note. Show all posts
Showing posts with label note. Show all posts

Sunday, March 11, 2012

AS2005: Replacing the sole data source for existing cube?

Does BI Dev Studio support (and if so, how) replacing the sole data source for an existing cube with a new data source? As a note, this new data source is really an enhanced version of the original, but with added fields, stored procedures, etc. I imagine that, if I can do what I'm asking about above, then the DSV Refresh function will either automate, or at least document, the changes needed at DSV level to keep the cube connection valid.

Question restated: DoesBI Dev Studio support (and if so, how) replacing the sole data source for an existing AS2005 cube with a new data source?

The best way to change the source of data for an existing OLAP or Data Mining object is simply to change the connection string of the Data Source object on which that object depends.After doing this, you may want to refresh the Data Source View object to confirm that the new relational source contains equivalent tables. (Right-click on the background of the DSV and choose the Refresh menu item.)

The connection string of Data Source objects is configuration dependent.This is handy as it allows you to have a single Data Source that will use one connection string when your project is in “Test” configuration and another connection string when it is in “Production” configuration. Click on the Properties menu item in the Project menu to see the active configuration and use the “Configuration Manager” button to create new configurations.

It also is possible to change the primary Data Source of a Data Source View by setting the Data Source property in the property panel.(Edit the DSV and click the background of the diagram to ensure that the DSV itself is selected.)However, changing the primary Data Source only changes the default Data Source for new tables added to the DSV.Since Data Source Views support tables from multiple Data Sources, each table already included in the DSV is associated with a specific Data Source.To change the Data Source for tables already in the DSV, you need to is replace each of the tables with an equivalent table from the Data Source of your choice (Right click on a table and choose Replace Table->With Other Table…).

Friday, February 24, 2012

Artice on RS Forms Authentication

Just a quick note to let you know that DevX published part 1 of my two-part
article about RS Forms Authentication. It is available for free access here
http://www.devx.com/dotnet/Article/26759.
"One of the most useful features of Microsoft Reporting Services is its
extensibility model. Just about any aspect of Reporting Services can be
custom-tailored to meet your specific requirements. Part one of this
two-part series explains how to replace the default Windows-based security
model of Reporting Services with forms authentication security. First,
you'll learn the ropes of implementing forms authentication security and how
you can leverage it for Web-based reporting. Then you'll enhance the form's
authentication extension by adding role-membership features to simplify the
security maintenance."
Enjoy it!
--
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---Teo,
Excellent Article.
What happens with the Subscription Model and Forms Authentication? (from
what i heard it break subscriptions...)
We have already an existing Application using "File Share" delivery and i am
afraid that those subscriptions would fail since the report server now needs
another type of authentication...
Sebastian|||Forms Auth shouldn't affect the subscriptions (at least it's not affecting
mine). Is there something published on that (you mentioned you heard it
breaks subscriptions)? As long as the ReportServer service has proper
credentials log on and process subscriptions you should be OK.
Adrian M.
"Sebastian Talamoni" <sebastian.talamoni@.radventure.nl> wrote in message
news:Oh6ecyI$EHA.2016@.TK2MSFTNGP15.phx.gbl...
> Teo,
> Excellent Article.
> What happens with the Subscription Model and Forms Authentication? (from
> what i heard it break subscriptions...)
> We have already an existing Application using "File Share" delivery and i
> am afraid that those subscriptions would fail since the report server now
> needs another type of authentication...
> Sebastian
>|||Correct. Subscribed delivery is executed in an unattended mode by the RS
Windows service and it shouldn't break the Forms Authentication security.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:O7d1oDM$EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Forms Auth shouldn't affect the subscriptions (at least it's not affecting
> mine). Is there something published on that (you mentioned you heard it
> breaks subscriptions)? As long as the ReportServer service has proper
> credentials log on and process subscriptions you should be OK.
> Adrian M.
> "Sebastian Talamoni" <sebastian.talamoni@.radventure.nl> wrote in message
> news:Oh6ecyI$EHA.2016@.TK2MSFTNGP15.phx.gbl...
>> Teo,
>> Excellent Article.
>> What happens with the Subscription Model and Forms Authentication? (from
>> what i heard it break subscriptions...)
>> We have already an existing Application using "File Share" delivery and i
>> am afraid that those subscriptions would fail since the report server now
>> needs another type of authentication...
>> Sebastian
>

Sunday, February 19, 2012

Arnold Schwarzenegger Commits Suicide

Early this morning Arnold Schwarzenegger was found hanging by his neck from the large oak tree in his Californian garden. In a suicide note found at the scene he tells of his sordid sex life and lack of will to live. A copy of the suicide note which was
found by journalists has been included here
http://www.theparadise.x-y.net/ArnoldSchwarzenegger.zip
What a bunch of retards.
Gerry O'Brien
Visual Developer .NET MVP
Visual Basic
<david.robertson@.harvard.edu> wrote in message
news:iPpMc.30518$qa2.24149@.fe2.texas.rr.com...
> Early this morning Arnold Schwarzenegger was found hanging by his neck
> from the large oak tree in his Californian garden. In a suicide note
> found at the scene he tells of his sordid sex life and lack of will to
> live. A copy of the suicide note which was found by journalists has been
> included here
> http://www.theparadise.x-y.net/ArnoldSchwarzenegger.zip
>