RELEASE NOTES

360Suite Web Platform

April 13th 2022

360Suite Web Platform 2022.2

We are very happy to introduce you to this latest release of 360Suite Web Platform.

As always we are introducing new features and bug fixes but this time it’s extra special. We are launching our first, ever, 360Suite Freemium edition! 🙌 (more information below)

Do get in touch if you need help with updating and please read below for more information regarding what’s new, compatibility updates, change logs and resolved issues.

Full Documentation: https://support.wiiisdom.com/documentation
Download Site: https://support.wiiisdom.com/downloads

Contact us via your Customer Centre and Support Site: https://support.wiiisdom.com/

We hope you enjoy this release.  We are already busy working on 2022.3 in time for the summer 🌞!

Until then, take care and stay safe.

New Features

360Suite Web Platform (Solutions)

360Bind: Default Project Created By Default

When installing 360Bind for the first time, a “Default” project is now created to accelerate the onboarding process.

360Cast: Support Pipe “|” as a CSV delimiter

When exporting using the CSV format, you now have the ability to use a pipe “|” as a separator.

360Cast: Audit Destination List Usage

You can now audit the usage of the Destination Lists by Tasks. In this example you see that the list is used by two different tasks.

360cast-audit-destination-list-usage

360Init: Update Security Model

360Init is a very powerful solution where you can initiate BOBJ projects using a simple Spreadsheet Template.  It was released in 2022.1.

In this release we have added the ability to not only initiate your security model.  But also maintain is using the same Excel Template!

Powerful stuff 💪

 

360Vers: Replicating versioning data when using a new repository

This feature has principally been added for customers going through an upgrade to SAP BI 4.3.

In this process you will need to install a new version of 360Suite Web Platform which is adapted for the latest SAP BI 4.3 SDK.  This requires that you use a new repository database.

To make sure you are not losing your 360Vers versioning data, you can now replicate it to the new 360Suite repository.

360vers-versioning-configuration

360Suite Web Platform (Core)

Updated Timeout Screen

More user friendly experience.

360suite-timeout

More Detailed 360Suite Licence Information

We are now displaying with more details the licences that have been added in the product. E.g.:

360suite-licence-information

Support Changing the CMS Name

In the scenario where you CMS name changes (Disaster Scenario for instance where you restore your environment on a new server and the old environment no longer exist), you now have the ability to rename the CMS in 360Suite so you can keep your Tasks, Backups, Versions, etc.

360suite-general-preferences

360Suite Freemium

We are super excited to announce our first ever 360Suite Freemium solution!

This release is offering you the ability to do free regression testing for a number of scenarios such as:

  • Installing a service pack
  • Upgrading to SAP BI 4.3
  • Monitoring your content for unexpected changes on an ongoing basis

Some details about this Freemium:

  • Available to all SAP BusinessObjects customers
  • Freemium is supported on versions BI 4.1, BI 4.2 and BI 4.3
  • Test up to 10 Web Intelligence documents every week to detect regressions
  • Reveal complete details of test reports 5 times

Simply register with  us to get a 100 days product key.
Note: You do not have to be a 360Suite customer.

After the installation, you will be ready to run, free, regression testing.

360suite-freemium-screen

Start using immediately:

start-360suite-freemium-screen

Change Logs

Change
Description
Tomcat Service The Tomcat Service shipped with 360Suite WP now has a default maximum RAM for new installation of 4096 MB instead of 2048 MB
SMTP Configuration When configuring SMTP and successfully testing it, the configuration will be automatically saved

Resolved Issues

Issue ID
Description
P360SUITE-10050 Clear Inboxes does not clear inboxes
P360SUITE-10049 NullPointerException error when trying to repoint Webi Universe for individual report
P360SUITE-10013 When there is a broken document on left and missing document on right, comparison raises NullPointerException
P360SUITE-10010 Notifications are not saved when creating a task
P360SUITE-10004 Cannot change prompts of documents of a directory with Crystal & CRFE due to IndexOutOfBounds
P360SUITE-9993 Unable to clear inboxes
P360SUITE-9988 Customer information form layout is not responsive
P360SUITE-9986 Watcher Range not working on Monday
P360SUITE-9984 Remove group button appears on user and lead to ClassCastException
P360SUITE-9974 Can’t create regression testing export task if we do not have view
P360SUITE-9973 Cannot import new users with credentials user and password
P360SUITE-9953 PDF image resolution has no default value
P360SUITE-9948 Unable to restore personal documents
P360SUITE-9943 Wrong link to support in setup
P360SUITE-9938 Vers Extension: Error during the computation of the Version number
P360SUITE-9937 NullPointerException when the template format is not supported
P360SUITE-9936 Separate the Template name from the text
P360SUITE-9933 No error message for Destination Kind fields in Export Task Processor
P360SUITE-9931 Can’t copy from Public Folder to a Personal Folder
P360SUITE-9928 Performance issue with specific kind queries
P360SUITE-9927 Cannot access to checked out object view
P360SUITE-9924 Updating a Watcher does not work properly
P360SUITE-9922 Prompts input are not visible easily
P360SUITE-9921 User properties are not updated
P360SUITE-9920 In some BOBJ version, impossible to send documents into BIInbox because CeKindEnum cannot be found
P360SUITE-9919 If Crystal prompt is not in use but not marked as optional, it prevents Bind and Cast to properly set the parameter
P360SUITE-9917 “valueComputed” is not taken into account when “value” is defined
P360SUITE-9916 Do not update the focused input in filters
P360SUITE-9915 “Add new user” in a group is displaying “Add sub group” instead
P360SUITE-9912 “Save” button disappears on error with the backup path configuration
P360SUITE-9911 Admin licences users are case sensitive, BOBJ is not
P360SUITE-9910 Error message when clicking “Update Password” button at first installation
P360SUITE-9909 Use of advanced filters are not tracked anymore
P360SUITE-9907 Copy membership from User shows the Copy membership from Usergroup
P360SUITE-9904 Can’t restore + duplicate documents or universes
P360SUITE-9903 Public Document submenu is not highlighted
P360SUITE-9900 When SDK does not initialise the recurring status, recurring instance documentation ends with NullPointerException
P360SUITE-9899 Bad Custom Access Level Granular Rights documentation
P360SUITE-9898 Can’t export BOBJ promotion task iF vers is not activated
P360SUITE-9888 LockAquisitionException on task list due to too greedy task mapping
P360SUITE-9869 Link to the console on the console
P360SUITE-9854 Unable to add sub group to root server or user group
P360SUITE-9823 Can’t add Security lock
P360SUITE-9777 Crystal allows to have no Human Readable name on prompts and leads WP to error
P360SUITE-9771 “Open” button appears for users in actors selection and lead to error
P360SUITE-9758 Error 500 if task does not exist and we run external task
P360SUITE-9641 Java Path with spaces causes issue for the probe service
P360SUITE-9593 Default java options for Tomcat are appended each time the setup is run
P360SUITE-9500 Security Zone Web Action Documentation Failed Under LDAP Auth
P360SUITE-9126 CONCAT function in Excel is not supported when importing an Excel template

February 28th 2022

360Suite Web Platform 2022.1.2

We have made some tweaks and improvements under the hood in this hotfix to make your 360Suite Web Platform even smoother.

Full Documentation: https://support.wiiisdom.com/documentation

Download Site: https://support.wiiisdom.com/downloads

Do get in touch if you need help with updating and please read below for more information regarding what’s new, compatibility and resolved issues.

Support Site: https://support.wiiisdom.com/

See you in a few months for 2022.2 🌻

Take care and stay safe!

New Features

360Suite Web Platform

Download Support Logs

From time to time we may need to review the logs of your application to determine what the problem is and where it is coming from.

We make this process easier from the About screen where you can now simply download the Tomcat logs and send them to our support team.

download-tomcat-logs

How To Sheet for Task Templates

Many of our tasks will allow you to use an Excel Spreadsheet template to define what needs to be done in that task. This is very powerful but not always simple to use for the more advanced ones.

For example, let’s say you want to Import Users in Bulk via an Administration Task in 360View.

This template has 22 columns and looks like this:

excel-spreadsheet-template-taks

You will now find a new “How To” sheet in the template showing you how to use it:

new-excel-spreadsheet-template-taks

360Cast

Support of BOBJ Events on External Tasks

360Cast Tasks can now wait for BOBJ Events just like other kinds of tasks in 360Suite.

support-bobj-events-external-tasks

360Cast & 360Bind

Setting Prompts Values in Tasks

If your tasks contain multiple documents with prompts, you will have to assign them some values.

In the Global section, you will now find the prompts listed in alphabetical order.

In the sub sections, you will now find the prompts listed as they are defined in the documents.

Example:

prompts-values-tasks

360Suite Web Platform (API)

SQL as a Source for Supported Processors

As well as using an Excel Spreadsheet as a source for processors in the RESTful API, you can now also use SQL statements. Just as you would do in the application!

Compatibility

