Cross Join to Generate Every Combination

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 … in fact, it even makes a good business name … 🙂 Here is a basic example of how a cross join works using userid’s and dates.

Mobile Configuration for your Live Email account

Start sending and receiving your emails on your mobile device quickly and painlessly with the following configuration. Account : Pop3 Email Address : Self explanatory UserName : Same as Email Address Pop Server : Pop Security : SSL If Available Port : 995 Smtp Server : Smtp Security : TLS Port […]

Limiting Sharepoint 2010 Memory on an All in One B.I. Box

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 […]

Performance Point – Importing Items from another server

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 […]

Performance Point Not Seeing Changes in the Cube

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. The moral of the story is make sure the cache interval on your Performance […]

SSAS – Multi – Process Cube in an Agent Job Step

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 […]

SSRS – Create a No Data Returned Textbox

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 […]