Tags » EDW

Supercharge Your Dynamics GP Dashboards & Reports with Power BI

During my last blog post, I walked you through creating a financial dashboard using Power BI with Dynamics GP data. I have created additional analysis and measures now. 236 more words

BI

WOW! A Dynamics GP multi-company Financial Dashboard - Part Deux

Back in October of 2015, I posted a blog about how to modify Jared Hall’s awesome Excel Financial Dashboard that you can download here. The problem with his solutions is that most Dynamics GP environments are multi-company setups making these dashboards not very functional without navigating and opening multiple Excel spreadsheets to view each company’s dashboard. 334 more words

BI

Winnipeg is Officially a Winter City

It’s official, Winnipeg is now an official winter city! Winnipeg can now own “Winterpeg.”

In a ceremony held at the Assiniboine River on January 30, 2017, the City of Winnipeg and Economic Development Winnipeg Inc. 359 more words

Winnipeg News

Schema-less or Schema On Demand

I am trying to define what are the criteria for a schema-less, or a schema on demand data storage.

In relational database, we use DDL, data definition language, to define schema. 739 more words

Business Intelligence

QlikSense + WFE Troubleshooting

If you are publishing the QlikSense EDW against the public internet, you may run into some strange problems. Here is a short list of configurations to check on the Internet server utilizing QlikSense for Web Ticketing, fetching Hypercubes etc. 178 more words

Dynamic Security – a look at the final product

Introduction

Recently I posted a blog titled “How to implement Analysis Services Dynamic Security based on Microsoft CRM user access rights”. That post talked about how to implement the back-end structure needed to put it in place but didn’t show the result of all that hard work. 215 more words

BI

How to implement Analysis Services Dynamic Security based on Microsoft CRM user access rights

Introduction

In Analysis Services implementations, there is always a demand for implementing security. In this post, I’ll describe a dynamic or attribute security solution in Analysis Services that I built at a customer based on Microsoft CRM Salesperson customer access rights. 901 more words

BI