Deduction of analytic context based on text and semantic layer

A non-transitory computer-readable medium having stored thereon program code, the program code executable by a computer to perform a process comprising:

• receiving text;
• extracting a plurality of linguistic entities and associated linguistic entity categories based on the text;
• determining one or more semantic objects of a semantic layer based on the linguistic entity categories, wherein each of the one or more semantic objects of the semantic layer associates one or more physical entities stored in a data source with user-friendly names;
• determining an analysis context based on the text, the linguistic entities, and the associated linguistic entity categories;
• after determination of the analysis context and the one or more semantic objects, generating a query of the semantic layer based on the analysis context and the one or more semantic objects, wherein the generating the query of the semantic layer comprises:
• determining, based on the linguistic entity categories that were extracted, whether the one or more semantic objects are to be filtered, and in response to determining to filter the one or more semantic objects, determining how to filter the semantic objects,
• wherein when a value from a first linguistic entity category matches a value for one of the one or more semantic objects, using the value from the first linguistic entity category as a query filter, and when only a single entity is mentioned for the first linguistic entity category, including the entity in the query filter and removing the first linguistic entity category from a result of the query of the semantic layer;
• and
• receiving a structured data result in response to the query of the semantic layer.

A system comprising:

• a semantic layer including a plurality of semantic objects;
• a computer comprising:
• a linguistic processor to:
• receive text;
• and
• extract a plurality of linguistic entities and associated linguistic entity categories based on the text;
• and a query builder to:
• determine one or more semantic objects of the semantic layer based on the linguistic entity categories, wherein each of the one or more semantic objects of the semantic layer associates one or more physical entities stored in a data source with user-friendly names;
• determine an analysis context based on the text, the linguistic entities, and the associated linguistic entity categories;
• after determination of the analysis context and the one or more semantic objects, generate a query of the semantic layer based on the analysis context and the one or more semantic objects, wherein the generate a query of the semantic layer based on the analysis context and the one or more semantic objects comprises:
• determine, based on the linguistic entity categories that were extracted, whether the one or more semantic objects are to be filtered, and in response to determining to filter the one or more semantic objects, determining how to filter the semantic objects,
• wherein when a value from a first linguistic entity category matches a value for one of the one or more semantic objects, using the value from the first linguistic entity category as a query filter, and when only a single entity is mentioned for the first linguistic entity category, including the entity in the query filter and removing the first linguistic entity category from a result of the query of the semantic layer;
• and
• receive a structured data result in response to the query of the semantic layer.

A method comprising:

• receiving text;
• extracting a plurality of linguistic entities and associated linguistic entity categories based on the text;
• determining one or more semantic objects of a semantic layer based on the linguistic entity categories;
• dividing the received text into a plurality of clauses;
• determining an analysis context for a first one of the plurality of clauses based on the text, the linguistic entities, and the associated linguistic entity categories;
• generating a query of the semantic layer based on the analysis context and the one or more semantic objects, wherein the generating the query of the semantic layer comprises determining, by the system, based on the linguistic entity categories that were extracted, whether the one or more semantic objects are to be filtered, and in response to determining to filter the one or more semantic objects, determining how to filter the semantic objects, wherein when a value from a first linguistic entity category matches a value for one of the one or more semantic objects, using the value from the first linguistic entity category as a query filter, and when only a single entity is mentioned for the first linguistic entity category, including the entity in the query filter and removing the first linguistic entity category from a result of the query of the semantic layer, and receiving a structured data result in response to the query of the semantic layer;
• and
• receiving a row-set in response to the query of the semantic layer;
• wherein the linguistic entity categories include a subject type category, an analysis type category and a dimension type category;
• wherein the determining an analysis context based on the text, the linguistic entities, and the associated linguistic entity categories comprises:
• determining an analysis context for a first one of the plurality of clauses, the analysis context for the first one of the plurality of clauses including the subject type category, the analysis type category and the dimension type category, wherein the subject type category included in the analysis context for the first one of the plurality of clauses specifies a subject of an analysis, said subject of the analysis being a numerical indicator of value, wherein the analysis type category included in the analysis context for the first one of the plurality of clauses is different than the subject type category and represents an intent of the analysis, wherein the dimension type category included in the analysis context for the first one of the plurality of clauses is different than both the subject type category and the analysis type category and represents an axis of the analysis, wherein values of a quantity are to be disposed along the axis of the analysis;
• wherein the analysis type category included in the analysis context for the first one of the plurality of clauses has a name;
• and
• wherein the method further comprises:
• using the name of the analysis type category in the analysis context for the first one of the plurality of clauses as a parameter for a rule-based determination of a type of chart most suited to present the row-set that is received in response to the query that is generated based on the analysis context that includes the analysis type category.

A method comprising:

• receiving text in a system that includes a processor;
• generating, by the system, a query of a semantic layer in response to the receiving the text;
• and
• receiving, by the system, structured data in response to the query of the semantic layer;
• wherein the generating, by the system, a query of the semantic layer comprises:
• after receiving the text, extracting, by the system, a plurality of linguistic entities and associated linguistic entity categories based on the text;
• determining, by the system, one or more semantic objects of the semantic layer based on the linguistic entity categories;
• determining, by the system, an analysis context based on the text, the linguistic entities, and the associated linguistic entity categories;
• and
• after determination of the analysis context and the one or more semantic objects by the system, generating, by the system, the query of the semantic layer based on the analysis context determined by the system and the one or more semantic objects determined by the system, wherein the generating the query of the semantic layer comprises:
• determining, by the system, based on the linguistic entity categories that were extracted, whether the one or more semantic objects are to be filtered, and in response to determining to filter the one or more semantic objects, determining how to filter the semantic objects,
• wherein when a value from a first linguistic entity category matches a value for one of the one or more semantic objects, using the value from the first linguistic entity category as a query filter, and when only a single entity is mentioned for the first linguistic entity category, including the entity in the query filter and removing the first linguistic entity category from a result of the query of the semantic layer;
• and
• receiving a structured data result in response to the query of the semantic layer.