Traditionally, BI solutions are implemented during the second or third phase of an Enterprise Resource Planning (ERP) implementation project. Needless to say, project fatigue sets in (and the budget gets exhausted), and subsequent phases are postponed or delayed. BI implementation is complex and involves the integration of many components. Also, the skill set required to…
Kategori: SQL Analysis Services
SQL Analysis Services
Dynamics AX 2012 – Report labels does not show up in report
by Bo Jensen •
Sometimes the report labels do not show in reports or the report shows label IDs like Labels!@SYS2123 instead of label values.
SQL Analysis Services
How to Default to ALL in an SSRS Multi-select Parameter » The Data Queen
by Bo Jensen •
This seems like it should be easy, but SSRS has nothing built in to allow you to do this. I searched an couldn’t come up with a solution that fit all my requirements for a report. There are ways to default the selection list to every value in the list, but I needed to add…
SQL Analysis Services
Reports in SSRS with Multi Value Parameters and NULL Values
by Bo Jensen •
If you are creating a SSRS report in Visual Studio 2008 and would like a parameter to display multiple values including NULL values, you will get a message saying, “A multi-value parameter cannot include null values”.
SQL Analysis Services
SSRS optional parameters settings
by Bo Jensen •
Recently I had to create couple SQL Server Reports (SSRS) with optional parameters built in. It took me a while to refresh memory how this can be done. It was very simple to create reports and processes behind, but connecting these two were are little bit challenging – stored procedure was tested and worked fine,…
SQL Analysis Services
Optional filter in SSRS | Musings by Generator
by Bo Jensen •
I am astonished that this is not a feature in SSRS. How can you expect business users to create expressions to handle an optional filter. So for those looking how to do an optional filter on a parameter, here is how to do it:
SQL Analysis Services
Using the .NET Business Connector to read/write data to Axapta
by Bo Jensen •
In the next example, we create a new project in Visual Studio and add the reference to the project. You can skip this step if you already have a project where you would like to use the .NET Business Connector.
SQL Analysis Services
Using Dynamics ‘AX .NET Business Connector’ to access Dynamics AX 4.0 from .NET world
by Bo Jensen •
So, this is a really interesting integration aspect between AX and .NET apps. We want to access AX business logic (or data, transactions, etc.) from the .NET world. 🙂
Microsoft Dynamics Ax, SQL Analysis Services, Business Intelligence
Setting up scheduled processing of cubes in AX2012
by Bo Jensen •
Here is a quick guide on how you can easily and quickly setup scheduled processing of the cubes for Microsoft Dynamics AX 2012. The same approach works for other Analysis Databases, but sometimes it helps to put things in context in order to make it easier for you AX geeks out there.
Microsoft Dynamics Ax, SQL Analysis Services
Cube and KPI reference for Microsoft Dynamics AX [AX 2012]
by Bo Jensen •
Cube and KPI reference for Microsoft Dynamics AX [AX 2012] Cube and KPI reference for Microsoft Dynamics AX [AX 2012] R2 and R3
Microsoft Dynamics Ax, SQL Analysis Services
Dynamics AX: AX 2012 – Process Cubes Error: translations in Standard Edition
by Bo Jensen •
Dynamics AX: AX 2012 – Process Cubes Error: translations in Standard Edition
SQL Analysis Services
Processing an OLAP cube with a T-SQL Stored Procedure
by Bo Jensen •
Processing an OLAP cube with a T-SQL Stored Procedure
SQL Analysis Services
CODE Magazine – Article: The Baker’s Dozen: 13 Tips for Querying OLAP Databases with MDX
by Bo Jensen •
CODE Magazine – Article: The Baker’s Dozen: 13 Tips for Querying OLAP Databases with MDX
DotNET, SQL Analysis Services
Cubes, MDX, Analysis Services and ADOMD in C# – CodeProject
by Bo Jensen •
Cubes, MDX, Analysis Services and ADOMD in C# – CodeProject
Microsoft Dynamics Ax, SQL Analysis Services, Business Intelligence
MS Dynamics 2009 Analysis Extension Problem on SQL Server 2008 – A WorkAround
by Bo Jensen •
MS Dynamics 2009 Analysis Extension Problem on SQL Server 2008 – A WorkAround
Microsoft Dynamics Ax, SQL Analysis Services, SQL Reporting Services, Business Intelligence
Dynamics AX 2009: SSRS Reports and the role of Business Logic & Data Methods
by Bo Jensen •
Dynamics AX 2009: SSRS Reports and the role of Business Logic & Data Methods – Saveen Reddy’s blog – Site Home – MSDN Blogs
SQL Analysis Services
Bruce's Blog: The Date Dimension in Analysis Services
by Bo Jensen •
Bruce’s Blog: The Date Dimension in Analysis Services
Microsoft SQL Server, SQL Analysis Services
Walkthrough: Scheduling Administrative Tasks
by Bo Jensen •
Walkthrough: Scheduling Administrative Tasks
Microsoft SQL Server, SQL Analysis Services
How to: Batch Process Analysis Services Objects
by Bo Jensen •
How to: Batch Process Analysis Services Objects
Microsoft SQL Server, SQL Analysis Services
How to: Create an Analysis Services Job Step (SQL Server Management Studio)
by Bo Jensen •
How to: Create an Analysis Services Job Step (SQL Server Management Studio)