Solved

@Eric Stein-Beldring - is there a way to lock the y-axis when you have a chart in stacked mode? We have a good example that our team has been using where we’ve created a calculated column that we need to zoom in on to see the short term trends, but the moment we move the mouse over the chart the y-axis automatically re-adjusts not allowing us to use the stacked feature. If we could toggle y-axis auto adjustment, that would be very valuable!Not zoomed burgundy line vsZoomed burgundy line 

Would like to know in detail about the fact extraction from drilling reports. Is there any capability in CDF to do such fact extraction and relevant methods to process drilling reports?

We are interested in retrieving data from cdf through the odata service. We would do this not from Power BI, but from another Power Platform component, namely Dataverse. (the purpose would be to create "virtual tables" there which we could query, and in that way we could control access to the data more granularly then we are able to thorough the Cognite API) The documentation we find only mentions the OData connector in relation to Power BI (e.g. Cognite Power BI connector | Cognite documentation (cogniteapp.com) and Tips and best practices | Cognite Documentation). Is Cognite's OData service specifically tailored for Power BI, or is it a full implementation according to the OData standard? Is anyone able to recommend for or against attempting the proposed approach?In case the service implements the standard, does anyone know which version of the standard is it?

Hello,I have a Python project that uses publicdata project of Open Industrial Data. I am trying to refactor the authentication step to use Python-SDK with OAuth since the API keys are (being) deprecated.To do so, I need the parameters token_url, client_id, client_secret, scopes.I am setting the parameters as such:cognite_tenant_id = "48d5043c-cf70-4c49-881c-c638f5796997"token_url=f"https://login.microsoftonline.com/{cognite_tenant_id}/oauth2/v2.0/authorize"client_id=???client_secret=<client secret generated from Open Industrial Data https://hub.cognite.com/open-industrial-data-211>scopes=["https://api.cognitedata.com/user_impersonation"]I would like to know if we can use the already defined Cognite tenant in AAD with Tenant Id “48d5043c-cf70-4c49-881c-c638f5796997” ? Are you providing the client id for that then? Similar to the ones publicly provided for Postman and JS-SDK? Please also note that I cannot use interactive login since it is not a one-off script.Moreover, I cannot re

I have ingested RAW data into CDF for a bunch of equipment (16) and also applied transformations on those to setup Assets, Timeseries, Datapoints and Events. I have a P&ID diagram (PDF) which has 4 Equipments shown in the Diagram with P&ID#. I would like to know the process of ingesting this file as a resource type for this equipment setup and where do I upload the file?  When the user selects any of the above Equipment in CDF, the system should display the enclosed P&ID diagram.

Data set is not available in the below path for the practice, kindly request your support to resolve this ASAP.   Regards,Naveen

