Author Archives: Zahid

About Zahid

Team Lead at IQVIA ( Fields of expertise are C#,BI Reporting (MSBI, Microstrategy, Excel, ASP.NET Dashboards etc.) , ETL, Data Warehouse, OLAP Cube, MDX etc.

Restore SQL Server database using SAS from Azure Blob Storage

You need to create a SQL Server credential first to restore a database back up from Azure blob storage. A lot of writings can be found around the web on this. Most of them have used Azure Storage Account to … Continue reading

Posted in Azure, SQL, Database | Tagged , , , , | Leave a comment

Device specific logic in Microstrategy

Sometimes you may need to set device specific logic in your microstrategy documents or reports. For example, some VI charts show different labels or different headers for iPad and you may want to hide them in iPad using a rectangular … Continue reading

Posted in Microstrategy, MSTR | Tagged , , , , , , , | Leave a comment

From SQL to Spark

When I started learning spark, I decided to learn it from the other way round. That means, rather than going through a step by step journey, I decided to learn it from BI reporting perspective. I took a table with … Continue reading

Posted in Spark, Python | Tagged , , , , , | Leave a comment

Visual Insight charts inside Microstrategy documents

Microstrategy visual insight has lots of exciting beautiful looking charts. But many of them are not available in documents. You can import them into document following the steps described below. But, do not do this unless you really have to … Continue reading

Posted in Microstrategy, MSTR | Tagged , , , , , | Leave a comment

Metric calculation based on selection in Microstrategy

Hello guys, I am back after a long time. I was learning Microstrategy during last one year. So, here I am, writing something on mstr. Today, I am writing about a problem that almost every mstr developer faces. Let’s say, … Continue reading

Posted in Microstrategy, MSTR | Tagged , , , , , | Leave a comment

What I have learned in the name of unit testing of ETL, DWH, OLAP Cube and MDX

In one of our projects, we ‘somehow’ decided that every part of the system should be ‘unit test’-ed . It was a classical ETL->DWH->Cube project where web dashboard was built to show BI reports from cube (using MDX as reporting … Continue reading

Posted in SQA, Testing, SQL, Database | Tagged , , , | 2 Comments

Common Latest Period in SSAS Cube

Recently I came across a situation where data was being delivered at different times for different countries and client wanted to see data for latest common month in Region/Continent level reports.┬áData arrive on monthly basis, but it arrives at different … Continue reading

Posted in MDX, SSAS (Analysis Service), Cube | Tagged , , , , , , , | Leave a comment