BusinessObjects Board

Freehand SQL but with a prompt/parameter?

other Lumira / Visual Intelligence
#1

Hi Folks,
Is it possible at all to use freehand sql and have a prompt or pass a parameter?
At the moment I’m connecting to a view in SQL Server and it’s bringing back many thousands of records. If I could pass a parameter to the query then I could reduce this to a handful of records instead.

Also, is there any decent training available for Lumira? I watched a video recently that claimed to be official, but had the sound of drilling in the background.

Thanks!

BatCat :uk: (BOB member since 2004-05-18)

#2

Drilling, ace :stuck_out_tongue:

Dont think you can parameterise Lumira queries, but dont be scared to bring back the whole set of data (unless its mental), the in memory database is quite good. Ive had it dealing with 1.6 million rows ok, managed to kill it with 25 million though…

If your in Lumira desktop, hav a look in the Lumira.ini file, there`s an Xmx setting that lets you increase the amount of memory it can consume.

I`m wondering if a stored procedure might work actually…off to try it!

ABILtd :uk: (BOB member since 2006-02-08)

#3

Bit of a long shot but Tableau works quite well with table functions for this sort of thing. Might be worth looking at something analogous.

Damocles :uk: (BOB member since 2006-10-05)

#4

Thanks folks!
Believe me, I’d much rather use Tableau!

BatCat :uk: (BOB member since 2004-05-18)