Creating a measure for a database SQL statement in V4

Question

Question by James M. · Nov 11, 2011 at 12:14 AM ·

Creating a measure for a database SQL statement in V4

We would like to allow users to right-mouse click on a database query (from the Databases dashlet) and subscribe to a query measure from that screen. I thought we could do that in V3.5.2, but for some reason the menu choice doesn't appear for me in V4. We could do it directly by going into the profile, but that isn't as convenient.

What am I missing?

1

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 1 · 2012-03-23T19:54:34Z

Answer by Rajesh J. · Mar 23, 2012 at 07:54 PM

On the topic of Database Query Measures, can I create a measure on a Query Parameter. For example If I have a query parameter as Account No and I want to group transactions by Account No, can I do it?

1 Show 1 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Andreas G. ♦ · Mar 23, 2012 at 08:35 PM 1

Share

Hi Rajesh

A Measure on SQL bind values is currently not supported. You can only create measures based on the SQL Statement

Andi

Answer 2 · 2011-11-22T23:06:08Z

Answer by Pankaj K. · Nov 22, 2011 at 11:06 PM

As a workaround, from the database dashlet, drill into purepaths that execute that database query. Then select the execution, right click and then select "Subscribe Measures"

1 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 3 · 2011-11-11T18:22:16Z

Answer by Andreas G. · Nov 11, 2011 at 06:22 PM

Hi James

As we have totally rewritten the Database Dashlet it seems that this option has been removed in V4. I've created a RFE to get this functionality back as it really seems like a good shortcut

Andi

1 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Creating a measure for a database SQL statement in V4

3 Replies

How to get started

NAM 2019 SP5 is available

LIVE WEBINAR

Follow this Question

Forum Tags