cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ebele
‎02-29-2024
  • 24 Posts
  • 1 Likes Given
  • 1 Solutions
  • 1 Likes Received

Rules on the report level?

by Obsidian | Level 7 in SAS Visual Analytics
‎02-14-2023 05:31 AM
‎02-14-2023 05:31 AM
Hi,  In Viya, you can enable/disable export functionality through a rule. I want the user to have export capabilities for certain reports, but not for other reports (rules on the report level). Is that possible, will that be possible? Kind Regards, Ebele ... View more

Re: removing Opcode and eventflag chars in CSV output

by Obsidian | Level 7 in Streaming Analytics
‎01-17-2019 05:17 AM
‎01-17-2019 05:17 AM
Hi Andy,   Thanks, Is there another way (in esp) to subscribe to a socket connection and have full control on the output lines ?    Kind Regards, Ebele   ... View more

removing Opcode and eventflag chars in CSV output

by Obsidian | Level 7 in Streaming Analytics
‎01-11-2019 04:38 AM
‎01-11-2019 04:38 AM
Hi, We're using the file and socket connection as a subscriber with CSV output. Is there a way to get rid of the opcode and eventflag (I,N,) from the output ? I mean, these characters? I,N, Kind Regards, Ebele ... View more

What would be the best approach to handle offline situations for ESP o...

by Obsidian | Level 7 in Streaming Analytics
‎11-01-2018 04:43 AM
‎11-01-2018 04:43 AM
We have models running on edge devices with subscriptions (mqtt) to a central message broker (rabbit). In case of no network between the device and the central broker, esp needs to buffer messages. Not sure how to accomplish this. My current thoughts: detect a failing subscription connector, through connector orchestration. State change MQTT subscription connector from running ---> finished and act on this by starting a file/socket connection which buffers messages to a local file. State change MQTT subscription connector from finished ----> running, act on this: read the local file and start normal operation (sending messages to a central message broker). I don't know if this will work. Any thoughts are welcome... Cheers, Ebele    ... View more

Re: Generate a message when there is no message

by Obsidian | Level 7 in Streaming Analytics
‎09-06-2018 11:00 AM
1 Like
‎09-06-2018 11:00 AM
1 Like
Hi Andy,   Yes, that works. Thanks a lot. It generates one event in case of 'a not arriving e2'.   Also very happy with the timer connector which is available in 5.2. With this, the pattern window can still be initiated when there are no input messages from the sensor. In that way we can create multiple messages instead of one.    Thanks! Ebele    ... View more

Re: Generate a message when there is no message

by Obsidian | Level 7 in Streaming Analytics
‎09-05-2018 06:57 AM
‎09-05-2018 06:57 AM
Hi Andy, Nice!   Tried your solution, but the not(a) doesn't occur in case of there are now input messages at all. In that case the pattern just isn't executed (or dies), without sending a notification.   <patterns> <pattern name="error"> <events> <event name="e1" source="B01_Parse_json"><![CDATA[isNull(raw_sensor_output)==0]]></event> <event name="e2" source="B01_Parse_json"><![CDATA[isNull(raw_sensor_output)==0]]></event> </events> <logic><![CDATA[fby{10 seconds}(e1, not(e2))]]></logic> <output> <field-selection name="raw_sensor_output" node="e1"/> </output> </pattern> </patterns>   We got 1 sensor. So no other messages from other sensors.   Where can I find the timer connector/adapter, I think we need that one to produce some events to have this working.   Cheers, Ebele   ... View more

Generate a message when there is no message

by Obsidian | Level 7 in Streaming Analytics
‎09-04-2018 09:23 AM
‎09-04-2018 09:23 AM
We receive messages from sensors (each 10 seconds) and put them on a queue.  This is done in a very simple ESP model on a edge device, using a socket connector and writing the message to a message queue.   As long as the sensors function properly, there is no problem in our ESP Models. But if a sensor stops sending messages, we still want to produce a message in our ESP model (each 10 seconds, one message) indicating the sensor hasn't produced a valid message.   What would be the best approach for this ?     Thanks, Ebele ... View more

Re: auto incremented, unique identifier in DB

by Obsidian | Level 7 in Streaming Analytics
‎07-24-2018 07:19 AM
‎07-24-2018 07:19 AM
Patrick, thanks for your suggestions. The view tip might be the best workaround for this situation. But I'm still interested if it is possible in the ESP model.   In an plain insert statement, you specify the DEFAULT (or NULL) keyword for the serial column, for example: INSERT INTO test (id, NAME) VALUES(DEFAULT, 'http://www.postgresql.org')   We tried to define the column in ESP with a value "DEFAULT", but that is not working. I will check with technical support if there is a way to accomplish this. I will let you know, if there is a way. ... View more

auto incremented, unique identifier in DB

