Development

Application security assessment

Unexpected MDX assumptions and error handling for subsets in TM1/Planning Analytics

I had a bug in a TM1 application recently that was very difficult to track down, and it was because I didn’t understand the different ways that TM1 might respond to vague or incorrect MDX expressions.  MDX makes some unexpected assumptions. Take the following simplified example cube: Let’s say that I have an active form […]

Microsoftteams Image (3)

Combining The Data In Denodo Platform.

Denodo: A  data virtualization platform Data virtualization is a core technology that enables modern data integration and data management solutions. Factors of data virtualization: Connect, introspect, and govern any data source with zero data replication: Quickly connect disparate structured and unstructured sources. Catalog your entire data ecosystem. Data stays in the sources and it is […]

Application security assessment

Analyzing TM1 logs and data from the command line using Find

The Find Command I come from a systems background in Windows and Linux, maintaining operations and writing programs in C.  Since I bring that perspective to my TM1 work, I’m more comfortable with command line tools than some of my other teammates, so I thought I would share some tips. As an example, let’s look […]

Coding On Laptop 1200x.progressive

How to create zip file which contains single text file with a fixed threshold in SSIS.

What is SSIS? SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. The SSIS ETL tool Extracts data from different sources and transforms that data according to user requirements. And then loads data into various destinations. […]

Istock 935964092

Implementation of XML Extract in SSIS

SQL Server Integration Service (SSIS) : SSIS is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading and transformation like cleaning, aggregating, merging data, etc. It makes it […]

Programmer Working In A Software Developing Company Office

Ready, Get Set, Go! on AEM…

AEM has a vast infrastructure, and it requires time to hold expertise on it. Every expert was once a beginner, so you are never too late to start and have fun on AEM. In this blog, we will focus on the developers’ perspective of AEM and how one can start as an AEM developer. We […]

snowflake time travel

EXPLORE TIME TRAVEL IN SNOWFLAKE

Have you ever wondered if it would ever be possible to time travel like in the old movies with a time machine? If we could go back in time and see the world, would we? If you asked me, I would have said yes! But not in the way that Hollywood portrays science fiction films. […]

Episerver forms resources javascript

In-Depth understanding of client side script on Model Driven App and Dynamics 365

In this Power Platform article, we’ll look at how to add client-side scripting to a Model Driven App. Read on to learn how to use a client-side script in Model-driven or Dynamics 365 Forms, as well as what methods and collections are available. I’ll attempt to answer as many questions as possible in order to […]

tiethnic colleagues sitting at desk looking at laptop computer in office. stock photo

How to Convert Blank Values to Null in Flat File Source in SSIS Package

SQL Server Integration Services(SSIS): SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading. In […]

Download

Handling ever changing source schema issues using Python and Snowflake

The problem statement: An organization having a lot of FMCG products, conducts campaigns in various cities across India. The main aim of this campaign is to promote the products and collect feedback from the customers both existing and prospective ones. The data is collected in excel files and loaded to a centralized location in the […]

Woman working with code and data

Drill Down Feature in Power BI

What is Drill Down in Power BI? In Power BI, Drill Down is nothing but the next level of hierarchical insights of the data. For example, when you want to see a year-wise sales summary, you may want to look into the “Monthly” summary, “Quarterly Summary,” and day-wise summary. So, this is where the drill-down […]

Person working at a whiteboard

Optimizely CMS 12 – Dependency Injection(DI) – StructureMap vs ASP.Net Core

If you are upgrading to Optimizely CMS 12, one of the breaking changes to consider is the change to the Dependency Injection(DI) framework. Earlier versions of Optimizely CMS had their own DI hosting framework that supported other concrete DI implementations, like StructureMap. With CMS 12 and ASP.Net Core, DI framework is built into the system. […]

Load More