Issue ID
Description
SAP BI 4.3 SP02 Support for SAP BusinessObjects BI 4.3 SP02
Postgres Support for Postgres 13

Change Logs

Change
Description
Tomcat 360Suite Web Platform is now shipped with Tomcat 9.0.56
Log4j Updated with log4j 2.17

Resolved Issues

Issue ID
Description
P360SUITE-9938 Vers Extension: Error during the computation of the Version number
P360SUITE-9933 No error message for Destination Kind fields in Export Task Processor
P360SUITE-9928 Performance issue with specific kind queries
P360SUITE-9927 Cannot access to checked out object view
P360SUITE-9924 Updating a Watcher does not work properly
P360SUITE-9922 Prompts input are not visible easily
P360SUITE-9921 User properties are not updated
P360SUITE-9920 In some BOBJ version, impossible to send documents into BI Inbox because CeKindEnum cannot be found
P360SUITE-9919 If Crystal prompt is not in use but not marked as optional, it prevents Bind and Cast to properly set the parameter
P360SUITE-9916 Do not update the focused input in filters
P360SUITE-9915 “Add new user” in a group is displaying “Add sub group” instead
P360SUITE-9911 Admin licences users are case sensitive, BOBJ is not
P360SUITE-9907 Copy membership from User shows the Copy membership from Usergroup
P360SUITE-9904 Can’t restore and duplicate documents or universes
P360SUITE-9903 Public Document submenu is not highlighted
P360SUITE-9898 Can’t export BOBJ promotion task iF vers is not activated
P360SUITE-9888 LockAquisitionException on task list due to too greedy task mapping
P360SUITE-9854 Unable to add sub group to root server or user group
P360SUITE-9823 Can’t add Security lock
P360SUITE-9777 Crystal allows to have no Human Readable name on prompts and leads WP to error
P360SUITE-9771 “Open” button appears for users in actors selection and lead to error
P360SUITE-9126 CONCAT function in Excel is not supported when importing an Excel template
P360SUITE-9579 Optimise rollback query for recycled objects

January 31th 2022

360Suite Web Platform 2022.1.1

It’s still early enough in the year to send from all of us at Wiiisdom best wishes and a Happy New Year 2022 🥳!

We are very happy to introduce you to this latest release of 360Suite Web Platform.

Full Documentation: https://support.wiiisdom.com/documentation
Download Site: https://support.wiiisdom.com/downloads

Do get in touch if you need help with updating and please read below for more information regarding what’s new, compatibility and resolved issues.

Support Site: https://support.wiiisdom.com/

See you in a few months for 2022.2 🌻

Take care and stay safe!

New Features

360Suite Web Platform

Modernised Login Screens

We continue to simplify and optimise our user interfaces to enhance the experience.  In this release we worked on Login Screens.

New and Improved Drilldown

Gone is the old and outdated Drilldown and replaced by this new, user-friendly and super fast filter interface.

web-platform-drilldown-release-note

Note: As before, the advanced mode is available for customers of 360View only.

360Bind

Better Handling of Instances

After the document has been refreshed in an export task, we now do the rest of the process in a temporary folder instead of the actual location of the document.

360Live

Webi Sessions: Deactivate Watcher alerts for Active

Just like other watchers, Webi Sessions can also be deactivated.

Webi Sessions: Email Alert to the User Triggering the Alert

You can now email the actual user running a long Webi session!  Simply use the new dynamic placeholder %TUEMAIL.

web-platform-webi-sessions-release-note

360Vers

Keep versioning data when the CMS name changes (Part 1 – Manual)

Currently using 360Vers and planning to move into a new BOBJ Server?

No problem, we can help you keep your versioning data.  In this release it is a manual process so please do get in touch so we can do it with you.

In 2022.2 we aim to have this “repointing” facility available directly in the interface.

360Cast

SQL Destination List Preview Result

Previewing a SQL Destination list now shows you the data in the columns completely rather than truncating the values.

FTP / SFTP Auto create the entire path

Scheduling to a FTP / SFTP location where folders in the path did not exist will create them automatically.  Mirroring the behaviour of the Disk destination.

360Init

This is the final component that wasn’t moved from 360Suite Legacy to the Web Platform.

360Init is a very powerful solution where you can initiate BOBJ projects using a simple Spreadsheet Template.

Scenario: Tomorrow you have a new department, team, retail branch, etc joining and need access to the BOBJ platform.  Instead of creating and administering everything manually which is very time consuming and error prone, now do it directly in Excel!

 

Object Creation:

  • Groups
  • Users
  • Folders
  • Categories
  • Universe Folders
  • Connection Folders
  • Event Folders
  • Access Levels

 

Security Model:

  • Group Matrix
  • Categories Matrix
  • Universe Folder Matrix
  • Connection Folder Matrix
  • BOE Application Matrix
  • Personal Folders Matrix
  • Inboxes Matrix
  • Event Folders Matrix

 

The benefits are huge:

  • Design a structure and security model offline
  • Validate the work to be done before importing the spreadsheet
  • Reuse that design to automatically make it happen in BOBJ
  • Can be also used as documentation, evidence, regulations, audit
  • Easily reuse that template when a new team needs BOBJ access

Not only can you create all this but we offer the ability to perform some updates too!  We have more on the roadmap on that front.  Get in touch with us for a presentation!

See the documentation for more information.

360Suite Web Platform (API)

360Plus: Promotion Processor (Introduction)

Initial features to promote content between environments have been added to the API.

360View: Update Personal Security

You can now use the Update Personal Security Admin Task using the API.

Compatibility

Issue ID
Description
SAP BI 4.3 SP02 Support for SAP BusinessObjects BI 4.3 SP02
Postgres Support for Postgres 13

Change Logs

Change
Description
Tomcat 360Suite Web Platform is now shipped with Tomcat 9.0.56
Log4j Updated with log4j 2.17

Resolved Issues

Issue ID
Description
P360SUITE-9784 NullPointerException when creating Create Enterprise Alias task
P360SUITE-9773 Overwrite by name on documents only also overwrites the parent folder
P360SUITE-9764 Long time to load Cast task with some costy Excel Destination Lists
P360SUITE-9710 Force the WACS URL for Cluster 4.3 BOBJ Installation
P360SUITE-9693 Cannot document differences if the result of a cell is more than >255 char long
P360SUITE-9664 Wrong query for Users in groups
P360SUITE-9654 NullPointerException when restoring from public/private document list
P360SUITE-9643 If owner no longer exists, Cast conversion fail with blocking error
P360SUITE-9639 Bad performance on Cast when we have many destinations
P360SUITE-9630 No suitable driver found when running a Cast Task based on a SQL source
P360SUITE-9611 %R replace special chars even if this is not the file name of a File Destination
P360SUITE-9606 Cannot export universe if technical folder name is translated
P360SUITE-9592 No error when saving the cluster configuration even though there was one
P360SUITE-9589 Promote flagged documents of a folder with hierarchy change to the same CMS keeps them in place
P360SUITE-9581 Bad columns in Users documentation
P360SUITE-9579 Optimise rollback query for recycled objects

December 16th 2021

Change Logs

Description
Contains updates to Log4J 2.16 to mitigate against CVE-2021-44228. We recommend that all our customers install this new release.

November 8th 2021

360Suite Web Platform 2021.4

We are very happy to introduce you to another fully loaded release of 360Suite Web Platform which contains so many awesome innovations.

Many were asked by you!  You do not want to miss it!

Do get in touch if you need help with updating and please read below for more information regarding what’s new and resolved issues.

Hope you had a fun and spooky Halloween 🎃.  Speak after 🎅🎄🤶 for 2022.1!

Take care and stay safe!

New Features

360Suite Web Platform

Modernising the Web Front End (forms)

Many forms have been simplified and optimised to enhance the user experience.

New Navigation and Browsing interface

Earlier this year we introduced the double-click when navigating Resources. (I know right!) This action now opens and displays the actual folder content i.e.: sub folders and documents. A familiar behavior you experience with the Central Management Console.

new-navigation-release-note
New Resources: Public & Personal Documents

Two new Resources sub-menus have been added to ease the process of dealing with individual objects. This was already there for Universes and Connections so it was time to catch up. Another feature you are already used to with the Central Management Console.

new-resources-release-note
New Dynamic Parameters to retrieve SAP BOBJ User’s Emails
  • %EMAILUSER{username}

This dynamic parameter will retrieve the email address of the user saved in the Central Management Console.

 

  • %EMAILGROUP{groupname}

This dynamic parameter will retrieve the email addresses of the users saved in the Central Management Console who are members of this group.

dynamic-parameters-release-note
Notifications: Email Template

We know you like to use our task notifications but there are a lot of fields to fill in and it’s repetitive.  You can now save your most common information in Templates.

You will find the management of Templates in the 360Suite Administration Console under General Preferences:

notifications-email-template-release-note

You then apply the Template under Notifications in your task.

update-task-release-note
Support of BW Events

Added the support of BW Events to wait for in a task.

New installations now with PostgreSQL 12

