March 2020

Feed a Dynamic Query with a Batch Macro

Yay! I learned to build batch macros this week! I’ve wanted to tackle batch macros for quite some time but I didn’t have any use cases. This week two use cases popped up. In my first use case, I feed a dynamic query with a batch macro. More specifically, I feed a list of wells into the dynamic query. I’ll show you how to do this in blog and video. Read on to learn more.

Read More »Feed a Dynamic Query with a Batch Macro

Resolve Data Function Errors When Upgrading Spotfire

Despite all of the current chaos, we are getting ready to upgrade our Spotfire installation. I’m a bit sad we are only going from 10.2 to 10.3, but 10.3 is the last LTS version. In performing testing in our dev environment, we ran into errors with data functions using packages. This post will explain how to resolve the error — ‘xyx package’ was built by an R engine with different internals. Read on to learn how to resolve data function errors when upgrading Spotfire.

Read More »Resolve Data Function Errors When Upgrading Spotfire

Join Logging Data Sets

This has been a busy, busy week. I’ve never posted an article a day before. I kicked off the week with my first post on Spotfire logging. I explained how to set up and configure logging, as well as install logging information links and a DXP with logging data. My second post explained how to interpret the data in the ACTIONLOG information link. The third post explained log categories and actions so that in the fourth post you could understand how to use all the other logging views. This is the final post of the week, which wraps everything up. It will explain how to join logging data sets to get exactly the logging data you need. Read on to find out more.

Read More »Join Logging Data Sets

Spotfire Logging Categories and Actions

Welcome to my Wednesday logging post, number 3 of 5 this week. The first post explained how to set up your Spotfire installation to log user actions. The second post detailed the questions you can ask and answer using the ACTIONLOG. This post sets the stage to understand all of the other logging views by taking a closer look at the LOG_CATEGORY and LOG_ACTION columns. With a good understanding of these categories, you’ll be able to use even more of the log data. Read on to learn more.

Read More »Spotfire Logging Categories and Actions

How to Use the Spotfire ACTIONLOG

Yesterday, I posted on how to set up logging in Spotfire. At the end of that post, I showed you just how much data is available with logging, and it’s a lot. But, there is one place you can go to answer most logging question — the ACTIONLOG view. So, in this post, I will explain how to use the Spotfire ACTIONLOG data to understand user activity. We’ll ask and answer important questions like…

  • Is usage increasing or decreasing?
  • Is training helping users?
  • Who isn’t using their license?
  • Who are my top users?
  • What are the most commonly used files?
  • Who deleted my information link?

Read on to learn more.

Read More »How to Use the Spotfire ACTIONLOG

How to Set Up Spotfire Logging

Last week, my manager asked the question — “Is anything connected to xyz information link?” So, I showed users how to answer that question with a simple search in the Library Administrator. This week, I was asked — “Who isn’t using their license?” This is also a fairly simple question to answer if you have logging setup and understand the maze of views containing logging data. While I felt like I had a pretty solid understanding of logging, I didn’t understand all the data I was seeing. So, I had to reach out to TIBCO for clarity. Ultimately, I wound up going down a very deep rabbit hole learning even more about logging. Since there isn’t much out there on logging, I distilled it all into 5 blog posts that will be released one at a time Monday thru Friday. This post kicks it off by explaining how to set up Spotfire logging. Read on to learn more.

Read More »How to Set Up Spotfire Logging

How to Search for DXP Dependencies

I can’t tell you how many times my manager has asked me — “How many projects connect to the <insert name> information link? While this might seem like a difficult question to answer, the information is just a few clicks away in the Library Administrator. The key is knowing how to search for it. If you don’t know how to search for it, maybe you have relied on the terrifying-yet-effective method of clicking delete in the Information Designer and waiting for Spotfire to tell you what the info link is connected to. Rather than be afraid you are about to break something, let me show you how to use the Library Administrator to search for DXP dependencies. Read on to learn more.

Read More »How to Search for DXP Dependencies

Use Find Replace Tools to Simplify Regex

On Monday, I said I would share two Alteryx tips and tricks learned from coworkers. The first tip was from Alice Yu, who showed me that it’s possible to use the In operator in Alteryx Filter tools. The second tip comes from Jack Stewart, who is replacing Alice on our Analytics team. Jack helped me out on a particularly sticky regex problem. I wanted to showcase his solution because it shows how to use Find and Replace tools to simplify regex. Anytime I can make regex simpler, I am all for it. Read on to learn more.

Read More »Use Find Replace Tools to Simplify Regex

Using the ‘In’ Operator in Alteryx Filter Tools

I promise to resume my Spotfire expression series, but… This week, I will showcase 2 Alteryx tips and tricks I learned from coworkers last week. The first will be a salute and fond farewell to my teammate Alice Yu who is leaving the company. I am very sad to see Alice depart, as she is the light of our team and an all-around good and fun human. The second will be a warm welcome to Jack Stewart who is moving from our Geo team to the Analytics team. I can already tell that Jack approaches problems very differently from me, so I expect to learn a lot from him. So, with that said, here is what I learned from Alice….

Read More »Using the ‘In’ Operator in Alteryx Filter Tools