Business Intelligence MySql case sensitive table names issue on Windows/Linux By Nikhilesh MySql case sensitive table names issue on Windows/Linux Moving a MySQL database from Windows to Linux .Many times we faced the problem that on Linux the names of the tables are case sensitive due to that we can't find...
Business Intelligence Introduction to SpagoBI By Nikhilesh Introduction to SpagoBI SpagoBI allows to produce reports using structured information views (lists,tables, crosstabs, graphs) and it allows the multidimensional analysis through OLAP engines, which are more flexible and user-friendly, compared to structured reports overall architecture is composed of five...
Business Intelligence CUBES By Nikhilesh Cubes The data structures used in the OLAP are multidimensional data cubes or OLAP cubes: An OLAP cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications. An OLAP cube is an array...
Databases Mongo DB Aggregation – Part I – Single Purpose Aggregation Operations By Shraddha Tambe Mongo DB Aggregation(Part 1) - Single Purpose Aggregation Operations MongoDB offers more than one ways of aggregating data stored in a collection. It has a flexible datamodel and gives us tools to write some pretty complex queries and derive results...
Business Intelligence About Analytical Databases By Shraddha Tambe About Analytical Databases Companies and Corporates that build Business Intelligence solutions for their business, often want to consolidate their data that is spread across various applications, for reporting and analysis purposes. For that, they build datawarehouses or data marts as...
Databases DDL and DML Operations in MongoDB By Sayali Mahale MongoDB is an open-source document database that provides high performance, high availability, and automatic scaling. Make data easy with Helical Insight. Helical Insight is world's best open source business intelligence tool. Claim Your 30 Days Free Trail A record in...
Business Intelligence Calling JRXML Inside Helical Insight By admin Calling JRXML inside HDI(Helical Dashboard Insights) : - This blog will teach you how to call JRXML inside HDI(Helical Dashboard Insights) : - To call JRXML inside Helical Dashboard Insights , we need 4...
Databases INNODB Backup and Recovery using mysqldump By Nikhilesh InnoDB is a storage engine for MySQL. MySQL 5.5 and later use it by default. It provides the standard ACID-compliant transaction features, along with foreign key support (Declarative Referential Integrity). It is included as standard in most binaries distributed by...
Business Intelligence Migrate Oracle with Pentaho By Nikhilesh Steps to migrate Oracle with Pentaho Step 1:- Run the script as DB admin. Script is available in location:- biserver-ce\data\oracle10g. Modify configuration file:- applicationContext-spring-security-hibernate.properties. Location:- pentaho-solutions\system\applicationContext-spring-security-hibernate.properties. original code:- jdbc.driver=org.hsqldb.jdbcDriver jdbc.url=jdbc:hsqldb: hsql:// localhost:9001/ hibernate jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.HSQLDialect Modified code:- dbc.driver=oracle.jdbc.OracleDriver jdbc.url=jdbc:oracle:thin:@localhost:1521/sysdba...
Business Intelligence Map Reduce In MongoDB By Nikhilesh MongoDb Map Reduce Map-reduce is a data processing paradigm for condensing large volumes of data into useful aggregated results. For map-reduce operations, MongoDB provides the map Reduce database command. The mapReduce command allows you to run map-reduce aggregation operations over a collection. The...
Business Intelligence Map Reduce in Mongo DB By admin Map Reduce in Mongo db : This Blog will teach you, how to write Map reduce in Mongo DB . Map Reduce is a concept that process large volume of data into aggregated results. To use Map Reduce Concept in...
Business Intelligence Welcome Page Customization For JasperSoft on the Basis of Roles By Sayali Mahale On Welcome page of Jaspersoft, Login is based on Some Roles assigned to particular user ,as per that we have an access on Jaspersoft. If anyone wants to create their own user with Roles, they simply do it by making...