If you are doing a fresh installation of 360Suite Web Platform, the built-in database is now PostgreSQL 12.

360Cast

New Split Task Process

We have added the ability for 360Cast to automatically split your job in multiple sub processes to reduce the load on your backend systems.  E.g.: SAP BusinessObjects, Databases, BW Sessions, Email Server, CPU, RAM, etc.

Take this scenario: You have a 360Cast job which contains a single Webi document giving the sales results of your retail branches.  As you have 500 branches, you want to send to each branch manager their own version of this document as a PDF, by email and password protected.

The 360Cast job is linked to a Distribution List to split this document into 500 PDFs ready to email.

Without the new Split Task Process option, 360Cast will ask SAP BusinessObjects to go ahead and either do a big refresh and then generate 500 PDFs.  Or refresh 500 times to generate a single PDF each time.  It depends how you configured your job but both will need a lot of resources somewhere.

The previous workaround was to create for example 10 jobs per 50 branches.  This was not always easy and for sure time consuming to create and maintain.

Now 360Cast will do the work for you.  Simply configure your job in this example to split in 10 processes and we will do the rest for you!

update-task-process-release-note

360Bind

Create Export Tasks from Excel

In a previous release we added the ability to fill in the prompts of your 360Bind Export Tasks using an Excel template.  This is much easier and you can even ask the business users to fill in those prompts that you may not know for you.

This release you can create an entire task from an Excel template!

For those of you who like to automate things even further, it wouldn’t be too hard to even script something to generate that template for you!

Pro tip: 360Eyes would help a lot to get the document CUIDs, their prompt names, values, etc.

Today you will import that template manually using the Administration menu.  We could even create an Administration Task to do this automatically at a regular interval.  Let us know what you think!

In the near future our API will be expanded to even take care of that!

export-tasks-excel-release-note

360Live

Watcher Alert Notifications sent to Microsoft Teams (in native mode) now accept attachments.

 

360View

Rename Enterprise Users in Bulk

Here is a good one requested so many times over the years.

You have a user named John Doe.  His account in the Central Management Console is an Enterprise user named as “jdoe”.

You want to move to Active Directory (AD) but over there his account is “john.doe”.

When importing AD users, you would want both accounts to be merged of course so you can keep group memberships, security, personal documents, etc.  The only way this can happen is if both Enterprise and AD users are spelled the same way.

This new Administration action can now simplify and do this in bulk for you.

enterprise-users-release-note
Email Connected Users

Say you plan to restart the server at 6pm tonight because you need to perform some maintenance tasks.  Wouldn’t it be great to email the connected users to let them know and remind them to save their work?

Now you can!  Under the Actors menu (where we have now moved Sessions to) you can Send an email to all connected users.  We will use the email saved with their account in the Central Management Console.

email-connected-users-release-note
email-connected-release-note

And guess what, you can do the same via an Administration Task so you can email these connected users at a point in time or even on a recurring basis.

 

API: More Documentation and Administration Tasks Processors

We are working hard to add more processors into our API.  Have a look at our documentation to find out more.

 

360Plus + 360Vers:

Better Webi and Universe Comparison

The interface has been updated to make it easier and if you happen to have both 360Plus and 360Vers, you can easily switch between the Backups and Versions you want to compare.

webi-universe-release-note

360Vers

Package Documentation Task to Excel now includes “Current Release”

Compatibility

Issue ID
Description
RH EL 8.x Support for Red Hat Enterprise Linux 8.x

Change Logs

Change
Description
PostgreSQL 12 360Suite Web Platform is now shipped with PostgreSQL 12 for new installations

September 28th 2021

360Suite Web Platform 2021.3-1

Resolved Issues

Issue ID
Description
P360SUITE-9339 Inbox documents aren’t promoted when transiting to any file system (basic, FTP, etc.)
P360SUITE-9345 Unable to open a Cast generated inbox document inside the 4.3 “Fiori’ interface

September 10th 2021

360Suite Web Platform 2021.3

We hope you all had a great summer and got the chance to recharge the batteries.

I’m very happy to introduce you to this fully loaded release of 360Suite which contains so many awesome innovations.

Many were asked by you!  You do not want to miss it!

Do get in touch if you need help with updating.

Please read below for more information regarding what’s new and resolved issues.

We hope you enjoy it.  See you just before Christmas for 2021.4 🎅!

Take care and stay safe!

May 11th 2021

360Suite Web Platform 2021.2

Platform

  • It is now possible to log in manually with an SSO configuration
  • Tasks are now sorted by next run time
  • A dynamic parameter is available to integrate error messages into task notifications

360View

  •  Granular rights export is available

360Bind

  • The Conversion tool for Bind Legacy Tasks is available

360Plus

  • Disaster recovery has been improved and now allows synchronization of environments
  • A dynamic parameter allows to send the summary of a backup task in notifications

360Cast

  • Batch processing of destinations is now possible
  • An external URL allows to override global prompts
  • New connection modes are available for SharePoint Online

360Vers

  • It is now possible to add document and universe dependencies in the creation of a package

March 25th 2021

360Suite Web Platform 2021.1

Platform

  • The application is now shipped with AdoptOpenJDK 8 version 275

360Cast

  • The Conversion tool for Cast Legacy Tasks is available
  • The following functionalities are available:
    • Sending incomplete destinations
    • Excel documentation
    • Destinations Selection in the destination filter
    • OpenDocument Links
  • Public Folder as 360Cast destination kind support
  • Webi and Crystal Report For Enterprise as destination list
  • Crystal Reports For Enterprise support

360View

  • CSV Charset is now configurable

360Vers

  • Universe Version is available

360Plus

  • Backup of Events, Profiles and Calendars support

Wiiisdom Ops for Tableau

April 12th 2022

Wiiisdom Ops for Tableau 2022.2

We are very happy to introduce you to this latest release of Wiiisdom Ops for Tableau.

Do get in touch if you need help with updating and please read below for more information regarding what’s new, compatibility updates, change logs and resolved issues.

Full Documentation: https://support.wiiisdom.com/documentation
Download Site: https://support.wiiisdom.com/downloads

Contact us via your Customer Centre and Support Site: https://support.wiiisdom.com/

We hope you enjoy this release.  We are already busy working on 2022.3 in time for the summer 🌞!

Until then, take care and stay safe.

New Features

Open multiple Visualisations in a single Open Viz Task

You now have the ability to open multiple Visualisations in an Open Viz Task.  There are two scenarios where this would be very useful:

1. You want to simply test that your Visualisations are technically working and will open successfully.  You may even want to force the “Refresh data on open” at the same time.

This will validate that the user has a licence, the right permissions, no issues with the architecture (firewalls, Tableau Server, etc), the Viz(s) still exist, and more.

This kind of “monitoring” will make sure that you detect issues before the end users do.  Ensuring user satisfaction, providing trust and improving the adoption of your analytics.

tableau-open-viz-task

2. Test similarly built Visualisations with fewer steps and effort.

Imagine having several visualisations built with the same filters, parameters, charts, etc and you would like to test them all.  Before 2022.2 you would need a Login to Tableau task then an Open Viz for each document and finally every other task you want to run individually.  A long and repetitive process.

Here we have 3x Visualisations each with the same 3x filters.  This test requires 13 steps.

tableau-task-list

From 2022.2, as you can select multiple visualisations in a single Open Viz task, Functional tasks located under that Open Viz task will run as many times as there are visualisations.  Think of a kind of looping process.

tableau-functional-test-open-viz-task

Notifications and tooltips will help you understand the process.

tableau-functional-test-task-properties

The execution of the test proceeds as before.  Although the design of this test consists of only 5 tasks (instead of 13!), the test report will correctly display all 13 executed steps.

💡 Did you know that you can increase the maximum number of Viz URLs you can use in a single test via the “Max selectable views” option in the Settings?

Truncate decimal places value in Assert SQL Equals Tasks

Assert SQL Equals is one of the most popular tasks in Wiiisdom Ops.  It allows you to compare the data in your Tableau Worksheet with data produced by a SQL query.

This is incredibly powerful when you want to make sure the data held in the Tableau Worksheet hasn’t been transformed between there and its original trusted and governed source.

Think of the potential problems that can happen at the Tableau Data Source layer that can lead to returning the wrong information such as:

  • Wrong Relationship between Tables
  • Issue in a Custom SQL Query
  • Hiding the wrong columns
  • Typo in Aliases
  • Wrong formula in a Custom Calculated Field
  • Mistakes with Split & Groups
  • Etc

When creating this task, you previously had to ensure your SQL Query would return the data exactly as it is presented in Tableau.  Sometimes with a lot of decimals.  Which made it difficult to deal with.

tableau-sql-equals-task

In this release you can truncate decimal places and decide how many decimals should be part of your test.  Thanks to this, you can now avoid false negative test results on a value comparison.

tableau-sql-equals-task-decimal

Compatibility

Issue ID
Description
Tableau Support for Tableau 2022.1
Google Chrome Support for Google Chrome 100

Change Logs

