SSDP

Server Shared Directory Configuration
Issue/Query : How to configure Server shared memory. Solution : Using the shared server directory option, if you have a file on any shared folder on the...
Wed, 17 Jun, 2020 at 11:00 AM
SSDP: 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...
Thu, 6 Aug, 2020 at 2:11 PM
SSDP: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...
Thu, 30 Jul, 2020 at 1:33 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 tex...
Mon, 31 Aug, 2020 at 11:26 AM
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...
Thu, 17 Sep, 2020 at 1:40 PM