The current aggregation appear as a part of the measures name in the view. The . Supported functions. However I only managed to make it work for abap cds queries (@Analytics. For example, the calculation: IF [Row ID] = 1 THEN SUM( [Sales] ) END could become: SUM(IF [Row ID] = 1 THEN [Sales] END ) Option 4 (Use Level of Detail to De-aggregate a Field) Use a Level of Detail (LOD) Expression to make an aggregation non-aggregate. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Aggregation expressions: The values of multiple rows are grouped together to form a single value based on a mathematical function. I created a machine learning job which uses two metrics as detectors defined as aggregations of fields in my index and everything was working great (Job_0, Datafeed_0 code below). "cannot blend the secondary data source because one or more fields use an unsupported aggregation" Attached is the workbook that could provide more clarity on my question. We are blending two data sources. Unsupported aggregation: The following aggregations cannot be inverted: Some aggregation types do not support data entry. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. Unsupported Aggregation while implementing filters from secondary datasource. For this reason, I applied a work-around, in which I add an aggration around the nested-field aggregation, as shown in the code below:HI Prakhar, It may happen because of actually n/w went down or deadlock in query execution or connection time exhausted . Note: The backup only stores the vDS configuration from the vCenter Server perspective. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. There are non-additive aggregates from a multi-connection data source with an active connection Temporary tables are not supported by multi-connection data sources that use active connections. Loading. 3 and I have created aggregates AGG for fields from data extract and excel file. . Golang aggregation group by multiple values with MongoDB. It’s common to store strings in documents such as first name, last name, or location. It looks like these solutions are coming from 2013. The (0,0) value indicates that the mongod should generate the Timestamp. Exception aggregation behavior. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. Stores pre-aggregated numeric values for metric aggregations. Hi Justin, Thanks for your quick reply. I receive this error: "Cannot blend the data source because one or more fields uses an unsupported aggregation". I keep getting an Unsupported Aggregation error for anything but "terms". An Aggregation represents a MongoDB aggregate operation and holds the description of the aggregation pipeline instructions. ” Causes and Workarounds for a Blending Limitation Errors 1. Atlas Build on a developer data platform Database Deploy a multi-cloud database Search Deliver engaging search experiences Vector Search (Preview) Design intelligent apps with GenAI Stream Processing (Preview) Unify data in motion and data at restunsupported aggregation from blended data problem. 1. This aggregation is unsupported: Second . Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and RAWSQLAGG. Drill down to the leaf level to enter data. Consider a books collection with the following document: {"_id": 1, title. NoDays >> * <<root. I'm using a cube data source as my primary and am attempting to blend with an Excel sheet. IN/EXISTS predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE/MERGE/DELETE commands<treeNode>. Jim. The current aggregation appears as part of the measure's name in the view. I couldn’t get anything to work. When I try to add COUNTD([DistrictId]) from my primary to text table. image 959×146 4. The way in which the individual activity scores are summed or averaged to give the overall score is called the aggregation. Hi everyone, I'm trying to blend two data sources on a single field, say 'Program Description'. Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. I did that in your example too. twbx. Drill down to the leaf level to enter data. When trying to use COUNTD() it gives this error: cannot blend secondary data source because one or more fields use an unsupported aggregation when hovering over the Measures because it is now red. Hi. Cut out the three explanatory lines at the top (can be done with regex) Run a regex replace on the file (I’ve used . The Queryable Encryption Public Preview, released in version 6. I'm sorry, I can't answer queries using measures with an unsupported aggregation type. Depending on the type of data item, applies. hello. The InfoProvider contains the records shown below in the inbound queue table. The aggregation rule is determined automatically at run time. Ask Question Asked 3 years, 2 months ago. AnalysisException: Correlated scalar subquery 'scalarsubquery (adr. S. NET/C# Driver automatically translates LINQ queries into aggregation operations. Applications using explicit encryption may use this page as guidance for issuing read and write operations against encrypted fields. CSS Error> Cannot blend the secondary data source because one or more fields use an unsupported aggregation . with blends, we are only able to support aggregates (like SUM, MIN, MAX. LINQ allows you to construct queries against strongly typed collections of objects by using language keywords and operators. 9 KB. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Bucket aggregations that group documents into buckets, also called bins, based on field values, ranges, or other criteria. My goal is to create a MONTHLY count of applications by ACADEMIC YEAR, SCHOOL CODE, and GRADE. Use of meta-aggregation to synthesize the findings from qualitative studies offers an especially useful approach as its goal is to aggregate information on a topic to provide practical recommendations for practice, future research, and. Exception aggregation on a formula member: No data entry possible because an exception aggregation has been set on a formula member. " Environment Tableau Desktop Cube Blend Resolution Verify if one of the measures coming from the cube data source has a default aggregation different than SUM, MIN, MAX, COUNT. elasticsearch. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . Hevo offers a fully managed. FIXED requires that you have row-level access to the rows in the secondary source. java. The measure is using one of the Defined in expression aggregation types, and the expression for the measure contains what looks like a hard-coded aggregate function. 9 version and publish them as new (remove previous. All the three main measures were exposed in the bottom of the query but there is an extra metric based on an average aggregation behavior, the query formula will use the weight of luggage as measure and apply the aggregation to calculate the average during the run-time. 0: Thu Sep 29 20:13:46 PDT 2022; root:xnu-8020. id = totals1. Databricks matches expressions on best effort : For example it will recognize: SELECT c1 + 5 FROM T GROUP BY 5 + c1 as mathing expressions. @V1NAY8 For some scripts we probably can't aggregate (like you've found with text). Unsupported aggregation: The following aggregations cannot be inverted: Some aggregation types do not support data entry. See Array Indexes are Unsupported. Learn more about Teams The manual process is: Read the data into a text editor. Multiple instances of same dimension. C. Try loading pyspark functions with an alias instead:. Norbert, I'm baffled. Q&A for work. non-currency measure. Some of my table calculation are the follow: RED FIELD Tableau Name of First Math Course= IF [Tableau Period of First Math Course]== [Academic Period] AND ( [Subject Desc]=='Mathematics' OR [Subject Desc]=='Mathematics. This document lists the unsupported command in Cisco ASR 1000. This aggregation provides a way to stream all buckets of a specific aggregation, similar to what scroll does for documents. Most used methods <init> Popular in Java. The Dept Target field is producing an integer (A). Supported Update Operators. When you add a measure to the view, Tableau automatically aggregates its values. select t. Drill down to the leaf level to enter data. Optional: To change the match for a column, click the name of the column and select a different column. Some aggregation and exception aggregation types do not support data entry. really need to see your twbx file to be of further help. For example,. currently this doing everything over the global total and count distinct of IDs. Amazon's S3 Select allows a user to write SQL against S3 objects, but there's insufficient documentation around what standard SQL functionality is supported. I've tried that in the past, and I was always blocked by the unsupported aggregation message. ) AS t . Modified 3 years, 2 months ago. g. 6. I figured out why the exception aggregation is not pushed down to HANA. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. It shows the next message: "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". The number is a factor by which the grade value will be multiplied before it is added to the sum of all grades, but the item itself will not be. Hevo is a No-code Data Pipeline. clients. unsupported aggregation" | Tableau Software. The measure is using one of the Defined in expression aggregation types, and the expression for the measure contains what looks like a hard-coded aggregate function. 0, is no longer supported. The . When projecting or adding/resetting a field within an embedded document, you can either use dot notation, as in. Drill down to the leaf level to enter data. Time-interval with identical time points. We use three kinds of cookies on our websites: required, functional, and advertising. 4. See Join Your Data for more information. Upvote Upvoted Remove Upvote Reply 1 upvote. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. Supported Aggregation Pipeline Operators Atlas Data Federation supports all the aggregation pipeline operators. MongoDB Aggregation pipeline problems. unsupported alert type – all alert type names are in camelCase – check spelling and capitalization for all alert parameters; unsupported aggregation parameters – see the You can have other aggregation on a parallel level of top_hit but you cannot have any sub_aggregation below top_hit. These operators are useful for extracting exactly what you need from a date in order to process the data in your application. "While considering transforms, it complains "Unsupported aggregation type [date_histogram]" Please any suggestion? Thanks in advance. I am developing some queries and indexing against a MongoDB 4. average. Can anyone tell me how I might get the aggregation of the secondary data source irrespective of the filters placed on the linked fields? Expand Post. really need to see your twbx file to be of further help. _types. . When you try to do that, Tableau generates the "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" error, turns the offending pill red, and grays out the view. 2. An aggregation pipeline is a series of stages that are used to transform a document. Upvote Upvoted Remove Upvote Reply. As an alternative I've tried to use Exception. Some of my table calculation are the follow: RED FIELD Tableau Name of First Math Course= IF [Tableau Period of First Math Course]== [Academic Period] AND ( [Subject Desc]=='Mathematics' OR [Subject. I tried a few workarounds but nothing has helped. In the primary data source I have some calculations that work off of group membership too--some true false that feed into the measures via INT function for a Max aggregation. Unsupported Aggregation means that the action requested at one of the sources or the act of bringing them together can not be done - in your case you have used a table calculation to determine a performance score - Table calculations are performed on the underlying table for a specific worksheet and can not be carried or transferred from one sheet to another Add a comment. Currently windowed aggregations cannot be combined in the same SELECT statement with GROUP BY, HAVING, or any. Usually in this case it is recommended to upgrade the document to a newer version. Glad that worked out for you Puneeth. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . cast. sql) A class which can consume and produce dates in SQL Date format. Step 1: Adding Tableau Aggregation Measures. Unsupported aggregation in secondary data source using an LOD expression. ) If only one of the tables requires row level information, consider making that the primary data source in the blend (I. i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. I'm trying to create a frequency distribution as a percent of total for individual products in a single category on one chart, then dual axis a second chart with the frequency distribution of the category for comparison purposes. String. The version I am working with 10. What I'd really like to do though is define. hello. Aggregation operators and stages. There is not an specific reason. Hi everyone, my first attempt to blend 2 data sets was not successful (Sheet called 1st attempt - attached), because its appears the following message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". Jun 1, 2021 at 9:05. Upgrade: open it with the 2020. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. You can use aggregations in the analysis level calculated field. The composite buckets are built from the combinations of the values extracted/created for each document and each combination is considered as a composite bucket. However I keep getting the following error: co. ) I need to revisit my understanding of the limitations here! unsupported csv filters – spendChange alerts accept filter as comma-separated values; other alert types do not. IF user chooses month X and parameters/filters like gender/age/etc, THEN count all distinct users from data set #2 where the date of data set #2 is from 2017-08-01 through today's date. elasticsearch. register ( "myUU", functions. NET/C# Driver automatically translates LINQ queries into aggregation operations. CSS ErrorNon-aggregate measures do not perform any aggregation and thus will not perform a double or nested aggregation. unsupported_in_exists_subquery IN/EXISTS predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE/MERGE/DELETE commands`<treeNode>`. Learn more about TeamsIn the Add Dataset dialog, select a dataset and click Add to Workbook. Steps to Implement Tableau Aggregation. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. Unsupported aggregate subquery with non-equality correlated predicates Ask Question Asked 3 years, 2 months ago Modified 3 years, 2 months ago Viewed 533. This aggregation is unsupported: Median . Tommy Sims (Member) 7 years ago. Unsupported aggregation With the release of the MongoDB Analyzer for . There are situations like this where I’ve gone back to the data source to build out SQL views that did pre-aggregation, used Alteryx to join in additional information so I didn’t need a data blend, etc. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. You signed out in another tab or window. Hi Judy, Could you try 'swapping' the datasources, so the one with the [Customer_Code] would become your Primary? You could do it just for one view,cannot blend secondary data source because one or more fields use an unsupported aggregation beacuse of LOD. udaf (MyTypedUDAF) ) and call it for aggregate over your window. For example, Sales becomes SUM (Sales). For more information on exception aggregations, refer to Disaggregation of Values During Data Entry. Try to use this calculation:. Canonical function. If you have selected the modeling properties Activate Data and All Characteristics are Key, Reporting on Union of Inbound and Active Table, you can choose from the following aggregation types: Summation, Maximum and Minimum. Cisco ASR 1000 Series Aggregation Services Routers Software Configuration Guide, Cisco IOS XE 17. Learn more about TeamsThe aggregation rule is determined automatically at run time. Reload to refresh your session. Returns true if the second parameter string value is a substring of the first parameter string value, otherwise it returns false. Show more. That will avoid duplicated records resulting from the join. When you try to do that, Tableau generates the "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" error, turns the offending pill red, and grays out the view. After blending, CountD works fine on primary datasource, but when I try to use CountD on secondary datasource tableau gives error: "Cannot blend secondary data source as one or more fields use an unsupported aggregation"Possible Reason How to resolve this issue; There's a dimension combination rule that defines this data cell as an invalid member combination for data entry. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. You need to show same values as long as you choose districts within a same area. It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. Move the aggregation so the calculation is aggregated. How should I got about with this? Thank you. This aggregation is unsupported: Median . movieIdResolution. Wherever possible, the value of calculated is used, then sum. With the release of the MongoDB Analyzer for . The number is a factor by which the grade value will be multiplied before it is added to the sum of all grades, but the item itself will not be. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Ken Flerlage (Member) 5 years ago. bucket. 2. This aggregation is unsupported: Month . Issue. Cannot blend the secondary data source because one or more fields use an unsupported aggregation issue. column1 = a. However if I try to filter those fields, I seem to lose the ability. I did that in your example too. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being. Please check the aggregation types of the fields in this formula. If you need to use an unsupported operation in an aggregation, you must define the entire expression using the BSON Document type. ElasticsearchException: [es/search] failed: [x_content_parse_exception] [1:44] [composite] unknown field [name] Here is my setup. If I have 1 record in EKKO, 5 line items in EKPO, and 20 Scheduled lines in EKET, the resulting output will contain 20 lines. Windowed aggregations partition the results from a SQL query into groups in order to perform calculations across adjacent rows of the query result. However, unsupported Ni NPs still suffer from different drawbacks such as deactivation by aggregation, low durability, low dispersibility, and electron and hole recombination. I have 2 filters (BU ISNull and CORPID) applied from secondary data source. If. with blends, we are only able to support aggregates (like SUM, MIN, MAX. Upgrade: open it with the 2020. Upvote Upvoted Remove Upvote Reply. It supports pre-built data integrations from 100+ data sources. Group by with no aggregation expression is not supported. A COUNTD calculation gives the answer as 5 since the sales for account B came through two separate units. and no matter how I try to structure it - even doing all the calculations out in one field - I get a perfectly valid object that cannot be dragged into a sheet that has ANYthing else in it, citing 'Unsupported Aggregation' and turning red. In your config in the screenshot you specify date_histogram twice, however the definition is group_by is all you need. I'm creating a calculation view in HANA, where I'm joining the PO tables, EKKO (Header), EKPO (Item) and EKET (Scheduled Lines). For example, you would not be able to use a measure with the expression <<root. The only tables allowed to use in a FROM. Cannot Blend Secondary Data Source - Unsupported Aggregation. WHERE accounts. movie_actors` b ON a. [OIL DATE]) THEN MIN ( [KMs]) END. The first part is the source data. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. I thought the problems with Median and CountD being unsupported by DB2 blending were over as of version 9 (i am using. In the Name field, enter OldPasswordAllowedPeriod, and then press the Enter key. The new string aggregation operators that were added to. But when I try pulling it on to "Marks", it shows "Can't blend secondary data source because one or more use an unsupported aggregation". Add it to group by using ordinal position or wrap it in first () (or first_value) if you don't care which value you get. Aggregate functions in S3 Select. But a filter or range gives org. I've tried that in the past, and I was always blocked by the unsupported aggregation message. Cut out the three explanatory lines at the top (can be done with regex) Run a regex replace on the file (I’ve used . Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). Here's how I was able to solve it:This page documents the specific commands, query operators, update operators, aggregation stages, and aggregation expressions supported by MongoDB version 6. The following query. Hi. Unsupported aggregation: The following aggregations cannot be inverted: <aggregations>When trying to use COUNTD() it gives this error: cannot blend secondary data source because one or more fields use an unsupported aggregation when hovering over the Measures because it is now red. Hi ZZ-- If I understand what you've done here, you've linked the most recent Mortality Ratios (2015) with the most recent Births Attended by Health Professional measure-- the year of which may vary. calculated. Since the mongod cannot generate encrypted fields, the resulting timestamp would be. (Ditto the FIXED countD. I am trying to show an empty column on the X axis even when the aggregation value (the row) is 0. e. A few types of correlated subqueries follow patterns that Amazon Redshift can't decorrelate and doesn't support. An old, now unsupported aggregation strategy provided here only for backward compatibility with old activities. Provide details and share your research!The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. 0 using the C# MongoDB. For example, Sales becomes SUM (Sales). Connect and share knowledge within a single location that is structured and easy to search. Unsupported aggregation function in Materialized view: string_agg. value_count on one of the group by fields. It is not possible to combine the secondary data source because one or more fields use an unsupported aggregate. Painless script error "Unsupported script value" - Kibana - Discuss the. NET, we hope to speed up your development cycle and increase your productivity in three ways: 1) by making it easier for you to see how your idiomatic queries map to the MongoDB Query API, 2) by helping you spot unsupported expressions and invalid queries faster (at compile time, baby), and 3) by. I believe I first learned. I'm using lookup to join two collections, the foreign key is a string value located in request_by array and the other one is ObjectIdaggregation. Local variables declared inside curly braces are allowed. Atlas Build on a developer data platform Database Deploy a multi-cloud database Search Deliver engaging search experiences Vector Search (Preview) Design intelligent apps with GenAI Stream Processing (Preview) Unify data in motion and data at restPossible Reason How to resolve this issue; There's a dimension combination rule that defines this data cell as an invalid member combination for data entry. Additional summary functions are available in the expression editor. Jonathan. Sorted by: 2. movieId GROUP BY a. NET dialect) to turn each line into 31 documents. These 49 findings and ratings are provided in Supplemental. Aggregation greatly improves query performance by bringing the computation to a local level where patterns can be extracted faster and more efficiently. In effect, the correlated subquery is run after the aggregation, so it can only use columns and. If you have selected the modeling properties Activate Data and Write Change Log, you can choose from the following. We should add test cases for the scripted fields we currently support to make sure we maintain support. If you change Calculation1 to the following, it will no longer act as an aggregate: {FIXED : MAX (MONTH ( [DATE_CREATED]))}hi @Ambreen Firdous (Member) . Official drivers compatible with MongoDB version 6. ”Unsupported aggregation type. Good day Kapil. 0. 5. ver <> 0 ) The key is that the correlation clause is using a. Node embedding. Support for Redis Geo commands. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. This aggregation is unsupported: Minute . This aggregation is unsupported: Quarter . Rather than return incorrect results, Tableau turns the pill red, greys out the view, and generates the unsupported aggregation message. Aggregation is not supported for this object. The requests in the InfoProvider have not been activated yet. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. . Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. 1. Please refer to the above link for usage and configuration details. This is the correlated subquery: (Select top 1 Column c From table A a_s Where a_s. Norbert, I'm baffled. As described by Moodle HQ, this method is "An old, now unsupported, aggregation strategy provided here only for backward compatibility with old activities. LOD expressions are taken from a secondary source “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. using select to. unknown. We don't get row-level data from secondary sources on a blend. 12. Sep 26, 2014 at 15:16. Hi All! I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary) BI Cube Data 1 pc. Since the mongod cannot generate encrypted fields, the resulting timestamp would be. Unsupported Operations. In Elasticsearch, an aggregation is a collection or the gathering of related things together. 0, is no longer supported. Hi everyone, I'm trying to blend two data sources on a single field, say 'Program Description'. CSS ErrorAn old, now unsupported, aggregation strategy provided here only for backward compatibility with old activities. Aggregation is not supported for this object. Pipeline aggregations do not fit with the paging logic we. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Every measure has a default aggregation which is. I am trying to use the below formula instead of countd function because my data comes from Impala. This is because Calculation1 is an aggregate but the rest of the fields you're using are not aggregates. 96 MB) View with Adobe Reader on a variety of devices. Hi, Thanks for your reply. The problem is that calculation on CDS views by default are done at records level and aggregated, hence my idea was to use the @DefaultAggregation: #FORMULA annotation to get the desire result. A value greater than 0 treats a grade item's grades as extra credit during aggregation. 0. The data source with the KMs is the primary source. i will try to build some moke up data in excel and reproduce the same but before that could you please explain me in detail what calculation i need to perform in secondary source. What I'd really like to do though is define each of those metrics based on a filter unique to each metric. The unsupported aggregation happens when your aggregate requires row-level visibility to the secondary data source. In the Value field, enter the amount of time (in minutes) you want the old password to still be active after a password reset. 1. With this option, new values are updated to the InfoObject. I would like to visualize number of distinct hardware. For example, converting an object or an array fails:cannot blend secondary datasource because one or more fields use an unsupported aggregation . The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . You misread it apparently, and downvoted everyone for not answering a different question. PDF - Complete Book (10. [OIL DATE]) THEN MIN ( [KMs]) END. How to rewrite my calculation to fix the error: cannot blend the secondary data source because one or more fields are use and unsupported aggregation I have multi data sources blending and can not bring my calculated field into the main source. The following commands do not require automatic encryption. " (Option 1,2,3 or. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. 0 Installed Plugins No response Java Version bundled OS Version Darwin Kernel Version 21. You may choose to manage your own preferences. One of the ways I have fixed issues like this in the past is to add the filter I need as a data source filter on the secondary data source, rather than as a quick filter. The reason will be displayed to describe this comment to others. elastic. The version I am working with 10. Non-additive aggregates are generally not usable when a secondary dimension appears on any Shelf or there’s a linking dimension that is not in the view. Wrong aggregation type for query. DataFrameGroupBy. Hi @Ajay Velupula (Member) , I think Mahfooj's suggestion makes sense, if you have a common field between the two, in theory it sounds like a join should work and would give a better result than blending. Adjective [ edit] unaggregated (not comparable) Not aggregated. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Blend ID (transaction datasource) =. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported. Steps to reproduce: run ES; create rollup job such as this exampleA New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!Hi Shruthi, I am curious regarding your filters and LODs. it depends. CREATE MATERIALIZED VIEW V_TMP_PONYLIST BUILD IMMEDIATE REFRESH COMPLETE ON COMMIT AS SELECT. Other aggs such as cardinality, percentile or terms are not supported at the moment. If one of those measures is brought into a view with a linking dimension not in the view, or a linking dimension is turned on that is not in the view, the pill will turn red, the view will turn grey, and hovering over the pill reveals a "Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The following commands do not require automatic encryption. Hi All, I have blended primary and secondary data sources. Share. 6. In the below screenshot the error was observed at. Specifies that the aggregation type is unknown. functions as psf. To achieve this you need to add Calculated Field to an Analysis ( as described here ). search. sql. 5 or below.