I have met a very strange issue when I was creating SSAS partitions using Partition Wizard in SSDT 2012. I have gone through all the steps in Partition Wizard successfully, but no partition was created although everything seems running fine. Although I have managed to create the partitions in the SQL Server Management Studio with no problem, … Continue reading Creating SSAS Partitions through Directly Modifying XML Source file
Author: Linxiao Ma
MDX #4 – Sales Ratio aganist Parent Levels
Business Question 1: How much sales percentage does each product sub-category take aganist the total sales of 'Components' cateogry in 2007 In the example above, the .parent is used to return the current product's parent category. Alternatively, ANCESTOR function can also be used which could specify the level of the category (e.g, we hope to get the percentage of current … Continue reading MDX #4 – Sales Ratio aganist Parent Levels
MDX #3 – Year-Over-Year Comparison within Given Period
Requirement: Users specify a date range by giving a Start Date and a End Date, and expect to make Year-Over-Year comparison of a measure (e.g. Sales Amount) in the given period. For example, a user input start date as "04/07/2007" and end date as "04/11/2007", and want to compare the sales between the period "04/07/2007 - 04/11/2007" … Continue reading MDX #3 – Year-Over-Year Comparison within Given Period
MDX #2 – Top (n) Products Sales in each Sales Territory
To get top (n) products with highest sales in every sales territory, the GENERATE function is exactly what we need which applies a set to each member of another set.
MDX #1 – Year-Over-Year Comparison
1. Monthly or Quarterly Year-Over-Year Comparision PARALLELPERIOD is the function to get the same period in previous year. 2. YTD Year-Over-Year Comparison YTD function can be used to get the period from start of this year to current date. To get the same YTD period in last year, we could combine the YTD and PARALLELPERIOD … Continue reading MDX #1 – Year-Over-Year Comparison
Dynamics CRM 2011 Computer-Telephony Integration Solution Using Flexor CTI Add-on
I have been searching for CTI solutions for Dynamics CRM 2011 and found Flexor CTI is a good choice which provides most of common CTI features, such as click-to-dial, screen popping, on-screen call control, journal and log calls direct to customer records in Dynamics CRM, and also management reporting. This add-on is very easy to … Continue reading Dynamics CRM 2011 Computer-Telephony Integration Solution Using Flexor CTI Add-on
Using Guid of Entity Record in Dynamics CRM Workflow Designer – A Generic Solution based on Custom Plugin
When we create custom Dynamics CRM workflows using the built-in Dynamics CRM workflow designer, there is a common requirement that we want to look up and reference Guid of current entity record in the workflow. For example, when a task is created or assigned in Dynamics CRM site, we often create a workflow to send … Continue reading Using Guid of Entity Record in Dynamics CRM Workflow Designer – A Generic Solution based on Custom Plugin
Tip & Tricks – SSAS Performance Tuning Flow Chart
In the Analysis Services Performance Guide white paper, Microsoft has introduces a very handy flow chat for tuning SSAS performance. The first and key step of the flow chat is to investigate whether the performance problem is caused by query processor or storage engine. If the problem lies in query processor, SSAS developers need to … Continue reading Tip & Tricks – SSAS Performance Tuning Flow Chart
Creating Custom SSRS Spatial Map Reports for Dynamics CRM 2011
A CRM system in an organisation is often the central place to store business data related to customers, sales, and markets, which are highly valuable for any business. The BI feature in Dynamics CRM 2011 is very powerful which allows developers or even end-users to create report tables or charts very easily. However, it is … Continue reading Creating Custom SSRS Spatial Map Reports for Dynamics CRM 2011
Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 4)
Part 1 – Introduction & Building the Back-End Reporting Database Part 2 – Developing SSIS Package to Import Data from Sharepoint List to Reporting Database Part 3 – Setup SQL Server Agent Job to periodically execute the SSIS Package Part 4 – Building Reports and Publish on Sharepoint using Excel Services This part of the … Continue reading Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 4)
Data Ninjago (Finsight-Tech Blogs) 
You must be logged in to post a comment.