jaspersoft bi

Original: "BI Project Notes" Analysis on the change of the mean value of sensory assessment in the past years the establishment of cubeAnalysis topicsMain dimensions:Tobacco leaf grade, tobacco leaf grade by grade information, tobacco leaf grade according to grading standard (standard dimension)Place of origin (parent-child dimension)Detection time (Time dimension, to Tqc_raw_smokingtest. Checktime field derived checkdate field)Dimension of sampleMain

Original: BI project note failed to decrypt protected XML node "Dts:password" workaroundDescription: Unable to decrypt the protected XML node "Dts:password", error 0x8009000b "This item is not suitable for use in a specified state. ”。 You may not have permission to access this information. This error occurs when there is a cryptographic error. Make sure that you provide the correct key.Workaround:1. In Integration Services, locate the package to execu

Source: "Bi thing" data stream transformation--perspectiveThis is the same as the pivot in T-SQL and the Unpivot function. A pivot transformation can make a data specification or makes it more readable in a report.Through the input data of the pivot column values, the perspective transformation transforms the canonical dataset into a slightly less canonical, but more concise version. For example, in an Orders dataset with a specification of customer n

Source: "Bi thing" data stream conversion--word Lookup transformationThe term Lookup transformation matches the words extracted from the text of the converted input column to the words in the reference table, and then calculates the number of occurrences of the word in the lookup table in the input dataset and writes the count to the column in the transformation output with the word in the reference table. This conversion is useful for creating a cust

Source: "Bi thing" data stream conversion--aggregationThe aggregation transformation can perform aggregation operations on the data like the function group by, Average, Minimum, Maximum, and Count in T-SQL. In the figure, you can see that the data is grouped in SampleID, and the Totalsugar does average, Maximum, Minimum, and count operations. This results in 4 columns of new data for other operations.In the Aggregation Operations Editor Aggregate Tran

In the original: BI Project notes report information Analysis cubeData Source settings:Data processing logic:--handling lost foreign key relationship dataSELECT * fromT_reportleafgradeWHEREFsubfid not inch(SELECTFID fromt_raceleafreport)DELETE fromT_reportleafgradeWHEREFsubfid not inch(SELECTFID fromt_raceleafreport)--dealing with supplier relationshipsSELECT * fromT_raceleafreportWHEREV_customer not inch(SELECTC_custcode fromt_providerinfo)--Chan

Original: BI project note creation Time dimension (2)To create a step: Serial number Selected properties Renamed name Property category 1 DateKey DateKey Conventional 2 Month Key Month Key Month 3 中文版 Month Name 中文版 Month Name One month of the year 4 Month Number of year Month Number of year Conventional

The original: "Bi thing-the art of data" understanding Dimension Data Warehouse-fact table, dimension table, aggregation tableFact tableIn a multidimensional data warehouse, a table that holds a detailed value or fact for a measure is called a fact table. A fact table that stores sales and sales by state, product, and month has 5 columns that are conceptually similar to the following example. Sate Product Mouth Units

This series is used to document the experience of using SSAS and Excel for data analysis in the work, in the Days of Goodness (SSAS Excel BI Tips), which is now intended to share small skills in the form of blogs, which is not enough to be explained as a separate course, but a lot of BA, Bu unfamiliar but very useful skills, dedicated to the needs of friends.This article is about the what-if hypothesis analysis of Excel, and the what-if writeback of

trends, the business anomalies to make a rapid and accurate response.Third, Insufficient data collection:Many information systems even product attribute characteristics can not be collected into the storage, resulting in the corresponding analysis of consumption tendency.The POWER-BI can help the retail chain industry achieve:1, according to channel and regional combination of best sales and best profit products, adjust the best shelf products;2, acc

partial caching Note that the size allocation of the buffer is as large as possible, 25MB in size. Reasonable use does not match the buffer, when the mismatch degree is high, the ratio of mismatched buffers is increased. No cache is not cachedNo cache mode, each match query will go to the database to check once. In this cache mode, the amount of data is small and the memory is very tight, it will be used, of course, its memory consumption is relatively minimal, but the lowest

About Silverlight for Bi This project mainly talk about the method to implement Bi using Silverlight.Now that I can find the way to render KPI and cube, It is not a control Or something, because of Silverlight, it is just tell a way to implement. How to use:About Silverlight for KPI please check author's blog.For Silverlight for cube, edit web. config which the WebService is hosted in, edit the connec

Business Intelligence is a complete solution that combines data warehouses, Online Analytical Processing (OLAP), and data mining into commercial activities to collect data from different data sources, after extraction (extract), transformation (Transform), and load, it is sent to the data warehouse or data mart, then, appropriate query and analysis tools, data mining tools, and on-line analysis and processing tools are used to process information, transform information into decision-making knowl

Document directory Conflict 1: Business Department's understanding of data and data department's understanding of requirements Conflict 2: constantly changing business needs and complex processes for generating data Conflict 3: Efficiency of real-time data query and processing and Modeling of massive data Due to recent work changes, I have been busy with a lot of things, work handover, resignation procedures, and new work ideas. At present, I am still at this stage, so there may not be an

is the temporary storage area of interface data. It prepares for the next step of data processing. Generally, the data on the ODS layer is homogeneous with that on the source system. The main purpose is to simplify subsequent data processing. In terms of data granularity, the data granularity of the ODS layer is the finest. Tables on the ODS layer generally have two types: one for storing the data to be loaded and the other for storing the processed historical data. Historical data must be clea

Brief Introduction to open-source BI systems Data Warehouse Technology Business Intelligence (BI) Basic Java knowledge This unified intelligent process system consists of three parts: To

and multiple subscribers. The publisher must first identify the source table required to capture the changed data. It then captures the changed data and saves it to the specially created change table. It also enables the subscriber to control access to changed data. The subscriber needs to know what changes he is interested in. A subscriber may not be interested in all the data published by the publisher. The subscriber needs to create a subscriber view to access the changed data authorized by

been released, it has actually been widely used in smart mobile devices, and most of the technology has been supported by the latest versions of browsers. "HTML5 Mobile development is learned to use" each analysis of the HTML5 standard contains the latest technology, the book is divided into 11 chapters, in detail the HTML5 new standard provides a variety of APIs, accompanied by relevant application examples, to facilitate the reader directly grasp the use of these APIs, And most of them can be

In the original: "Bi thing" Microsoft decision Tree algorithm--Find out the characteristics of the Three Kingdoms of the distribution, dedicated to the broad three enthusiastsAccording to the data of the Kingdoms 11, this paper uses decision tree analysis to find out the distribution of the three generals ' characteristics. Variables include command, force, intelligence, politics, charisma, identity.Variable Description:Command: The defensive force of

In the original: "Bi thing" Microsoft linear regression algorithmThe Microsoft Linear Regression algorithm is a variant of the Microsoft Decision tree algorithm that helps you calculate the linear relationship between dependent and independent variables and then use that relationship for prediction.The representation represented by the relationship is the formula that best represents the line of the data series. For example, the lines in the following