יום רביעי, מאי 6, 2009
The Details of this message are:
“Detailed Message: The pending configuration changes were not successfully added to the cube because of the following error: System.Security.Principal.IdentityNotMappedException: Some or all identity references could not be translated.
at System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection sourceAccounts, Type targetType, Boolean forceSuccess)
at System.Security.Principal.NTAccount.Translate(Type targetType)
at Microsoft.TeamFoundation.Warehouse.OlapCreator.AddAccountToRole(Role role, String accountName, Boolean needToUpdate)
at Microsoft.TeamFoundation.Warehouse.OlapCreator.SetupAnalysisDatabase(Server server, String analysisDBName, String accessUser, String dataReaderAccounts)
at Microsoft.TeamFoundation.Warehouse.OlapCreator.CreateOlap(WarehouseConfig whConf, String accessUser, String dataReaderAccounts, Boolean dropDB, Boolean processCube)
So what can we do about it?
There are two actions to take in this situation:
Purpose: Removing users that are invalid or old.
Step 1: Connect to your analysis services database using Sql Server Management...
יום רביעי, אפריל 22, 2009
In the Excel Guide that I have published I mentioned the reporting capabilities of the Team System 2010, you can read about it here.
There is a webcast that shows how reports are done, this webcast made by Brian Keller and posted to Channel9, you can read more about channel9 here and you can see the webcast here.
In the Webcast Brian shows a few examples of reports from Team System 2008 and how to create custom reports in Team System 2010 using Excel.
יום שני, פברואר 23, 2009
There are times when you need to rebuild the Team System cube, the common scenarios are: whenever you move, restore, rename, or fail over the data-tier server.
The Team System cube is what the Reporting Services is using in order to create the Team System reports.
To perform these procedures, you must have the following permissions in SQL Server:
You must be a member of the sysadmin security group for the database instance for Team Foundation and for the Analysis Services database instance of the Team System data warehouse.
You must be a user of the TfsWarehouse relational database.
יום שני, נובמבר 3, 2008
This post is the seventh and last post that builds the Excel Guide. See the first post here
On this post I will show how using the Excel you can create reports with a click of a button, it is important to mention that you need to have the rights on the reporting services server in order to create reports.
In the Rosario you don't need to be an expert in order to create a very impressive reports, just follow these simple steps:
Step 1: Create a query in order to have more accurate reports, the query must be flat...
יום ראשון, מרץ 11, 2007
The Reporting Services enables us to create custom reports for our BI needs.One aspect of creating such a report is sometimes using a built-in sub-report, nested in a Table or Matrix object inside our main report.
This sub-report (which is actually another RDL file) creates a problem when trying to export all the report (main and sub) to Excel and display all its data properly:When we try to view the sub-report data in Excel we see a message: "Subreports within table/matrix are ignored".This problem occurs due to a technological limitation, not solved yet by Microsoft, disabling Excel from rendering correctly...