Change
Description
Task: Refresh Data Extracts Refresh Data Extracts task no longer has the “URL” target type as an available option.
Tableau Data Extracts (TDE) We are no longer supporting .TDE extracts. They can no longer be imported in a project.

Resolved Issues

Issue ID
Description
WOFT-624 SMTP Password optional in the Designer but mandatory in the CLI
WOFT-594 Assert SQL Equals task fails using an SQL Query with multiple statements
WOFT-564 Unable to run a test on Linux without Java
WOFT-562 Not able to find Java executable error running Performance Tests
WOFT-557 Password may be visible in the debug logs of a Drive Browser task
WOFT-532 Open Viz task transformed to another task
WOFT-519 Adding or deleting a Drive Browser task in a Regression Test deletes the baseline snapshots
WOFT-517 No error popup when a project cannot be opened
WOFT-516 Test execution takes more than 30 minutes on Linux when there’s no internet connection
WOFT-295 The first created context in a new project is not active by default
WOFT-244 Empty screen creating a test in a project without contexts
WOFT-650 Assert CSV Equals tasks failing on Tableau Online 2022.1

February 8th 2022

Wiiisdom Ops for Tableau 2022.1

It’s still early enough in the year to send from all of us at Wiiisdom best wishes and a Happy New Year 2022 🥳!

We are very happy to introduce you to this latest release of Wiiisdom Ops for Tableau.

Full Documentation: https://support.wiiisdom.com/documentation
Download Site: https://support.wiiisdom.com/downloads

Do get in touch if you need help with updating and please read below for more information regarding what’s new, compatibility and resolved issues.

Support Site: https://support.wiiisdom.com/

See you in a few months for 2022.2 🌻

Take care and stay safe!

PS: Please note that you won’t be able to open projects with a previous release after they are opened with a new version of the application. Always make copies of your projects if you plan on using them with your current version.

New Features

Shared Objects Repository: Drive Browser

Those of you using Drive Browser tasks will love this one I’m sure.

Instead of having to create a Drive Browser task manually in each of your tests, you can now save them in a repository and re-use them in any tests in just 2 clicks!

The process is easy:

First: Set the location of your “Shared Elements Directory”.

shared-elements-directory-woft-release-note

Next: Save the Drive Browser task in the repository using “Export to the shared elements directory” button.

export-shared-elements-directory-woft-release-note

Finally: Import a Drive Browser task in your tests in 2 clicks.

The great thing with this feature is that if you modify a shared task, all your tests will use these changes without having to do anything.

If you don’t know what Drive Browsers are.  You can read more about them here.

Task Workflow: Pass / Fail on Task Duration

We have added the ability to determine if a task should Pass or Fail not only based on its functional result but also now based on its duration.

Imagine your Functional Test performs a Login to Tableau, Opening a Viz, Setting Filters and Parameters.  Of course you want to make sure everything is working as planned.  You can now also decide if the tasks should fail if they take too long to run.

In this example, my Open Viz task would fail if it takes more than 2.5 seconds to run.  Even if the viz actually opened.

task-workflow-woft-release-note

Integration with Webhooks

You could already integrate with Slack.  Now integrate with “any” incoming Webhooks that support JSON.  I personally have tested with MS Teams, Google Chat and Jira.  Works great!

integration-webhooks-woft-release-note

Here is a card I created for Google Chat:

card-google-chat-woft-release-note

I’ll soon release a blog giving samples on how to achieve this.

Reduce Time and Clicks to add a Task to a Test

When adding a new task to an existing test, the interface will automatically scroll you down to that task, highlight it and give it a default name.

Rename “Assert Data Equals” to “Assert CSV Equals”

The task Assert Data Equals wasn’t the right label for what it does.  It is now correctly called Assert CSV Equals.

Wiiisdom Ops shipped with JAVA embedded in the product

We are now shipping Wiiisdom Ops for Tableau with JAVA.  This will save you the hassle of managing this yourselves.  If you really prefer instead using your own JAVA 11, of course this is possible.

Significant performance increase when taking a snapshot

When taking a snapshot of your bigger vizzes, you will notice a significant performance increaseYay!

Compatibility

Issue ID
Description
Tableau Support for Tableau 2022.1
Google Chrome Support for Google Chrome 98

Change Logs

Change
Description
Drive Browser Task Due to an update to a library we are using, the function “Submit Form” in a Drive Browser is now deprecated.

You should be using the function “Click” instead.

It is likely that your CSS/xPath for that function will need to be updated. Do get in touch with our support team if you need any assistance.

Resolved Issues

Issue ID
Description
WOFT-199 TimeoutException taking a snapshot when the Tableau site has spaces in its name
WOFT-269 Improve the performances of the Tableau Snapshot retrieval process
WOFT-293 Integration fields losing focus when updated
WOFT-308 Test connection of a context fails for a Tableau Server instance behind a reverse proxy
WOFT-309 Values of date range filters not compared
WOFT-311 Timeout messages during a snapshot are not explicit
WOFT-312 Regression and Cross Environment tests with Drive Browser SSO tasks fail at the login step
WOFT-314 Blank screen when clicking on the Baseline button of a Regression Test
WOFT-389 Login to Tableau task fails at the “Waiting for the right title at …” step
WOFT-399 Improve efficiency of integrations by saving them manually
WOFT-420 Must issue a STARTTLS command first error with Email integration
WOFT-421 Broken thumbnails in Tableau Files list
WOFT-461 Switching Active Context takes a long time
WOFT-483 Compatibility with the new Tableau Online login workflow

December 17th 2021

Change Logs

Description

Contains updates to Log4J 2.16 to mitigate against CVE-2021-44228. We recommend that all our customers install this new release.

Important Note: While updating to mitigate against CVE-2021-44228 we had to update a Tableau library to its latest version which is affecting the Functional Task “Refresh Data Extracts” under certain circumstances.

The Functional Task “Refresh Data Extracts” will not work and be ignored in this release.  Customers who require this task will need to use 2021.4.1 and be on JAVA 11.

This situation will be resolved in 2022.1 scheduled for February 2022.

Do not hesitate contacting the support team if you have questions or need any help: https://support.wiiisdom.com/

December 16th 2021

Change Logs

Description

Contains updates to Log4J 2.16 to mitigate against CVE-2021-44228. We recommend that all our customers install this new release.

Important Note: While updating to mitigate against CVE-2021-44228 we had to update a Tableau library to its latest version which is only supported by JAVA 11.

Customers using JAVA 8 will be required to either:

  • Update to JAVA 11
  • Use Wiiisdom Ops for Tableau 2021.4.2 released on December 17th 2021.  Please read the Release Notes as you will continue to be affected if you use the Functional Task “Refresh Data Extracts”.

Customers already with JAVA 11 are not impacted and should continue to use this release.

Do not hesitate contacting the support team if you have questions or need any help: https://support.wiiisdom.com/

November 8th 2021

Wiiisdom Ops for Tableau 2021.4

We are very happy to introduce you to this latest release of Wiiisdom Ops for Tableau (aka Kinesis-CI).

Do get in touch if you need help with updating and please read below for more information regarding what’s new and resolved issues.

Hope you had a fun and spooky Halloween 🎃.  Speak after 🎅🎄🤶 for 2022.1!

Take care and stay safe!

PS: Please note that you won’t be able to open projects with a previous release after they are opened with a new version of the application. Always make copies of your projects if you plan on using them with your current version.

New Features

Regression Tests: Improve and Simplify the retake of baselines

Performing a Regression Test is the action comparing the actual status of a Tableau View against a baseline of the same Tableau View taken earlier on the same environment.

As your Tableau Views change over time, it is common to refresh your baselines (snapshots) to be ready for your next test.

Previously this was a time consuming task involving a lot of clicks and reselecting already previously selected objects.  This wasn’t optimal to say the least or user friendly.

In this release, we have made a couple of changes which will solve a lot of these problems:

First, the Update selection button now remembers your existing selection.  This will greatly reduce the process of adding / removing views from your selection.Second, we have added the new Refresh snapshots button.  This one click action will refresh all of your snapshots at once.

wiiisdom-ops-tableau-snapshot

Publish to Tableau: Support OAuth Data Sources

Using Wiiisdom Ops you have the ability to Publish your Tableau Workbooks and Data Sources to Tableau Server / Tableau Online.

This is particularly useful when after a long list of functional & regression successful tests you want to automatically publish the objects to the right Tableau Site / Project.

For Tableau Workbooks with an embedded data source and for Tableau Data Sources you already have the ability to update the Credentials for relational database connections.

In this release thanks to popular demand, we have added the support of OAuth database connections such as Google BigQuery and Google Sheets.

wiiisdom-ops-tableau-functional-test-release-note

Simply make sure the users publishing the content have their credentials saved in Tableau for these data sources.

wiiisdom-ops-tableau-snapshot-all-users-release

Compatibility

Description
Support Tableau Server & Tableau Online 2021.4
Support Google Chrome 95 (chromebrowser update)

