Cross Joins are useful in Business Intelligence where you want to perform a cartesian product on two sets of data. Possible uses are discussed below http://stackoverflow.com/questions/219716/what-are-the-uses-for-cross-join … in fact, it even makes a good business name http://www.crossjoin.co.uk/ … 🙂 Here is a basic example of how a cross join works using userid’s and dates.
Some sample code for how to get the parent’s description in a parent child hierarchy using a CTE.
Start sending and receiving your Outlook.com emails on your mobile device quickly and painlessly with the following configuration. https://ironcovesolutions.zendesk.com/entries/20330427-imap-pop-settings-for-major-mail-providers Account : Pop3 Email Address : Self explanatory UserName : Same as Email Address Pop Server : pop3.live.com Pop Security : SSL If Available Port : 995 Smtp Server : smtp.live.com Smtp Security : TLS Port […]
With all of these new fandangle self service Business Intelligence tools hanging off Sharepoint now, you may want to protect the precious box against unintentionally melicious drag and drop power moves. Sharepoint and SQL Server on the same box is an easy equation and easy to install, however if things start to bog down and […]
Nice how-to on how to import performance point items from one server and deploy the content to another. Much like importing content into an empty Visual Studio solution, the same idea applies to a Performance Point workspace file. It starts with opening up Dashboard Designer on the source server, then saving the content into a new workspace […]
If you have made changes in your cube yet you don’t yet see the changes in Performance Point, it is likely that the old schema is cached. A general rundown on how caching works in Performance Point is outlined below. http://blogs.msdn.com/b/performancepoint/archive/2010/04/16/a-general-caching-overview-for-performance-point-services-for-sharepoint-2010.aspx?Redirected=true The moral of the story is make sure the cache interval on your Performance […]
You created your first Performance Point data source in Performance Point Dashboard Designer, you fill in the servername, however when you select the database you get the error along the lines of “Data source cannot be used because PerformancePoint Services is not configured correctly”. This should just be a matter of going into Sharepoint […]
If you want to automate a nightly cube reprocess in development but don’t feel like creating an ETL package, you can create a quick SQL Server Agent job with a job step type “SQL Server Analysis Services Command”. Put the server name for your Analysis Services server in the “Server” field, then adapt your […]
You get an error in your BIDS browser in Analysis Services “The LocaleIdentifier property is not overwritable and cannot be assigned a new value”. In the cube browser window there will be a field called “Language” – change this to the current language setting for your computer (the cube language setting will most probably be […]
When the dataset returns no rows, a bit of U.I. certainly goes a long way to avoid any confusion for the user running your report. Create a textbox somewhere convenient on the page, and enter this in the expression for your textbox, substituting in your real dataset and field name. …then enter this in the Hidden […]