|
|
-
|
|
There have been a few times when I have created SSAS partitions outside of BIDS using script code in an SSiS package, then later made a change in BIDS and deployed the cube, wiping out those partitions (since they did not exist in the BIDS project).
To pre...
|
|
-
|
|
In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does not support BI. Meaning, VS 2012 does not support SSAS, SSIS, or SSRS. If you try to open one of those projects, you will be greeted with:
At least th...
|
|
-
|
|
In the multidimensional model in SSAS, there is a storage mode called relational OLAP (ROLAP), which is the multidimensional solution for allowing real-time access to relational data sources. In the tabular model in SSAS, the solution for real-time access...
|
|
-
|
|
If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database in memory (greatly compressing the database). So what happens if your database is too big to fit in memory? You will get this error when you pro...
|
|
-
|
|
A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes a cube to become unprocessed, forcing you to do a full process so the cube is usable. Nothing is worse than making a change without realizing ...
|
|
-
|
|
I received this error the other day when trying to process a particular SSAS cube:
Error 18 File system error: The following file is corrupted: Physical file: file:///\\%3f\E:\SQL\OLAP\Data\Options”>\\?\E:\SQL\OLAP\Data\Options BI QA.0...
|
|
-
|
|
When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when you use the “Deploy” option (such as structure changes or aggregation design changes). This means a lot of sitting around and waiti...
|
|
-
|
|
To expand on what I talked about in SQL Server 2012 (“Denali”): Details on the next version of SSAS, there is a new data model called Tabular. So when you are creating a new project, which model should you use, Multidimensional vs Tabular? Well, there is...
|
|
-
|
|
My previous blog, SQL Server 2012 (“Denali”): Details on the next version of SSAS, talked about the major new feature in SSAS, which is BISM. But what other changes are there? Well, not much. Here are details on the few changes I have found:
All develo...
|
|
-
|
|
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio, and now supports SQL Server 2012 (including tabular mode) and Visual Studio 2010 (SSDT). Version ...
|
|