Community & Support Portal

Getting Started 6

• Posting tickets to Smarten support portal
• Registration on Smarten Support Portal
• Using Knowledge base on Smarten Support portal
• Raising a request for the License Key renewal from Smarten Support
• Download Smarten Evaluation Version

View all 6

Functional Domain 7

• Projected Margin % using Global variables & UDDC
• Delay in delivery performance
• Monthly run rate of various products
• Employee Attrition Rate for department
• Item Stock ageing period

View all 7

Log-in & Profile Management 1

• Unable to Change the Password

Managing Folders 0

Managing Objects 0

Working with Cross-Tabs 3

• E2082 - Fail to set outliner field
• Display filter value in the title
• Filters on measure

Working with Graphs 3

• Bubble graph using x-y scatter graph
• Auto generate graphs from Crosstab
• Plot the dynamic graph based on measure selected from the list of measures

Working with Tabular 1

• Serial number column in Tabular

Working with GeoMap 2

• Importing areas and their Lat / Long
• Workflow to create Default geomap

Working with KPI 0

Working with Dashboard 3

• Dashboard Creation Best Practices
• How to upload images in Smarten
• Improve dashboard loading performance for dashboards with multiple objects

Working with Delivery & Publishing Agent 0

Data Source Configuration & Management 3

• Creating cube using Stored Procedure Output
• Data Source URL String Having SQL Server Instance
• Connecting to IBM DB2/AS400 i-Series Database

Designing Cube 3

• Max # records for a cube
• Cube using Different DB servers
• Error when rebuilding cube with comments in the cube query

Cube Update / Refresh 0

Cache Cubes 0

Real-Time Cubes & Datasets 2

• Real time cubes with access & filters
• Avoid data filter issues due to numeric precision limit

MDX Cubes 0

Linked Cubes 0

Manage Cubes 1

• Time dimension unavailable when associating from Cache to Real-time cube

Formatting Values & Objects 0

Responsive UI Design 0

Export 1

• Exported file generated of 0 byte in linux

Supported Features for Different Cubes 0

Global Variables 0

Sort 0

Rank 0

Group & Ungroup 0

Spotlighter 1

• Multiple spotlighter formatting with same conditions

Data Value / Display Value Mapping 0

Custom Cube Columns 1

• Cube unavailable for custom cube column

Custom Dimension Value (UDHC) 0

Functions & Expressions 2

• 1) Summary on Crosstab with only one row and column dimension
• 2. Summary on Crosstab with multiple Row and Column dimensions

Data Operations 0

Summary Operations 1

• Group Average (Total value / Group count) in the summary

What-if Analysis 0

Filters & Expressions 0

Time Series (Absolute, Relative, Full Period, Period to Date, Range Time Series) 4

• Crosstabs inherit time series filters, when opened from dashboard
• Retrieving data of previous year's last month
• Configuration of timeseries year selection to display the year range in the timeseries filter
• Configuration of Timeseries Year Selection in Dashboard Filters

Retrieval Parameters 1

• Setting parameters before loading Crosstab

Forecasting 0

KPI Expressions 0

Graph Properties 0

Installation & Deployment 22

• Could not start http listener
• ElegantJ BI fail to deploy. Unable to connect
• Memory Heap Size Error in Wildfly Console
• ElegantJ BI deployment fail after moving zipped data folder
• X11 display error

View all 22

License Key 1

• Adding new license key / Updating an existing key

General Application Configuration 2

• Multilingual ElegantJ BI Interface
• Viewing multilingual data

Performance 1

• Jstack to debug high CPU utilization

Creating & Managing Admin Users 0

Managed Memory Configuration 1

• Enable Managed Memory In Objects

Email Configuration & Templates 2

• Configuring Gmail Account in ElegantJ BI
• Email Account (SMTP) with Two Factor authentication

Scheduler Management 2

• Active Publishing scheduler not working
• Reinitiate Missed Tasks for Dataset Rebuild and Delivery Publishing Tasks

Managing Security & Permissions 0

LDAP / AD 1

• AD Integration in Smarten

Logs Management 0

Backup 0

Others 17

• Sorting on a 12 month rolling report
• Powerful Impact & Sensitivity Analysis Features
• Absolute Time series filter - Financial & Calendar
• Opening HyperSQL DB terminal in linux
• Creating UDDC expressions

View all 17

TeamUp 2

• Configure TeamUp
• Archive TeamUp Data

SSDP 11

• Server Shared Directory Configuration
• Merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as per financial year
• Get day wise new addition of counts from the data with day wise closing balance count
• Manage Column in Existing Dataset
• Manage columns while creating dataset

View all 11

Auditlog Analytics 0

Application Server Performance 0

Performance and Tuning 1

• Managing IO Throughput for EFS on an Amazon EC2 Instance

Embedded / API Integration 2

• Handling CORS issues with API in Google Chrome
• API Call to rebuild cubes / datasets

Basics of JOINs 6

• INNER JOIN
• LEFT OUTER JOIN
• RIGHT JOIN
• FULL JOIN
• SELF JOIN

View all 6

Training Use Cases 14

• Get day wise new addition of counts from the data with day wise closing balance of counts
• Merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as per financial year?
• Apply rounding logic to Time data – e.g. 1:39 PM should be 2 PM and 1:20 PM should be 1 PM.
• Merge monthly plan data with actual daily sales data and create plan vs actual data
• Find out the frequency of repetition of dimension value combinations – e.g. frequency of combination of bread and butter from sales transactions

View all 14

Assisted Predictive Modelling Use cases 9

• Customer Churn model using Smarten Assisted Predictive Modelling
• Medical Cost Prediction Using Smarten Assisted Predictive Modelling
• Handling Outliers Using Smarten Assisted Predictive Modelling
• Machine Maintenance Using Smarten Assisted Predictive Modelling
• Sampling Data using Smarten Augmented Analytics

View all 9

Smarten Application Security 6

• Password patterns and configurations in Smarten
• Brute force vulnerabilities and solutions
• CSRF vulnerabilities and solutions
• Clickjacking vulnerabilities and solutions
• HTTP Method Vulnerability and solutions

View all 6

UDDC Expressions 6

• Making use of Case statements (IfCase, When-Then)
• Making use of Date functions
• Making use of Arithmetic functions
• Making use of Cell references
• Making use of Global variables

View all 6

Data warehousing 1

• Concepts of Slowly Changing Dimensions

Publishing Reports 1

• User list empty while publishing object