Category: MS BI
Copying environment variables from one environment to another using SQL query
Inkey, October 7, 20221027 Views
As any developer, one always follows the cycle of deployment using different environments, i.e., DEV (for development phase or the underground lab) -> UAT (for testing phase or Racoon city) -> PROD (for real-time application or the world). In SSIS also, we are able to deploy the same SSIS package in 3 different environments, but […]
Read moreSSRS > Shared Dataset > Not detecting NEW fields > a simple fix
Inkey, April 20, 20207322 Views
For many reasons, we may feel the need of bringing additional fields to the SSRS dataset. A common issue faced when using SSRS shared datasets is when we change the backend query to bring additional fields for reporting, the dataset fails to recognize this change. Let us try to regenerate this issue to understand this […]
Read moreSSRS – How to handle multi tenants in single instance?
Inkey, June 11, 20193816 Views
Problem Statement: We have different SQL databases for different tenants(or clients), and we want the same SSRS report to fetch data from different databases based on the user who is executing the report. To achieve this, we can have a data source that is dynamic by using an expression-based connection string. Below is a quick explanation […]
Read moreFew Things About The Microsoft Business Intelligence Services
Vinay Pugalia, October 31, 20171645 Views
These days, we live in some hyper-connected world where information works as the key to success for both the businesses and individuals. But raw details contained in the data repository can actually make some clear sense and this is the place where the business Intelligence tools mainly come into the picture. Microsoft offers an entire […]
Read moreInkey’s ability pond
Admin, June 8, 20174679 Views
‘‘INKEY’s ability pond” is your one stop shop to learn more about the services offered at INKEY. Here, our authors discuss on some of the topics like Microsoft SQL Server, Microsoft Dynamics CRM, Microsoft Business Intelligence, Microsoft Power BI, Microsoft Office Add-ins, Mobile Development, and Custom Application Development.
Read more
