UNSUPPORTED_IN_EXISTS_SUBQUERY. Another table is a a table that contains key fields such as date, region, location and hardware id (dimension). Cannot blend the secondary data source because one or more fields use an unsupported aggregation . The Queryable Encryption Public Preview, released in version 6. I did that in your example too. The date aggregation operators enable you to extract different parts of a given date or a timestamp. For example,. Non-additive aggregates are aggregate functions that produce results that cannot be aggregated along a dimension. Aggregation expressions: The values of multiple rows are grouped together to form a single value based on a mathematical function. Select Edit > New > DWORD Value . They both share a common field (State), and that is what I'm filtering on. If I create my calculated field without using an aggregation with {Profit}, QuickSight doesn’t know from which row to get the value. Adjective [ edit] unaggregated (not comparable) Not aggregated. 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. Call it [Start KM]: IF ATTR ( [KM Date])=ATTR ( [OIL]. Share. 3 and I have created aggregates AGG for fields from data extract and excel file. General Information. Please see if it helps , here it says that problem is with COUNT & they have provided one alternative way as well . You are getting the message because the data source can't support the the way you created the groups - it happens with some specific live data source when you try to do calculations that cross records (like counts(), Median() for example)You are not using the correct sum function but the built-in function sum (by default). When I try to add COUNTD([DistrictId]) from my primary to text table. 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. C Bi-level aggregation on the structural neighborhood. . It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. Elasticsearch Version 8. Q&A for work. I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. clients. here is the link to Github issue. Compatible drivers configured for automatic encryption do not support insert commands with the following behavior: Inserting a document with Timestamp(0,0) associated to an encrypted field. Mean of gradesWe have an enterprise data source that is an SSAS Tabular model. Applications using explicit encryption may use this page as guidance for issuing read and write operations against encrypted fields. The view should be created like this. Tommy Sims (Member) 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. Time-interval with identical time points. § 411. 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". " message. Group by with no aggregation expression is not supported. You may choose to manage your own preferences. Characteristics such as optical and catalytic activity may be lost if the dispersion of unsupported Ni NPs is not adequately modulated. Learn more about TeamsSupported and Unsupported Aggregation Pipeline Stages. I have changed the code with your suggested method and now getting this output: "ERROR : Unsupported document type for unmarshalling: []bson. 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. Any change done to the system defined settings like "ID, Description, Account Type, Hierarchy, Unit & Currencies, Aggregation Type, Exception Aggregation Type, Scale, Decimal Places, Calculate On, Hide" will have impact across all the. I thought the problems with Median and CountD being unsupported by DB2 blending were over as of version 9 (i am using. Someone in the Community told me the following: "MAX isn't supported in. Kindly see the screenshot as below:-The concept of data blending is, for every match in the primary table there should be exactly one row item in your secondary table, in the view of this concept any aggregation on the secondary table will always be distinct by default. The strange thing is running the query (the one that the Java API gives on a to string) through the REST endpoint works fine. Upgrade: open it with the 2020. Some aggregation and exception aggregation types do not support data entry. If there is another aggregation type such as AGG_AVG being used, change it to one of the supported. For example: My row text value is " [Custom Product] [Product 1] [Product 3]". Aggregation. I'm sorry, I can't answer queries using measures with an unsupported aggregation type. I would like to visualize number of distinct hardware. Currently, using the transactional side, the retention rate calc is (SUM (Headcount) from Employee side - SUM. Q&A for work. From my understanding of the ATTR function is that it's for aggregation purposes. You misread it apparently, and downvoted everyone for not answering a different question. This aggregation is unsupported: Quarter . I thought the problems with Median and CountD being unsupported by DB2 blending were over as of version 9 (i am using. The aggregation type (summation, minimum & maximum) specifies how key figures are updated if the primary keys are the same. Buckets can only be sorted on a sub-aggregator path that is built out of zero or more single-bucket aggregations within the path and a final single-bucket or a metrics aggregation at the path end. If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the. More MongoDB Aggregation Framework operators for array, arithmetic, date and set operations. We have a calculated filed where an aggregation (COUNTD) is done on a filed of secondary data source. dataCategory: #CUBE. 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. really need to see your twbx file to be of further help. Unsupported aggregation: The following aggregations cannot be inverted: <aggregations> Unsupported exception aggregation: The following exception aggregations cannot be inverted: <exception aggregations> Some exception aggregation types do not support data entry. average. Connect and share knowledge within a single location that is structured and easy to search. (Ditto the FIXED countD. 3 and I have created aggregates AGG for fields from data extract and excel file. using select to. Local variables declared inside curly braces are allowed. 61042 - 2014. Trending Topics. Supported Aggregation Pipeline Operators Atlas Data Federation supports all the aggregation pipeline operators. I am trying to blend the same data against the other because I wanted to show Same Period last Year. The driver does not provide methods for all aggregation pipeline operators in the Query API. I'm creating a calculation view in HANA, where I'm joining the PO tables, EKKO (Header), EKPO (Item) and EKET (Scheduled Lines). Unsupported exception aggregation: The following exception aggregations cannot be inverted: <exception aggregations> Some exception aggregation types do not support data entry. 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). Two time points but no time interval. Hi Justin, Thanks for your quick reply. Some functions, such as , are available only when you click the summarize button on the report object toolbar. CallTime Avg (internal)>> because CallTime Avg (internal) is interpreted as being. 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 restYou will need to transfer this logic into SQL. unknown. The aggregation framework collects data based on the documents that match a search request which helps in building summaries of the data. udaf (MyTypedUDAF) ) and call it for aggregate over your window. In your real world situation, if you have another dimension to split by, you may need to add that term to the left hand side of the LoD. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. On the payment side I've added an aggregation to roll everything up to the month level. Median of grades: The middle grade (or the mean of the two middle grades) when grades are arranged in order of size. 106 Aggregation rules. 55135 - Vivado Synthesis - Unsupported SystemVerilog Constructs. The aggregations framework is a powerful tool built in every Elasticsearch deployment. The blends indeed have limitations in terms of aggregation. I've tried that in the past, and I was always blocked by the unsupported aggregation message. This section describes the summary, or aggregation, functions that are available in IBM® Cognos® Analytics - Reporting. Extract and aggregate: Take an extract of your data and aggregate it based on the occurrences of Dimension X. When you add a measure to the view, Tableau automatically aggregates its values. As for transform: date_histogram is supported as part of group_by, I wonder why you try to use it in the aggregation part. ERROR : Unsupported document type for unmarshalling: []bson. Stores pre-aggregated numeric values for metric aggregations. 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. For that you can use the same method as for MyUntypedUDAF: val mMyTypedUDAFUDF: UserDefinedFunction = spark. There are a few DataFrame/Dataset operations that are not. Lowest grade: the smallest grade after normalization; Highest grade: the largest grade after. The one drawback is that DB2 blending does not support "non-additive aggregates" like COUNTD() and MEDIAN(). 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. These 49 findings and ratings are provided in Supplemental. More problematic regarding support is serial_diff, which is a pipeline aggregation. You can retrieve the buckets page by page and do the counting based on the doc count. What is the max length of the first characters are are in F Name? Is it always three or less? The issue with this join is the information on how much to join is in the one table, while the data to test is in the other. Currently, we have 2 different data sources. Hi everyone, I'm trying to blend two data sources on a single field, say 'Program Description'. 62K. Malika_Taouai (Malika Taouai) November 22, 2022, 4:56pm #1. mean any array of object I pass to this function it executes. really need to see your twbx file to be of further help. Cannot blend the secondary data source because one or more fields use an unsupported aggregation We are blending two data sources. The (0,0) value indicates that the mongod should generate the Timestamp. With the release of the MongoDB Analyzer for . calculated. 2. That said, we can probably use a FIXED LOD to sort of trick it. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" I have tried the following calculations but have not been able to figure this out. Both Primary and Secondary data sources have duplicate rows due to multiple joins in data prep. But a filter or range gives org. That will avoid duplicated records resulting from the join. Unfortunately can't share the data, and can't come up with a mock cause I can't figure out what's not/is working as expected. This aggregation is unsupported: Month . Usage In SortPossible 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. Define spend budgets and alert on budget overruns. The . Jun 1, 2021 at 9:05. I don't understand why the grouping isn't allowed. It supports pre-built data integrations from 100+ data sources. This aggregation is unsupported: Hour . I did that in your example too. The current aggregation appear as a part of the measures name in the view. I tried using Excel as the primary and I kept getting errors when I tried to add the cube. Elasticsearch organizes aggregations into three categories: Metric aggregations that calculate metrics, such as a sum or average, from field values. 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. It looks like these solutions are coming from 2013. NET dialect) to turn each line into 31 documents. If you need to use an unsupported operation in an aggregation, you must define the entire expression using the BSON Document type. Mean of grades (with extra credits): Unsupported aggregation provided here only for backward compatibility with old activities. Because the secondary data source always has to be aggregated, there's no way to do a row level check to filter out any dimension members that match between the two data sources. I have 2 filters (BU ISNull and CORPID) applied from secondary data source. 6. Try one of the following options, as appropriate for your workbook: It may be possible to cross database join instead of blending. Tommy Sims (Member) 7 years ago. An aggregate_metric_double field is an object containing one or more of the following metric sub-fields: min, max, sum, and value_count. Returns expression of the current instance cast to the type specified. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. The PipelineDefinitionBuilder class provides a type-safe interface for defining an aggregation pipeline. The workaround for this is that if you have to use one of the non-additive. 9 version and publish them as new (remove previous. It’s common to store strings in documents such as first name, last name, or location. 0, is no longer supported. 0. 0 may result in the physical switch disabling the LAG ports. 1. Teams. You signed in with another tab or window. " message. Aggregation is not supported for this object. I've tried using COUNTD() ID First Last 1 Jim Carrey 1 Jim Carrey 2 Liam Neeson 3 Wynona Ryder COUNT([ID]) = 4 COUNTD([ID]) results in. Windowed aggregations partition the results from a SQL query into groups in order to perform calculations across adjacent rows of the query result. Unsupported Aggregation, Quick Table Calc Sets, and Filters from Secondary Data blends?. 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. This is because any calculation will happen before aggregation in case of a formula or a calculated key figure and it will therefore not be pushed down. In the vSphere Web Client, navigate to the Distributed Switch. Wherever possible, the value of calculated is used, then sum where necessary, followed by unsupported. Learn more about Teams The manual process is: Read the data into a text editor. Try to extract from your data source; this usually solves the problem. 3 and I have created aggregates AGG for fields from data extract and excel file. Blue and green arrows denote the aggregation on the neighborhood in the graph and the latent space, respectively. I want to split this into 3 rows, which should show as following: [Custom Product] [Product 1] [Product 3] In POWER BI, this is easily accomplished by splitting to rows. Queryable Encryption with equality queries is generally available (GA) in MongoDB 7. The manual process is: Read the data into a text editor. When I do the join between the SSAS Tabular Model (primary data. Yup. The only tables allowed to use in a FROM. Drill down to the leaf level to enter data. "Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Hot Network QuestionsOfficial drivers compatible with Queryable Encryption parse read and write operations for operators or expressions that do not support BinData values or that have abnormal behavior when issued against BinData values. average. Unsupported Operations. (n = 8), and unsupported (n = 14). You can choose whether functional and advertising cookies apply. 0 using the C# MongoDB. Like below,. Hi All - its been a while since I chimed in and I did find a workaround for my case. pos_trn) (default) . Specifies that the aggregation type is unknown. Since the mongod cannot generate encrypted fields, the resulting timestamp would be. Data blending has some limitations regarding non-additive aggregates such as COUNTD, MEDIAN, and. I've created the first chart with no problem, but I. But, when I consider this data source as secondary and then try to use it in primary data source sheet, I get this error:- Cannot blend the secondary data source because one or more fields use an unsupported aggregation. COUNTD([DistrictId]) works fine If all measure & Dimension are part of same table. Try loading pyspark functions with an alias instead:. formula one layer above to div the amount. One small workaround which you can do is: 1) Create a calculation as {Max([Date])} 2) Create a parameter as follows:data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data base . Wherever possible, the value of calculated is used, then sum. To learn more about the Document type, see Documents. 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 . So the reason why the build-in function won't work is that's it takes an iterable as an argument where as here the name of the column passed is a string and the built-in function can't be applied on a string. CSS Error> Cannot blend the secondary data source because one or more fields use an unsupported aggregation . I get error: “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Data encrypted using the Public Preview is incompatible with the feature release. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. Cannot blend the secondary data source because one or more fields use an unsupported aggregation We are blending two data sources. If a function, must either work when passed a DataFrame or when passed to DataFrame. Note: The backup only stores the vDS configuration from the vCenter Server perspective. ) I need to revisit my understanding of the limitations here! data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data base . Wherever possible, the value of calculated is used, then sum. Step 4: Aggregation Dimensions in Tableau. The version I am working with 10. java. This aggregation is unsupported: Quarter . Bucket aggregations that group documents into buckets, also called bins, based on field values, ranges, or other criteria. Over Aggregation # Batch Streaming OVER aggregates compute an aggregated value for every input row over a range of ordered rows. Modified 3 years, 2 months ago. Having said this and following the discussion comments being posted by @Timo Rietveld and @Martin Weitzmann I assume that planning to visualize data in Google Data Studio and performing some aggregation functions it would probably required to flatten the data into the simple format using UNNEST operator achieving the best result. (Ditto the FIXED countD. An aggregation pipeline is a series of stages that are used to transform a document. For more information, see Compatibility Changes in MongoDB 7. However I keep getting the following error: co. For more information, see Compatibility Changes in MongoDB 7. 2. Max Archived November 30, 2022, 8:03pm 8. And I want to add one of the field from secondary dataset to be in the filter. 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). unsupported aggregation" | Tableau Software. Aggregation greatly improves query performance by bringing the computation to a local level where patterns can be extracted faster and more efficiently. Drill down to the leaf level to enter data. This section lists the supported functionality. I did that in your example too. Error: Cannot Blend the secondary data source because one or more fields use an unsupported aggregation. Cannot blend the secondary data source because one or more fields use an unsupported aggregationFollow this link for more information:×Sorry to interrupt. [OIL DATE]) THEN MIN ( [KMs]) END. In first calculation , aggregation should be applied on Measure(Numeric) Value . 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. CSS ErrorAn old, now unsupported, aggregation strategy provided here only for backward compatibility with old activities. So two data sources, blended, trying to do a count distinct on product or whatever in the secondary source. So you're basically passing a string 'converted' to the python built-in sum function which expects an iterable of int. Exception aggregation behavior. This page was last edited on 14 March 2019, at 05:24. Average is not supported as Default Aggregation in CDS when claiming @Analytics. column1 and -------^ a_s. Aggregations are created by. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. You can use aggregations in the analysis level calculated field. "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. "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" Is there any workaround for this? Will I have to change the calculated fields? Best regards. Then the pivot rearranges it, creating columns for the in values from the name column, and using the aggregate ( max (data)) for the value in that column, which should give the desired results. Every measure has a default aggregation which is. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . You'll need to. ElasticsearchException: [es/search] failed: [x_content_parse_exception] [1:44] [composite] unknown field [name] Here is my setup. M". In case of window-based aggregations, aggregate values are maintained for each window the event-time of a row falls into. if the JOIN condition is NOT UNIQUE in the above, we assume there is one student with a matching row having both a common sid and. You can use the variable REMOVE in aggregation expressions to conditionally suppress a field. 9 KB. Cannot blend the secondary data source because one or more fields use an unsupported aggregation. For example, “Sum of Sales,” “Average Profit,” or “Count of Customers. Can someone explain why you can't use a CountD from a blended datasource. The new string aggregation operators that were added to. contains. I have an LOD expression that works fine when the data source is the primary, but when I switch it to a secondary data source and then add the LOD expression to a view I get the annoying, "Unsupported aggregation" issue. ”. You can choose whether functional and advertising cookies apply. 5. Maven coordinatesOne solution is to count unique users on client side using the composite aggregation. I've read through the various posts on here, plus the general troubleshooting posts on the Tableau page on blending data, but can't find a solution. Learn more about TeamsThe aggregation rule is determined automatically at run time. The first part is the source data. Cut out the three explanatory lines at the top (can be done with regex) Run a regex replace on the file (I’ve used . Aggregation is computed as an average of the values in the result set for this object. g. This aggregation is unsupported: Hour . For more information on aggregation types, refer to Disaggregation of Values During Data Entry. 0 or later compatible drivers configured for automatic encryption. DataFrameGroupBy. It can be misunderstood, but, when using a data blend correctly, it is an efficient way to merge data sources in Tableau. ”Unsupported aggregation type. 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. Since there were no actual relation between the tables, this is the way I tried assigning the relationship:In a grouped aggregation, aggregate values (e. Local variable usage in aggregations - A local variable cannot be used in an aggregation function, if the variable is declared outside of the aggregation function. Thanks for the suggestion. What I'd really like to do though is define each of those metrics based on a filter unique to each metric. "-5", "123456") and fall within the minimum and maximum value for an integer. 0, is no longer supported. MovieId, STRING_AGG(FullName) AS Actors FROM `<snip>. The examples in this guide use the restaurants collection in the sample_restaurants database provided in the Atlas sample datasets . An aggregate_metric_double field is an object containing one or more of the following metric sub-fields: min, max, sum, and value_count. 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. blending takes place in step 6 of the Order of Operation after all the context and dimension filters have been applied - you will not be able to filter across the data sets after that point - Teams. Exception aggregation on a formula member: No data entry possible because an exception aggregation has been set on a formula member. Loading. A COUNTD of Order ID should be all I need to show this data but it always results in a "Cannot blend the secondary data source because one or more of the fields use an unsupported aggregation" What can I do to get around this?Aggregate metric field type. 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. twbx. It said one or more fields use an unsupported aggregation. I’ve found a couple examples in the forums. Ditto: { FIXED [Patient ID] : COUNTD([Patient ID]) } Yet there it is in your workbook, very happy and functional. Python Official Documentation. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies. @Point Partner BI Team (Member) hi there,. . EKKO-EBELN = EKPO-EBELN (1:n) 2. Issue. Teams. If you change Calculation1 to the following, it will no longer act as an aggregate: {FIXED : MAX (MONTH ( [DATE_CREATED]))}hi @Ambreen Firdous (Member) . g. contains a reference to at least one data item that has the Summary aggregation property set to a value other than None If the underlying data source is relational and if the data item expression contains no summary functions and a reference to at least one fact that has the Regular Aggregate property set to a value other than Unsupported. An old, now unsupported aggregation strategy provided here only for backward compatibility with old activities. Temporary tables are not supported by multi-connection data sources that use active connections. The current aggregation appears as part of the measure's name in the view. LINQ allows you to construct queries against strongly typed collections of objects by using language keywords and operators. 0. The requirement is to provide Average aggregation for a measure in Fiori app (with dynamic sorting and filtering). I couldn’t get anything to work. Materialized is an absolute requirement because of performance reasons, and it is required, that the view updates itself on commit. The code is not aware of such values and throws an unsupported exception. Parameters: funcfunction, str, list, dict or None. Cannot blend the secondary data source because one or more fields use an unsupported aggregation Did some research on this and found plenty of "workarounds" with no. 1. For more information on exception aggregations, refer to Disaggregation of Values During Data Entry. 0CALDAY (YYYY-MM-DD) 0CALMONTHThis guide will help you check for common problems that cause the log ” Unsupported aggregation type [{}] ” to appear. For example, you would not be able to use a measure with the expression <<root. Hi Jim, Even if I don't join the 2 data sources and just blend them by "Region" and "Store Name", I still get "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" on dragging Total Utilized Money field into the view. My assumption and at least in my test it seems so, is that TOTAL applies the aggregation to all underlying entries in the partition whereas WINDOW_FX uses the function on the already aggregated values. Hello I am having a problem with the relationship between two data sources. The workaround for this is that if you have to use one of the non-additive aggregates, use DB1 blending, i. I am trying to use the below formula instead of countd function because my data comes from Impala. Right-click OldPasswordAllowedPeriod, and then select Modify . Returns true if the first parameter string value ends with the. 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. The data source with the KMs is the primary source. ) I need to revisit my understanding of the limitations here!data from the second source comes over as an aggregate - look into what the aggregation is on and how does that relate to what you have in the primary data base . 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. Expand Post. “Cannot blend the secondary data source because one or more fields use an unsupported aggregation. Jim. In other words: Column-references must either be part of the grouping keys, or they must be part of the aggregation. NET/C# Driver automatically translates LINQ queries into aggregation operations. Expand Post.