While trying to setup the Google - colab for CDF environment and authentication, i am getting an error. Unable to trace the rootcause of this error.  This code is a part of Notebook setup given in the Hands-On course Link to notebook - Data processing and analysis for IDA course.ipynb - Colaboratory (google.com) TypeError Traceback (most recent call last)Cell In [2], line 57 55 def get_token(): 56 return authenticate_device_code(app)['access_token']---> 57 client = CogniteClient( 58 ## token_url=f'{AUTHORITY_URI}/v2.0', 59 token=get_token, 60 token_client_id=CLIENT_ID, 61 project=COGNITE_PROJECT, 62 base_url=f'https://{CDF_CLUSTER}.cognitedata.com', 63 client_name='cognite-python-dev', 64 ) 65 print(client.iam.token.inspect())TypeError: __init__() got an unexpected keyword argument 'token'

  @Kristoffer Knudsen In Cognite Infield, It appears that once the checklists are archived, there is a default time period of 3 weeks before they are permanently deleted based on what we see after archiving a checklist (release notes from Jan 2022 seem to show 4 week keep period). Some operating units have longer or shorter retention policy for their checklists, after archival and it would help to have this retention time period configurable. Based on a quick scan of current Infield configuration parameters, it didn’t appear to be a configurable parameter for now, under the Infield configuration items in CDF.  Need clarification on this.

Hi,As part of the exercise -”Match time series to assets” I am not able to see the dataset i have created - Pavan1978-IFSDB when i used Quick Match.. 

Is there any way to read CSV files in an incremental manner from a drop folder following a file name pattern and ingest the data into specific RAW tables.Eg. I have file names which have timeseries data from daily report with columns like asset id, timestamp, data point. With file name pattern as “timeseries_<unique number/date>.csv”. Users are pasting these files in a public sharepoint location in an incremental manner. 

I’m trying to run the asset transformation. however, after creating the query I have this error.An error occurred when running this query"Verify that the 'Patricio1974.assets' relation exists | code: 400 | X-Request-ID: fe28e7d2-397d-9e68-bea4-a1c0979a4b4f"Find below the query:SELECT  concat('Patricio1974:', loc) as externalId,  IF(    parent_loc = ''    OR parent_loc IS NULL, '', concat('Patricio1974:', parent_loc)) AS parentExternalId,  CAST(lastUpdatedTime AS STRING) AS name,  to_metadata(*) AS metadata,  description AS description,  4577431473554653 AS dataSetIdFROM  `Patricio1974`.assets 

I run this query per the instructions and I get the following preview errorSELECTconcat('Cory1965:',loc) as externalId,IF(parent_loc='' OR parent_loc IS NULL, '', concat('Cory1965:',parent_loc)) AS parentExternalId,CAST(lastUpdatedTime AS STRING) AS name,to_metadata(*) AS metadata,description AS description,Cory1965-AvevaNet AS dataSetId FROM `Cory1965`.assets Error An error occurred when running this query"Cannot resolve 'Cory1965' given input columns: [zcb2dd7b7c3704ca2a0d8659e146db2f9.WMT_SYSTEM_ID, zcb2dd7b7c3704ca2a0d8659e146db2f9.WMT_TAG_ID, zcb2dd7b7c3704ca2a0d8659e146db2f9.description, zcb2dd7b7c3704ca2a0d8659e146db2f9.key, zcb2dd7b7c3704ca2a0d8659e146db2f9.lastUpdatedTime, zcb2dd7b7c3704ca2a0d8659e146db2f9.loc, zcb2dd7b7c3704ca2a0d8659e146db2f9.name, zcb2dd7b7c3704ca2a0d8659e146db2f9.parent_loc]; line 11 pos 0;\n'Project [concat(Cory1965:, loc#23978949) AS externalId#23978912, if (((parent_loc#23978951 = ) OR isnull(parent_loc#23978951))) else concat(Cory1965:, parent_loc#2397

Hi @Stig Harald Gustavsen , I was wondering whether you could help me understand a bit more a couple of time series related to energy consumption for cooling and compression in the first stage compressor , and also if we can see/infer the Barrel of Oil Equivalent (BOE). for instance, I do not understand the diff between this time series: VAL_23-KA-9101-M01_active_power_kW  VAL_23-KA-9101-ASP VAL_23-KA-9101-ESP  Also, I see that Valhal is powered from shore via a 294 km long DC cable with 78MW capacity from Lista, but the compressor seems to “only” consume 9MW on average - what are the other large energy consumers on Valhal ?many thanks, Alex

I am currently working on a concept for representing tag data in a simple graph (subject - predicate - object - style)An instance of the triple could be something like this D-20VA00001 - hasDryWeight - 5000In parallell I have instanciated another graph holding ontology data and mapping (like CFIHOS, mapping between CFIHOS class and function code and sap referance data etc.) Lets call it the meta-graph.What I want to do is to take a “traditional” tag as input, map the function code on the tag to corresponding CFIHOS-class, and get required attributes in return from the meta-graph. Further I then want to dynamically instanciate every attribute as relation in the triple’ish graph. In order to do this I need to be able to query a data model (FDM) in a transformation- is that far away?Further, now I am faking a labeled property graph in FDM - is LPG functionality far away? 

I am doing the Working with CDF Integrate module, but I have the following sql query error: An error occurred when running this query"Mismatched input ''rocio1975'' expecting {'(', 'ADD', 'AFTER', 'ALL', 'ALTER', 'ANALYZE', 'AND', 'ANTI', 'ANY', 'ARCHIVE', 'ARRAY', 'AS', 'ASC', 'AT', 'AUTHORIZATION', 'BETWEEN', 'BOTH', 'BUCKET', 'BUCKETS', 'BY', 'CACHE', 'CASCADE', 'CASE', 'CAST', 'CHANGE', 'CHECK', 'CLEAR', 'CLUSTER', 'CLUSTERED', 'CODEGEN', 'COLLATE', 'COLLECTION', 'COLUMN', 'COLUMNS', 'COMMENT', 'COMMIT', 'COMPACT', 'COMPACTIONS', 'COMPUTE', 'CONCATENATE', 'CONSTRAINT', 'COST', 'CREATE', 'CROSS', 'CUBE', 'CURRENT', 'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURRENT_USER', 'DAY', 'DATA', 'DATABASE', DATABASES, 'DBPROPERTIES', 'DEFINED', 'DELETE', 'DELIMITED', 'DESC', 'DESCRIBE', 'DFS', 'DIRECTORIES', 'DIRECTORY', 'DISTINCT', 'DISTRIBUTE', 'DIV', 'DROP', 'ELSE', 'END', 'ESCAPE', 'ESCAPED', 'EXCEPT', 'EXCHANGE', 'EXISTS', 'EXPLAIN', 'EXPORT', 'EXTENDED', 'EXTERNAL', 'EXTRACT

Dear Expert Community,I have created dataset, it is available at data set section and but when it comes to contextualize=> “Match entities”=> “Quick match”. and then tried to find my data set with resource type “time series”   I’m not able to find the data set, which is already there in the section “manage dataset catalog”. Any specific reason for this?, How can I solve this issue?Thanks & Best Regards, Mariangelika

When creating a transform into an FDM type, it is necessary to provide the externalId of the instance. Does the value of externalId need to be unique across all instances of all types in the model or only across instances of the given type?

Hi I attempt twice and got 73% but not able to attend Assessment one more time. kindly enable so that I will attend assessment.  Rajesh

While setting up credentials while transforming getting this error.Error : Session Create Error:Request failed: Status code 401 Tried creating multiple times no luck any help pls

Hi from HUB Ocean and the Ocean Data Platform. We are participating in the open ocean data cataloging scene, for instance through the EU ILIAD “Digital twin of the ocean” project.Home | Iliad - Digital Twin of the Ocean (ocean-twin.eu)In order to improve the interoperability between the myriad of ocean data portals, web services and data catalogues out there, it will be very important for the Ocean Data Platform data catalog to support technologies and concepts like RDF (Resource Description Framework), SHACL (Shapes Constraint Language) and SPARQL (RDF query language). Is this already supported by FDM or is it on the roadmap?

As we develop richer models supporting a greater variety of workflows, we have started asking questions about model maintenance and modularization. Decomposing large models into sub-models that have low coupling seems attractive, but would require some type of referential support across models. Is Cognite considering such a feature, or how do we envision managing complex models in general? As you are probably aware large models have an increased risk that a breaking change in a peripheral type will force a new version on the entire model. Since data must be manually migrated today, this creates a maintenance load that we would be keen to address.

Hello All,I have created dataset, it is available at data set section and but when it comes to contextualize=> “Match entities”=> “Quick match”. and then tried to find my data set with resource type “time series” At this point, i am not able to find the data set, which is already there in the section “manage dataset catalog”. Any specific reason for this?

I used to see a link to Jupyter Notebook on CDF Main Page. Now I dont, what happened?

Team - is there a way to generate a calculation in Cognite charts where you’re comparing data from the current timestamp value to something several minutes prior (say 30 minutes)? Any assistance on this would be welcome!

Hi,I’m just getting started with Cognite. I’m trying to create some assets. I’ve loaded them into RAW and I’m trying to write a SQL transformation to load them into assets. Is there documentation on what functions are available? I’ve gone through the online training and the simple example there, but it doesn’t cover what I’m trying to do.My specific questions are that I’m looking for documentation to answer are (for now):What data type is the id, parentid, and other fields How do I cast the string data in the csv to right type. I assume there is a Cast function The UI tells me I have the wrong type. It doesn’t tell me which field and what type it expects. That would really be helpful. In this case, I know what field, but I don’t know the type it’s looking for. For a top level asset in the hierarchy, what do I use for parentID? If I have spaces in the field names in my CSV, how can I reference the field?