Note: If you are using an older version of Google Chrome you will have to downgrade your chromedriver in the Kinesis CLI folder. This is a simple copy/paste process, see the documentation or do not hesitate contacting support if you need assistance.

Google Chrome Cookie Handling Issue with Tableau Server:

Google Chrome 94 will no longer allow reverting to pre-Chrome 80 cookie handling behaviour therefore causing issues with the Tableau Javascript API such as using “embedded views”, which Wiiisdom Ops for Tableau relies on.

The only ways to resolve this issue with the Tableau Javascript API and use of “embedded views” is to continue using a pre-Chrome 94 browser or configure Tableau Server to use an SSL certificate and communicate with HTTPS. 

Unfortunately, there is nothing we or Tableau can do to change this behaviour of Google Chrome.

This notice is not applicable for users of Tableau Online.

Here are some useful links around this topic: 

Resolved Issues

Issue ID
Description
WOFT-251 JavaScript error trying to browse the content of a Tableau site with a user that has personal space contents
WOFT-246 Assert Data Rules uses columns without data in its artifact
WOFT-245 Assert Data Rules mixes up the Workbook data
WOFT-242 Task type changes when creating multiple tasks in a Cross Environment Test
WOFT-234 Wrong result message for a Performance Test that fails its availability goal
WOFT-233 Not collected checks are still enabled
WOFT-231 Partial Success in not counted in a test summary in the console
WOFT-230 Empty View name in a test report if the Viz doesn’t exist in the source environment
WOFT-201 Test Runs always equals 11 in Regression/Cross Environment test reports
WOFT-198 Differences found on the following worksheets nil comparing Dashboards that don’t have any common Worksheets
WOFT-196 Unable to view snapshot images when the test has “#” in its name
WOFT-194 Pressing Enter while editing the value of a user defined variable closes the project
WOFT-76 Blank page appears while opening certain modal windows
WOFT-96 Assert SQL Equals task created with the data of the previous task

September 10th 2021

Wiiisdom Ops 2021.3

We hope you all had a great summer and got the chance to recharge the batteries.

Usually I would welcome you to the latest edition of Kinesis CI.  But this time it’s a little bit different.  Following our rebranding, I’m welcoming you to Wiiisdom Ops for Tableau!

After focussing on adding quality in the product we had just acquired with 2021.1 and then working on enhancing existing features in 2021.2, the theme of this release is evolving with new things that you have been requesting.

As always, our goal is to make sure you trust your Tableau analytics thanks to our automated testing solution.

Please read below for more information regarding what’s new, compatibility updates, changelogs and resolved issues.

We hope you enjoy it.  See you just before Christmas for 2021.4 🎅!

Take care and stay safe!

PS: Please note that you won’t be able to open projects with a previous release after they are opened with a new version of the application. Always make copies of your projects if you plan on using them with your current version.

New Features

Cross Environment Tests: Test in Bulk

I’m very happy to announce enhancements and evolutions made to Cross Environment Tests.  Probably the most requested features made by you!

The first enhancement is light but will save you a lot of time.  You now can add more than one Cross Environment Test task in a single test.

If your goal is to do regression testing between objects located on different sites and have different names, you now have the ability to compare these objects in a single test.

cross-environment-test

Pro tip!  Remember that all of our tests are saved in JSON format.  With a bit of scripting experience you can easily dynamically manage your tests and create tasks like these in bulk:

cross-environment-test-json

We also evolved by adding a new task: Multi Site Comparison.  If you have two sites that contain the same projects / contents and want to test a lot of viz in very few clicks, this is the task for you.

Here is an example.  You have Tableau 2021.2 in Production and the goal is to upgrade to 2021.3.  But first you want to test against regressions.

One option used by our customers is to backup a site in Production and then restore it on a different server for example: UAT.  Wiiisdom Ops will do the rest:

Select the entire site, project(s) or view(s):

cross-environment-test-json

The example below will test 189 views:

test-views-wiiisdom-ops

Final step is to choose a Target:

choose-trager-wiiisdom-ops

Voila!

Watch this space.  There is more to come in the future regarding Cross Environment Tests!

 

Write Test Results to a Database

Another big request is about improving the reports of tests you have run.

Currently they are very detailed and informative.  But they are sometimes difficult to share and they cannot be customised.

functional-test-database

We have decided to give you full flexibility on how you chose to document your test results, analyse the results and how to share them.

To do this, we introduce a new integration: PostgreSQL.

Simply configure the new integration:

integration-postgre-sql

And consume the data in Tableau for instance:

data-tableau-instance

Hiding and Encrypting Sensitive User Defined Variables

If you are using Drive Browser tasks, you are likely using User Defined Variables to store your username and password.

It is now possible to encrypt User Defined Variables:

encrypt-user-defined-variables

Assert SQL: Improving the Target Database tab

We have simplified the interface to manage your Database Connections to a minimum to save you time and effort.

Also you will find a Test Connection button to validate everything is configured properly instead of finding out during the test.

manage-database-connections

Note: As always, make sure you have saved your JDBC driver in the right folder.

 

Contexts: Personal Access Token (PAT)

We now support 3rd party authentications to Tableau which are not using the Tableau Identity Provider.

Using Drive Browser SSO and Personal Access Token (PAT) you can now fully use Wiiisdom Ops (Kinesis).

personal-access-token

Dynamic port for the Tableau Canvas web server in the CLI

The CLI should now use a random available port to start the lightweight web server hosting the Tableau Canvas when no static port is provided.

We can use the “0” port: the OS will automatically bind the underlying socket to an available ephemeral port.

The default value for the “–web-port” argument is now ”0” instead of “3000” if not specified.

This will be great for those of you automating your tests for example with Jenkins.  Very useful also for parallel testing!

Compatibility

Description
Support Tableau Server & Tableau Online 2021.3
Support Google Chrome 93 (chromebrowser update)

Note: If you are using an older version of Google Chrome you will have to downgrade your chromedriver in the Kinesis CLI folder. This is a simple copy/paste process, see the documentation or do not hesitate contacting support if you need assistance.

Change Logs

(no change logs in this release)

Resolved Issues

Issue ID
Description
WOFT-94 TimeoutException during a login to Tableau when a Spanish user has access to multiple sites
WOFT-77 Timed out receiving message from renderer severe/warning logs when running tests
WOFT-72 Tests that end up in a Java error are stuck in running
WOFT-71 Project field in the Context disappears when you test the connection
WOFT-70 Deleting a task automatically saves changes
WOFT-63 Cannot open context group error on project field reset
WOFT-60 Large SQL query breaks the Assert SQL Equals task display
WOFT-225 Some UI elements are not accessible when the test description is too long
WOFT-209 Timeout taking a snapshot of Worksheet that only has Summary data
WOFT-205 Unknown View in place of the View name in Cross Environment Test logs
WOFT-197 Timeout taking a snapshot of Worksheet without data or a Dashboard using it
WOFT-193 Integration form reset when opening a new integration
WOFT-181 Regression Test fails checking the summary data of Dashboards without Worksheets
WOFT-135 Projects with data sources are disabled in the Tableau Server Browser popup tree
WOFT-133 Latency creating or deleting a context
WOFT-130 The Used Defined Variables value field loses focus with each key press
WOFT-128 Unable to use user defined context variables in password fields
WOFT-127 Legacy events are still available in the list of excluded events
WOFT-125 Assert Parameter Equals task fails when a boolean parameter is selected
WOFT-122 Tableau Server Browser flattens the folder hierarchy of Tableau sites
WOFT-120 Clear Session event missing from the Performance Test reports
WOFT-119 Invalid Rule Definition error during an Assert Data Rules task
WOFT-117 Publish to Tableau task fails with an Invalid task configuration error
WOFT-204 Warn users trying to launch a quarantined Designer application on MacOS

May 11th 2021

Kinesis 2021.2.1

PS: Please note that you won’t be able to open projects with a previous release after they are opened with a new version of the application. Always make copies of your projects if you plan on using them with your current version.

Compatibility

Description

Support Google Chrome 91 (chromebrowser update)

Note: If you are using an older version of Google Chrome you will have to downgrade your chromedriver in the Kinesis CLI folder. This is a simple copy/paste process, do not hesitate contacting support if you need assistance.

Enhancements & Resolved Issues

Issue ID
Description
KS-296 Resolved an issue where taking a snapshot / opening a Viz on Google Chrome 91 would return a Timeout

April 28th 2021

Kinesis 2021.2

Welcome to the latest edition of Kinesis CI!

A few months ago we released 2021.1, this was our first release since the acquisition of Kinesis CI.  It was all about quality and preparing us for our future ambitious roadmap.  We hope you enjoyed it!

With 2021.2, this time it’s about enhancing existing features you are already enjoying on a daily basis ahead of bigger things this summer in 2021.3.

As always, our goal is to make sure you trust your Tableau analytics thanks to our automated testing solution.

Please read below for more information regarding what’s new, compatibility updates, and changelogs.

Take care and stay safe!

PS: Please note that you won’t be able to open projects with a previous release after they are opened with a new version of the application. Always make copies of your projects if you plan on using them with your current version.

