SSDP

Server Shared Directory Configuration
Issue/Query : How to configure Shared folder on server. Solution : Using the shared server directory option, if you have a file on any shared folder on ...
Mon, 12 Oct, 2020 at 8:51 PM
Merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as per financial year
Scenario: Projection – Plan sales data is in Calendar year, monthly data. Actual sales data is in financial year, monthly data. Requirement: Merge ac...
Mon, 12 Oct, 2020 at 8:50 PM
Get day wise new addition of counts from the data with day wise closing balance count
Scenario: Data contains day wise cumulative (closing balance) corona cases for all the states. Requirement: Get day-wise new corona cases from the cum...
Mon, 12 Oct, 2020 at 8:51 PM
Manage Column in Existing Dataset
After creating the dataset If you want to use only few columns then we can select the necessary columns as given below: Open the dataset. Then yo...
Wed, 22 Jul, 2020 at 12:41 PM
Manage columns while creating dataset
We need to follow the below steps for the same.   To select the required columns,follow the steps listed below: Create New dataset from any dat...
Wed, 22 Jul, 2020 at 12:56 PM
Convert timestamp based text formats to Timestamp
Convert a Timestamp like '20190301175527', which is shown as a text column in the dataset to Timestamp Solution: The timestamp based texts...
Mon, 12 Oct, 2020 at 8:51 PM
Apply rounding logic to Time data
Scenario: We have flight data that has Flight Time upto Minute level. We also have weather data that has hourly weather parameters. Requirement: We ne...
Thu, 23 Jul, 2020 at 9:38 PM
Create dataset/cube using stored procedures in RDBMS
Solution:   Steps: 1. From the Top right menu, select New -> Dataset 2. Provide dataset Name, description and Select Datasource from which you want t...
Thu, 20 Aug, 2020 at 5:33 PM
Improving performance for fetching data from the database
By default, the resultset fetch size parameter in Smarten is set as 0. So it will fetch all the records in one resultset from the database. In such cases, t...
Tue, 3 Nov, 2020 at 8:56 PM
Improve data extraction performance from database data source
In order to achieve better processing time, the thread size should be managed.    Threads are objects within a process that run instructions. Threads allo...
Wed, 3 Feb, 2021 at 3:24 PM