Category Archives: Current

It holds everyday news, we found related to Business Intelligence.

Top 5 Books to understand Business Intelligence and its need

Found this great article on top 5 books on Business Intelligence. These books are really awesome to understand what is business intelligence and how it can be utilized in any field of organization. Few of the following books also demonstrate how business intelligence is a tool for long life of any business and how it is must for future.

You can find these books at amazon.in (Click on photos or name of books)

          1. Business Intelligence for Dummies
            (Price: Rs. 523/ 4 Star rating with 33 Customer)
          2.  Business Intelligence Guide Book
            (Price: Rs. 2435/ 4 Star rating with 16 Customer)
          3. Successful Business Intelligence, Second Edition
            (Price: Rs. 600/ 4.5 Star rating with 16 Customer [Amazon US])
          4. Business Intelligence Roadmap
            (Price: Rs. 751/ 4.5 Star rating with 30 Customers)
          5. Business Intelligence Strategy
            (Price: Rs. 1619/ 4.5 Star rating with 15 Customer [Amazon US])

Find the full detail on books and this good post here:

5 Business Analytics and BI Books That Should Be On Your Reading List

Advertisements

Delete full or partial data from MDS entity

I have started Microsoft MDS (Master Data Services) as a new category to share some really quick and helpful solution of problems faced while working. Let me know if you have Questions in comments section.
To delete partial (good number of rows) or full Entity data with MDS database, Manual UI usage is slow and really bad if numbers of rows are good enough.

Use following query and read the comments /* . . . */ to see where you can update, based on your situation to get things done.


DECLARE @DateTimestamp nvarchar(100) = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(19),GETDATE(),120),' ',''),'-',''),':',''); /*Can be used to have distinct Timestamp in BatchTag of stg entity data push*/

DECLARE @MDSVersion nvarchar(20) = 'VERSION_1';/*Specify latest version of MDS model*/
DECLARE @DeleteBatchTag nvarchar(100);


SET @DeleteBatchTag = 'Delete' +'Entity1' + @DateTimestamp ;
INSERT INTO [stg].[Entity_1_Leaf]
(ImportType, ImportStatus_ID, BatchTag, Code)
SELECT 6 AS ImportType,

/*Import Type 6 will help you to delete the rows even if Entity is referred in other child entities as Domain Based. Don't use 4 import type as its going to put you in viscous cycle of deactivated - activated domain based data.*/


0 AS ImportStatus_ID,
@Action_BatchTag
, Code
FROM mdm.Entity_1
/* Use WHERE clause on current data in entity to specify what you want to delete */
WHERE Name Like '%Test%';

EXECUTE [stg].[udp_Entity_1_Leaf] @VersionName = @Version , @LogFlag = 0, @BatchTag = @DeleteBatchTag , @Batch_ID = NULL;