New Features

Opening Kinesis: Full Screen by default

Because we know that’s the first thing you always do!  You’re welcome!

 

Adding a Task: Tooltips and Online Documentation

Scrolling through the list of tasks when creating a test will now display a tooltip providing a brief description of the task and a link to the relevant chapter in the documentation.

tooltip

Functional Tests: Continue on Error

Current behavior: If a single task in a test fails, the test will not continue to the next task and will return a fail status.

You now have the ability to set “Continue on error” on tasks.

This new option is not enabled by default and needs to be enabled manually on each task.

Note that if the result of a test has a mix of Success and Failed tasks, there is now a new status of “Partial Success”.

functional-tests-continue-error

Project Summary: Test Summary

Besides some cosmetic updates and resolving issues with hyperlinks, we have introduced two new columns:

  • Last Run: Sorting the table in descending order
  • Success Rate: (Success + Partial Success) / Number of Tests
project-summary-test-summary

Adding a Context:

add-context

Creating a new Test:

create-task

Feature Usage

We would like to understand how customers use our software and gain insights into where they are successful and where they might run into problems that we can address.

For example, this usage data can help us learn where features are commonly failing and allow us to make product changes to address those issues, or identify what portion of our user base are using specific tests, tasks or features to assist us with our roadmap.

Our hope is that you will accept this feature.

See our Product Usage Data Policy.

You can disable sending this data at installation time, or later. For details on how to do this, see the instructions on our Product Documentation.

Change Logs

Change
Description
JDBC Drivers JDBC drivers for Assert SQL functional tasks are no longer shipped with the Kinesis bundles.

You have to download the required JDBC drivers from the provider’s website and deploy the jar files into $KINESIS_HOME/kinesis-cli/lib directory.

More details and examples in Database Examples section.Existing Assert SQL functional tasks will fail until this is resolved. Do not hesitate to contact support if you need assistance.

Regression Tests: Strings containing multiple spaces We fixed an issue in the 2021.2 release of Kinesis which in some rare cases will cause a Regression Test that was successful in 2021.1 or earlier to now fail when running “Check data summary”.
The report will display data containing multiple spaces when comparing the baseline snapshot against the target.E.g.:check-data-summaryResolution:

  • Open the problematic Regression test(s) in the Designer
  • Click on the “Baseline” button of the “Tableau Viz URL” field
  • Click on the “Retake Snapshot/Retake All Snapshots” button to update the snapshot(s) that will be used as a baseline for this test
  • Save the test

This change is related to Resolved Issue KS-176. For more information, do not hesitate to contact support if you need assistance.

Windows executables Windows executables are now signed to avoid unnecessary warnings

Enhancements & Resolved Issues

Issue ID
Description
KS-249 Task Details display changes when switching tab in Performance test reports
KS-246 Blank page appears when creating a new context while the opened regression test is incomplete
KS-244 Login failed errors running Performance Tests
KS-238 Drive Browser task fails with a timeout connecting to a Tableau Server with a self-signed SSL certificate
KS-179 NullPointerException running a Refresh Data Extracts task
KS-176 Assert SQL Equals task fails when data contains multiple spaces
KS-175 IndexOutOfBoundsException comparing Dashboards with different amount of worksheets
KS-174 Multiple spaces are fused into single spaces in the Kinesis outputs
KS-173 Regression Test fails comparing summary data when columns have special characters
KS-89 Unable to run tests located under a folder with a special character in its name

February 18th 2021

Kinesis 2021.1

PS: Please note that you won’t be able to open projects with a previous release after they are opened with a new version of the application. Always make copies of your projects if you plan on using them with your current version.

Welcome to the latest edition of your favorite automated testing framework for Tableau, Kinesis-CI!

Today is a special moment for all of us at 360Suite as it is the first release since the acquisition of this amazing solution with so much potential.

As you can imagine, going through a process like this involves a lot of work. From the behind scene refactoring you will not see but had to be done. To the technical improvements to make this product future proof and able to handle the roadmap we have in mind.

What’s new in this release?

You may have notice the versioning has changed from the old 1.8.x, 2.x versions to a quarterly numbering. You should expect from us one release every quarter from now on. When appropriate and necessary, we will also release incremental hotfixes.

Our Mac users will be pleased with seeing their solution at parity with the others on Windows and Linux.

Finally, please read below for more information regarding the new features, compatibility updates and changelogs.

Enjoy!

March 11th 2021

Kinesis 2021.1.1

PS: Please note that you won’t be able to open projects with a previous release after they are opened with a new version of the application. Always make copies of your projects if you plan on using them with your current version.

Compatibility

Description
Support Tableau Server & Tableau Online 2021.1
Support Google Chrome 89 (chromebrowser)

Note: If you are using an older version of Google Chrome – E.g. 88 – you will have to downgrade your chromedriver in the Kinesis CLI folder. This is a simple copy/paste process, do not hesitate contacting support if you need assistance.

Enhancements & Resolved Issues

Issue ID
Description
KS-171 Resolved a bug where test statistics were showing the status of the oldest test instead of the most recent one
KS-167 Resolved an bug returning a timeout when taking a snapshot of an empty Dashboard not containing any Worksheets

New Features

Context Creation: Default Values

The creation of contexts introduces new default values:

  • Tableau Server URL*: http://
  • Tableau Version*: [latest supported version of Tableau] – in this release Tableau Server 2020.4
context-creation

Test Reports: Sorting Order

Once a test has run a report is generated by Kinesis summarizing the tasks that have run and if they have passed or failed.

These reports are now sorted in descending order based on the completion date / time.

sorting-order

Cross Environment Regression Test: Source & Target Contexts

One area of Kinesis Designer needing some TLC is the Cross Environment test. The source (formerly the basic tab) environment wasn’t flexible enough and the target screen was repetitive and misleading. In this release we introduce the following enhancements:

New: Source tab

  • Simply select a context from your list of available contexts. Or simply chose to always use whichever is the Active Context.
source

New: Target tab

  • No more typing and misleading behaviors. Again, simply select a context from your list of available contexts. Or simply chose to always use whichever is the Active Context.
target

Warning: These changes introduce new properties in the kinesis.json file of your test. Projects saved in 2021.1 will no longer open in earlier versions. Please take a backup of your projects before using a new version of Kinesis.

 

Email Notifications: Multiple recipients

Email notifications can now be send to multiple recipients by using a comma separator.

E.g.: user1@360suite.io, user2@360suite.io, user3@360suite.io

screen-email

Description Fields: Consistency within Kinesis Designer

The Description field is now a consistently optional field everywhere in Kinesis Designer.

E.g.: Create New Project

description

Debug Window

  • Debug information will now text wrap for easier reading
  • A new and clearly visible vertical scroll bar will appear when necessary
debug

Compatibility

Description
Tableau Server & Online 2020.4
Google Chrome 88 (chromebrowser)

Changelogs

Change
Description
Active Contexts Prior to Kinesis 2021.1, closing a project would reset the active context to the first one in the list. Kinesis will now remember which context was last active when reopening your project. 

Warning: This change introduces a new property in the project.json file. Projects saved in 2021.1 will no longer open in earlier versions. Please take a backup of your projects before using a new version of Kinesis.

In the event where you would want to use a project saved in Kinesis 2021.1 with an earlier version of Kinesis, follow these steps:

  1. Make a copy of project.json for backup purposes
  2. Open project.json in a text editor
  3. Delete the trailing comma on the “contextDir” line
  4. Delete the entire “activeContextGroupKey” line
  5. Save

E.g.:

Kinesis 2021.1

{
“kinesisVersion”: “2.1.0”,
“name”: “Kinesis_Tableau_Server”,
“description”: “Kinesis_Tableau Server”,
“srcDir”: “src”,
“jobDir”: “Kinesis”,
“contextDir”: “context”,
“activeContextGroupKey”: “Tableau_Server_(Prod).json”
}

Pre-Kinesis 2021.1

{
“kinesisVersion”: “2.1.0”,
“name”: “Kinesis_Tableau_Server”,
“description”: “Kinesis_Tableau Server”,
“srcDir”: “src”,
“jobDir”: “Kinesis”,
“contextDir”: “context”
}

Enhancements & Resolved Issues

