Category Archives: Uncategorized

Amplify Data Analytics with the Lighthouse Data Analytics model – Part 2 – CoE’s key functions

Posted on November 2, 2024 by Dharmesh

Part 2 of the Lighthouse Analytics Model, this post covers the Key Functions of the Data Analytics CoE. This is a rather short summary post, no need to spell out the details , rather highlight the key functions. The Data … Continue reading →

Posted in Uncategorized | Tagged , , , , , | Leave a comment

Amplify Data Analytics – Decentralise and embed into the business

Posted on September 17, 2024 by Dharmesh

Intro Data is the new water for today’s organisations. It is essential for their survival and growth, as it nourishes every aspect of their operations and strategy. It needs to flow to all users enabling them in making informed decisions … Continue reading →

Posted in Uncategorized | Tagged , , , , , | Leave a comment

Relative Period Modelling Part 2 – SSAS Multidimensional & ZERO MDX!

Posted on February 10, 2019 by Dharmesh

My second post of the Relative Period Modelling – detailing how to use the Relative Period database design in a SSAS (SQL Server Analysis Services) multidimensional cube. Remove the need to write a SINGLE MDX code for relative periods! Note, this … Continue reading →

Posted in Uncategorized | Leave a comment

Relative Period modelling for multiple platforms

Posted on January 13, 2019 by Dharmesh

There are a lot of write-ups on relative periods, and different methods exist for a variety of tools. Interestingly each platform requires special handling, e.g. COGNOS Transformer & TM1 handles relative periods differently to SSAS multidimensional, and again differently to … Continue reading →

Posted in Uncategorized | 1 Comment

COGNOS Cube reports–slow performance

Posted on May 29, 2012 by Dharmesh

This week, I took on optimising a cube report which I had authored recently. This was a not too complex burst report working off an SSAS 2008 cube. The report was taking around 1 minute per burst, with around 500 … Continue reading →

Posted in Uncategorized | Leave a comment

COGNOS 10 Upgrade from 8.3

Posted on January 10, 2011 by Dharmesh

Currently in the process of performing a COGNOS BI upgrade from 8.3 to 10.1. Instead of performing a big bang approach upgrade on the existing server, have deployed a new server, and performed a clean install of 10.1. Setup the … Continue reading →

Posted in Uncategorized | Tagged , , , | Leave a comment

About me

Posted on January 10, 2011 by Dharmesh

My name is Dharmesh Kalyan, and I am Data Professional loving all things Data and Business Intelligence. Have been working with Data for a number of years from small analytical databases to large scale Data Lakes and Data warehouses supporting … Continue reading →

Posted in Uncategorized | Leave a comment