by Obsidian | Level 7 in Streaming Analytics
‎07-23-2018 06:06 AM
‎07-23-2018 06:06 AM
Hi, From an ESP model we want to update a db table which has column defined as serial key (SERIAL PRIMARY KEY). In this way postgres creates a auto incremented, unique identifier. How do we define this column in the ESP schema? We've tried several options: to insert data into a DB table, ESP expects a field for each column in the schema. The functional window which writes the values to db looks like this: <window-functional pubsub="true" name="B03_Write_raw_sensor_data"> <schema> <fields> <field name="raw_sensor_data_id" type="string"/> <field name="esp_id" type="int64" key="true"/> <field name="sensor_id" type="int64" key="true"/> <field name="sensor_status" type="string"/> <field name="sensor_status_description" type="string"/> <field name="phenomenom_time" type="date" key="true"/> <field name="value" type="double"/> <field name="unit" type="string"/> <field name="raw_sensor_output" type="string"/> <field name="load_time" type="date"/> <field name="sensor_metadata_id_from_sensor_metadata" type="int64"/> <field name="access_license_id_from_access_license" type="int64"/> <field name="quantity" type="string" key="true"/> </fields> </schema> <function-context> <functions> <function name="load_time"><![CDATA[timeCurrent()]]></function> <function name="access_license_id_from_access_license"><![CDATA[1]]></function> <function name="raw_sensor_data_id"><![CDATA[concat(esp_id,sensor_id,phenomenom_time,quantity)]]></function> <function name="sensor_metadata_id_from_sensor_metadata"><![CDATA[sensor_metadata_id]]></function> </functions> </function-context> <connectors> <connector class="db" name="raw_sensor_data"> <properties> <property name="type"><![CDATA[sub]]></property> <property name="snapshot"><![CDATA[false]]></property> <property name="connectstring"><![CDATA[DSN=lmw_tmp;uid=??;pwd=??;]]></property> <property name="desttablename"><![CDATA[@schema@.raw_sensor_data]]></property> </properties> </connector> </connectors> </window-functional> As a workaround now, we use a concatenation of several fields (concat(esp_id,sensor_id,phenomenom_time,quantity).   Postgres is the database, working with ESP 5.1. Ebele Veenstra RWS ... View more

Re: current identity in a filter in VA

by Obsidian | Level 7 in SAS Visual Analytics
‎10-19-2015 02:02 PM
‎10-19-2015 02:02 PM
Hi Sam, Thanks for letting us know. I have created an "idea". Thanks. Ebele ... View more

current identity in a filter in VA

by Obsidian | Level 7 in SAS Visual Analytics
‎10-16-2015 07:09 AM
‎10-16-2015 07:09 AM
Hi, Is it possible to use the current identity in a filter for a VA report, without using row level permissions on the data ? I want to achieve functional seperation rather than row level security on the lasr table. Kind regards, Ebele   ... View more

Thinapp Enterprise Guide local server connection

by Obsidian | Level 7 in Administration and Deployment
‎10-01-2013 10:35 AM
‎10-01-2013 10:35 AM
Hi there, Has anyone thinapped SAS Enterprise Guide 5.1 together with SAS Foundation 9.3 M2 in one bubble ? If yes, are you able to start Enterprise Guide twice and connect to the local server in both Enterprise Guide sessions? In our situation, starting the local server  in the second session fails with a "class not registered" error. Any help appreciated. Ebele ... View more

Re: copyobjects change target name

by Obsidian | Level 7 in Administration and Deployment
‎07-30-2013 03:52 AM
‎07-30-2013 03:52 AM
Hi, I didn't expect this kind of discussion, when I dropped the question about the copyobjects utility 🙂 We strive to have standardized installations and configurations on all levs, including all customized metdata: groups, roles, application servers. To achieve this, we script and automate as much as possible. Installations and configurations are manufactured in a infrastructural development environment and promoted to the target environment:Dev,Test,Prod1,Prod2,Demo, etc...all z/os 64 bit. There are many improvements in 9.4 in this area, but even in 9.4, I can't find any documenation on the copyobjects utility (except /?). I guess I need to write a sas program and change the name of the logical server definitions with the METADATA_SETATTR function.... Kind regards, Ebele ... View more

Re: copyobjects change target name

by Obsidian | Level 7 in Administration and Deployment
‎07-26-2013 02:56 AM
‎07-26-2013 02:56 AM
Hi Jaap, We have approx. 10-15 application server contexts defined for authorization purposes. The corresponding OS files are created by scripts, including the security on these files. Of course you can create a application server interactively using the management console, but since there are 10 levels, this is quite a bit of clickwork. One approach would be to create all applicition server in one lev and promote them to next. You can use the -subprop file to dynamically change settings f.i. port numbers. The most easiest way is to create one template "Application Server Context" and copy this. But then you manually need to change the names (or write a sas program to do this) of the copied metadataobjects, since I can't see a way to have copyobjects.rexx doing this... Ebele ... View more

copyobjects change target name

by Obsidian | Level 7 in Administration and Deployment
‎07-25-2013 09:38 AM
‎07-25-2013 09:38 AM
Hi, Is it possible to change the target name of an object when you copy a metadata object using the copyobjects util in SASPlatformObjectFramework? For instance, when you copy a Application Server Context from /System/Servers to the same location, you get "Copy of" in the name of the new Application Server Context: The command: "C:\Program Files\SASHome\SASPlatformObjectFramework\9.3\copyobjects.exe" -host "xxx" -user="sasadm@saspw" -password="xxx" -port=51000 -domain DefaultAuth -objects "/System/Servers/_POV_(ApplicationServer)" -target "/System/Servers/" Kind regards, Ebele ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-29-2024 12:14 PM
Likes given to
View All
Likes from
View All
Quick links