Issue ID
Description
KS-113 Login to Tableau task fails when Tableau Home page has a custom name
KS-88 Regression Tests failing when SSO is enabled on Tableau
KS-86 Login to Tableau task fails when the user’s Tableau Start Page is the “Explore” page
KS-85 Assert SQL Equals task fails when a worksheet has at least 10 columns
KS-83 License expired” on Invalid Date error message trying to activate a code
KS-66 Remove the unused Role field in Performance Tests
KS-44 Empty filter names in snapshots taken for Tableau 2020.4
KS-42 Unable to run tests with “&” in their names
KS-40 Chromedriver popup ignores the Window Size option when tests are ran in the Designer
KS-30 Timeout taking a snapshot of views without data
KS-28 Cannot connect to Tableau Server using self-signed/internal CA signed SSL certificates
KS-27 ECONNREFUSED error taking a new snapshot
KS-26 Error “The process cannot access the file because it is being used by another process” in a Refresh Data Extracts task
KS-25 Unable to view the content of a Performance Test report in an external browser
KS-24 Password of failed login attempts are visible in the Sample Logs of Performance Tests
KS-23 Unable to save Functional Tests with an Assert Data Rules task using the default values
KS-19 Regression Tests are not reading the URL/Site values from the Context
KS-18 Password in clear text displayed in the logs of a Refresh Data Extract task
KS-16 Publish to Tableau task uploads more than the file size for large Workbooks
KS-14 Exception finding project while running a Refresh Data Extracts task for the Default project
KS-11 Publish to Tableau task fails if the Tableau Project has a space it its name
KS-4 Tableau Server Browser bottom-right Ok button doesn’t do anything
KS-3 Unable to save a Publish to Tableau task in a Functional Test: “Job is not valid”
KS-2 Unable to save a Publish to Tableau task in a Functional Test: “should be equal to one of the allowed values”

360Eyes for SAP BusinessObjects

April 13th 2022

360Eyes for SAP BusinessObjects 2022.2.1

We are very happy to introduce you to this latest release of 360Eyes for BusinessObjects.

Do get in touch if you need help with updating and please read below for more information regarding what’s new, compatibility updates, change logs and resolved issues.

Full Documentation: https://support.wiiisdom.com/documentation
Download Site: https://support.wiiisdom.com/downloads

Contact us via your Customer Centre and Support Site: https://support.wiiisdom.com/

We hope you enjoy this release. We are already busy working on 2022.3 in time for the summer 🌞!

Until then, take care and stay safe.

New Features

Simplification of the .LCMBIAR file

We always want to make our solutions faster to install, configure and use.  In this release we have done much needed updates to the .LCMBIAR which contains the Jobs, Reports and Universes.

eyes-sap-bo-lcmbiar-file
  • Folders have been renamed and others have been deleted
  • Deleted deprecated content
  • Some Jobs and Reports have been moved to more user friendly locations
  • Every Jobs and Reports have a detailed description on what the purpose of that object is, how to use it and where to get further assistance if required
  • COMPLIANCE objects which is licensed differently and in fact a different solution have been removed

 

If you have an existing installation of 360Eyes BOBJ and doing an update, I recommend that you follow these instructions to make sure that you have an up to date folder structures:

  • Make a copy of the following folders: 360eyes jobs, 360eyes reports, 360eyes universes (optional)
  • Delete the existing folders 360eyes jobs, 360eyes reports, 360eyes universes
  • Remove these folders from the Recycle Bin
  • Follow the usual update process

Note: For customers with COMPLIANCE please contact us for further information.

Simplification of the Graphical User Interface (GUI)

Continuing in our effort to simplify the user experience, we have also made changes to the GUI.

eyes-sap-bo-launcher-gui
  • COMPLIANCE V5/V6 is now deprecated and removed completely from the product
  • COMPLIANCE will only be visible if you are correctly licensed for this product

New Extract: Linked Universes (UNV and UNX)

Previously it was only possible to get information about Linked Universes in the UNV format.

It was also not possible to clearly identify the exact Linked Universes in case there were more than one with the same names.

eyes-sap-bo-extract-linked-universes

From 2022.2 you are now able to extract information about Linked Universes in UNX format as well as document the PATH, ID and CUID.

eyes-sap-bo-extract-info-linked-universes

Extract SFTP Destination Information

It is now possible to document via the CMS Universe more information regarding your scheduled jobs with a SFTP destination: Username, Password Set, Target Name, Account, and Fingerprint.

eyes-sap-bo-extract-sftp-destination-information

Access Levels: Extract Rights Information

You now have the ability to document via the CMS Universe more information regarding your Access Levels.

eyes-sap-bo-access-level-extract-rightsinformation

Change Logs

Change
Description
LOCAL job The LOCAL job is now only available via the Graphical User Interface (GUI) and no longer present in the .LCMBIAR
DESKI job The DESKI job is no longer present in the .LCMBIAR.

Although still present in the GUI, it will be removed in 2022.3.

It will remain possible to use it using earlier releases.

Resolved Issues

Issue ID
Description
P360EYES-4201 Resolve an issue where the report 09 Server Properties wasn’t returning any data.
P360EYES-4113 Schedule Destination – Return the value ‘Default’ when the default destination is selected.
P360EYES-4078 Correct Extraction of Webi.Reports
P360EYES-4007 Enhance the management of the errors when getting the size of a corrupted universe
P360EYES-3820 Enhance the SQL Expression Parser to manage recursive objects
P360EYES-3851 REST Mapper – Log off all Sessions created by the Job
P360EYES-4189 java.lang.IllegalArgumentException: businessItem cannot be null
P360EYES-3863 JOB – Manage case insensitive in 360eyes working directory
P360EYES-4050 360Eyes CMS JOB – Correct Folder Security Extraction
P360EYES-3911 CMS Job Error : EyesPreparedStatement.close() failed due to NullPointerException

February 16th 2022

360Eyes for SAP BusinessObjects 2022.1.1

Change Logs

Description
We have made some tweaks and improvements under the hood in this hotfix to make your 360Eyes for SAP BusinessObjects experience even smoother.

January 31th 2022

360Eyes for SAP BusinessObjects 2022.1

It’s still early enough in the year to send from all of us at Wiiisdom best wishes and a Happy New Year 2022 🥳!

We are very happy to introduce you to this latest release of 360Eyes for SAP BusinessObjects.

Full Documentation: https://support.wiiisdom.com/documentation
Download Site: https://support.wiiisdom.com/downloads

Do get in touch if you need help with updating and please read below for more information regarding what’s new, compatibility and resolved issues.

Support Site: https://support.wiiisdom.com/

See you in a few months for 2022.2 🌻

Take care and stay safe!

New Features

Publications

We now extract more information regarding documents in SAP BOBJ Publications:

  • Web Intelligence Prompt Names
  • Web Intelligence Prompt Values
documenting-bobj-publications-release-notes

New Parameter: instance.schedule.status

Thanks to the parameter cms.content you can already opt to extract metadata from SAP BOBJ Instances.  Example:

cms.content = FOLDER,GROUP,USER,CONNECTION,UNIVERSE,OVERLOAD,ACCESSLEVEL,DOCUMENT,INSTANCE,DOCUMENT_PROMPT,APPLICATION,SERVER

This parameter gives you the ability to extract metadata from all your instances.  This is great for instance analysis.

Companies with very large quantities of successful instances (tens of thousands or more) may see it as beneficial to extract instances of a certain status only to improve 360Eyes run time and performance.  After all, is there really a need to frequently extract metadata on old instances?!

It is now possible to extract metadata from BOBJ Instances based on their statuses using this new parameter:

-cms.content.instance.schedule_status=<status>

Examples:

  • -cms.content.instance.schedule_status=RECURRING
  • -cms.content.instance.schedule_status=SUCCESS,ERROR,RUNNING
  • -cms.content.instance.schedule_status=ALL

Compatibility

Issue ID
Description
SAP BI 4.3 SP02 Support for SAP BusinessObjects BI 4.3 SP02

Change Logs

Change
Description
Syntax change with the command line interface (CLI) To allow us to use more recent libraries than the ones available in SAP BusinessObjects, we now have to ensure that the folder containing the 360Eyes libraries comes before the other ones when using the CLI.

