Minimize
01

 

Be very careful when deploying Reporting Services Report models.  Do not deploy them and their associated reports until the model is stable. Otherwise when you change the report model, you may break all of the reports.

This list comes from Bob Meyers web site, dated Sept, 2006.

You can change anything except the following in a report model, and existing reports will still run:
Entities
·         ID
·         Inheritance properties
 
Attributes
·         ID
·         DataType
·         IsAggregate properties
·         entity membership
 
Roles
·         ID
·         Cardinality properties
·         entity membership
·         related role
·         Related Role cardinality
·         Related Role entity membership.
 
The report will run, but may give different results if you change:
·         Attribute expressions,
·         entity/attributerole bindings
·         Definitions of tables and columns in the DSV (e.g. by modifying a Named Query),
 
It is OK to change:
·         Organize and re-organize things in and out of folders
 
To Deprecate a Field:
·         Use the Hidden property to exclude it from the design-time experience in Report Builder.

Comments

There are currently no comments, be the first to post one.

Post Comment

Only registered users may post comments.

LatestArticles Minimize
Changing Granularity of Leaf Level Calculations in SSAS Tabular by Jason Thomas

Finding Nearest Stores using SSRS Map Reports by Jason Thomas

Heat Maps for SSRS using Map Control by Jason Thomas

Parameters for Analysis Services Reporting: Introduction, Pt. 3 by William Pearson
BI Architect Bill Pearson continues an extended examination of parameterization within Analysis Services reports. In this, Part 3 of the article, we continue to get hands-on practice cr...

Parameters for Analysis Services Reporting: Introduction, Pt. 2 by William Pearson
BI Architect Bill Pearson continues an extended examination of parameterization within Analysis Services reports. In this, Part 2 of the article, we continue to get hands-on practice cr...

Using Annotation Tables in SSAS to Show Last Processed Time and Latest Data Updates as a Measure in a Cube by John Hall

Using Color in SSRS Charts by Melissa Coates
Effective data presentation techniques help users  interpret information quickly and reliably.  Layout, formatting, sizing, labeling, and other report elements may all be used to facilitate ...

Is TOAD faster than BIDS Query Builder? by John Hall

SSRS: Unexplained Warning “This field is missing from the returned result set from the data source” And Checking a Field for Null Exception by John Hall
If you ever see the warning message “This field is missing from the returned result set form the data source” and get unexplained #Errors in columns on your report it may be from SSAS not returning a ...

Beyond Excel pivot tables: Leveraging cube formulas with MDX by Javier Guillen
PowerPivot and DAX are a powerful technologies, but there is still a good amount of work that can be done with traditional cube functions. In its current version, PowerPivot lacks the concept of ...


Advertisement Minimize

Advertisement Minimize

Copyright 2004-2012 MSBICentral.com Terms Of Use Privacy Statement