E.g.: Before:
java -Xmx1024m -cp ” C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0 /java/lib/*;../libs/*” com.gbs.eyes.Launcher CMS WIN01 Administrator “password” secEnterprise C:/360eyes -replaceMode=ADD

E.g.: After:
java -Xmx1024m -cp “../libs/*;C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/java/lib/*” com.gbs.eyes.Launcher CMS WIN01 Administrator “password” secEnterprise C:/360eyes -replaceMode=ADD

This change of behavior may affect some our customers. Do not hesitate contacting us if you need any assistance.

Note: This is only applicable when running jobs using the CLI, not when using the CMC or the GUI.

Resolved Issues

Issue ID
Description
P360EYES-2775 FolderType and parent_ids_to_exclude unwanted behavior
P360EYES-3819 EYE_UNIVERSE_COL table has column_type equals to NULL
P360EYES-3843 Enhance Rest Service Management – Better control and renew Rest service sessions in case of timeout
P360EYES-3862 Enhance Eyes Working Directory Management
P360EYES-3880 COMPLIANCE job – Manage the empty or null values during the Server Infos Extraction
P360EYES-3889 CMS job is taking a long time on CMS_USER_SESSION extraction

November 8th 2021

360Eyes for SAP BusinessObjects 2021.4

We are very happy to introduce you to this latest release of 360Eyes for SAP BusinessObjects.

Do get in touch if you need help with updating and please read below for more information regarding what’s new and resolved issues.

Hope you had a fun and spooky Halloween 🎃.  Speak after 🎅🎄🤶 for 2022.1!

Take care and stay safe!

New Features

New Parameters

As you can do today using the objects IDs, we have now introduced the ability to include or exclude objects from your jobs using CUIDs.

You can add multiple CUIDs using comma separators.

 

  • -cuids=<CUID>

Extract objects only with specific CUID(s).

 

  • -parent_cuids=<parentCUIDs>

Extract objects only from parent CUID(s).

 

  • -cuids_to_exclude=<CUIDsToExclude>

Exclude from the job objects with specific CUID(s).

 

  • -parent_cuids_to_exclude=<parentCUIDsToExclude>

Exclude from the job objects from specific parent CUID(s).

 

Example:

-cuids=AZKmxuWgAgRJiducy2fqmv0, ASSn7jfNBCFDm12sv3muJwU

Resolved Issues

Issue ID
Description
P360EYES-3799 Errors related to CPU count with the Compliance Jobs
P360EYES-3748 Missing Webi documents in the report
P360EYES-3747 Unused Universe objects not appearing for UNV Universes
P360EYES-3746 IA JOB extract metadata only for 1 year
P360EYES-3791 Wrong description for “Obj Type” information in “360eyes_UNIVERSE”
P360EYES-3789 Error while copying EYE_ERROR table
P360EYES-2788 Universe Objects SQL extraction returns a wrong value for Select
P360EYES-2629 Do not extract OBJ_LOV_* on UNX
P360EYES-2627 Field OBJ_AGGREGATE may be wrong on UNV
P360EYES-3761 Missing Universes in the EYE_Universe_Perspective table
P360EYES-3760 The report 40 shows a used object even if it is not present in the target report
P360EYES-3734 “Object eye ID” is no longer extracted after updating 360eyes
P360EYES-3700 Calculate the number of the future instances
P360EYES-3368 There are errors when running LOCAL job after the release 2020.4
P360EYES-3279 360Eyes does not document linked universes joins within contexts

August 10th 2021

360Eyes for SAP BusinessObjects 2021.3

This release comes with lots of bug fixes and technical enhancements behind the scenes on all 360Eyes jobs.

360Eyes for SAP Data Services

April 13th 2022

360Eyes for SAP Data Services 2022.2

We are very happy to introduce you to this latest release of 360Eyes for SAP Data Services.

Do get in touch if you need help with updating and please read below for more information regarding what’s new, compatibility updates, change logs and resolved issues.

Full Documentation: https://support.wiiisdom.com/documentation
Download Site: https://support.wiiisdom.com/downloads

Contact us via your Customer Centre and Support Site: https://support.wiiisdom.com/

We hope you enjoy this release. We are already busy working on 2022.3 in time for the summer 🌞!

Until then, take care and stay safe.

New Features

Report #105 Compare Snapshots – Display the differences only

We have updated the Report #105 – Compare Snapshots – to include another tab showing the differences only between snapshots as opposed to highlighting them in a long list of other things that are identical.

This will make it faster for you to identify the changes.

sap-data-services-compare-snapshots

Jobs Execution: Two new parameters to limit the extraction

If you have been using SAP Data Services for a long time, it is likely that you have run hundreds if not thousands of jobs over the years.

Running the 360Eyes DS job may take a long time if that’s the case.  To resolve this behaviour we have created two new parameters.

The first one will allow you to decide if you want to extract the Jobs Execution History at all or not.  There will be times where you will only be interested in retrieving the details for your Dataflows for instance.

The other will limit in time the amount of history to extract.  For monitoring purposes, it may not be really valuable to extract more than the last month or a just few months at the time for analysis purposes.

# Extracts the SAP DS Jobs Historical Executions (ON by default/OFF)
# And set the maximum number of last months if the extraction is activated
extractJobsExecutionHistory = ON
extractJobsExecutionHistory.months = 1

Creation of sample command line execution scripts

In your installation directory you will find two new files:

  • 360eyes_DataServices_Run.bat (Windows)
  • 360eyes_DataServices_Run.sh (Linux)

This Windows batch file / Linux script contains working samples of what you need to do to run 360Eyes DS and give you more information on how to get assistance if required.

# Sample property batch file to run 360eyes_dataservices
# 360eyes released by Wiiisdom
# Ensure your 360eyesDS.param is configured before executing this batch file
# For more information and documentation visit our website: https://360eyes.documentation.wiiisdom.com/en_US/dataServices/overview

# This sample command will launch 360eyes_dataservices, create a new snapshot and label it “MyLocalRepo”
java -jar 360EYES_DS_CORE-2022.2.jar . -add -snapshotRepoName=MyLocalRepo

Simplification and Improvements to the default 360eyesDS.param

We continue in our effort to make the solution easier to onboard and use.  We have removed unnecessary complicated and technical entries in the parameter file, added more information, and how to get assistance if required.

# Sample property files containing all parameters to run 360eyes_dataservices
# 360eyes released by Wiiisdom
# For more information and documentation visit our website: https://360eyes.documentation.wiiisdom.com/en_US/dataServices/overview

# Snapshot behavior
#  ADD will add a new snapshot each run
#  REPLACE will replace the previous snapshot
replaceMode = REPLACE

# 360eyes_dataservice database information
# The DB user must be able to CREATE TABLE, INSERT and SELECT
# You must connect the 360eyes_dataservice.UNX universe to this database
DBurl = jdbc:sqlserver://<host>:<port>;databaseName=<database_name>
DBuser = user
DBpass = pw

# DataService Local Repository to scan
# The DB user must be able to SELECT tables and views
DSRepoUrl = jdbc:sqlserver://<host>:<port>;databaseName=<database_name>
DSRepoUser = user
DSRepoPass = pw

# Limit the # of snapshot per type and CMS (OFF by default/ON)
# And set the max value if limitation is activated
snapshot.limit = OFF
snapshot.count.max = 3

# Extracts the SAP DS Jobs Historical Executions (ON by default/OFF)
# And set the maximum number of last months if the extraction is activated
extractJobsExecutionHistory = ON
extractJobsExecutionHistory.months = 1

Visual Improvements made to Snapshots and Prompts in the Universe

The Prompts window in Web Intelligence now only contains the necessary columns that you will actually need and renamed them appropriately to make it more user friendly.

data-services-snapshots-prompts-universe

Change Logs

Change
Description
360EYESDS.key We have updated the way we generate licence keys for this product in 2022.2.

If you are an existing customer or prospect evaluating we have already tried to contact you regarding this.

To use this release you will need a new licence key.  Please contact us if necessary.

360eyesDS.param This release is shipped with an updated and more user friendly parameter file.

If you are an existing customer or prospect evaluating we have already tried to contact you regarding this.

If you need any assistance in moving your existing configuration from pre-2022.2 to post 2022.2, please contact us if necessary.

Resolved Issues

Issue ID
Description
P360EYES-4084 Technical Enhancements
P360EYES-4040 Technical Enhancements

November 8th 2021

360Eyes for SAP Data Services 2021.4

We are very happy to introduce you to this latest release of 360Eyes for SAP Data Services.

This release can extract new metadata which enables us to improve on the already powerful report #104: Content Documentation and introduces us to the new kid on the block, report #105: Compare Dataflows!

Do get in touch if you need help with updating and please read below for more information regarding what’s new and resolved issues.

Hope you had a fun and spooky Halloween 🎃.  Speak after 🎅🎄🤶 for 2022.1!

Take care and stay safe!

New Features

New Metadata Extraction

You now have the ability to extract the following new metadata:

  • Database Datastore Target – Bulk and Option parameters
  • Query Transformation
  • Table Comparison Transformation
  • SQL Transformation

 

Webi #104: Content Documentation

This document has been updated to leverage the new metadata you can extract.

Database Datastore Target – Bulk and Option parameters
database-datastore-target-release-note
Query Transformation
query-transformation-release-note
Table Comparison Transformation
table-comparison-transformation-release-note
SQL Transformation
sql-transformation-release-note

Webi #105: Compare Dataflow

With this report you can compare two extractions of SAP Data Services repositories done over time and compare them for differences.

That way you can track and document changes during development and identify updates that shouldn’t have occurred.

compare-dataflow-release-note

Resolved Issues

This release comes with bug fixes and technical enhancements behind the scenes.

August 10th 2021

360Eyes for SAP Data Services 2021.3

Enhancements to the documentation of each Dataflow

We are now able to extract elements from the Dataflows:

  • Database and Flat Files Sources,
  • Database and Flat Files Targets,
  • Transformations (the following types are extracted Query, Table Comparison, History_Preserving, Hierarchy_Flattening, Merge, Map_Operation, SQL, Validation)

 

A new key-value documentation for some Dataflow sub elements 

We are now able to extract key-value documentation from some content of the Dataflows:

  • Target (Datastore of type Database)
  • Source (Datastore of type Database)

 

New Universe for simpler and more advanced documentation

 

New Web Intelligence sample reports

 

Major performance improvements

 

Support of SAP HANA as a source for SAP Data Services Repositories

📢 Decisive 2022 is coming and you’re invited ⏳

Register for Free

X