New post

#Listings

2

Listing is a SQL query for the data in a fact table of a cube that is relevant to the current slice. 

See Documentation.

Hello,

We have a tranformation where we would like to convert a date from the following format:

"'dd/mm/yyyy' 'hh:mm'" (double quotes are just visual to indicate this is a string)

to date and time separated:

date: dd/mm/yyyy

time: hh:mm

We have already splitted the datetime into date and hour as follows:

0 1
0 250
Question
David Satorres · Aug 7, 2018
Speeding up $listget

Hi,

I'm trying to find the faster way to get the data from a class, and I find it very slow compared to traditional globals. So, I hope some of you can bring some light to me :-)

I have thousands of registers in a class, and to access it quickly I'm going with $o at the index. From there, I get the values using $listget(). Something like that:

0 10
0 510

Hi all,

We faced a problem where we would like to map a $lb object to its corresponding data model structure in order to later on export it as JSON.

So imagin that we have something like this that actually maps to a persistent table with its structure. 

$lb("",,,,,"",,,"BOOLEAN","0",2,2,"1",,"bla",$lb(,,"bla","20050502123400"),"",1,"bla",,0)

Is there a way to transform this $lb (without the need of openig the object itself) to a JSON object with the proper table fields as properties?

Many thanks

0 9
0 353
Article
Joe Gallant · May 28, 2016 3m read
DeepSee Listing Groups

This article is about DeepSee Listing Groups, a new DeepSee feature that was introduced in release 2015.2.

DeepSee Listings have always been a part of DeepSee. DeepSee Listing Groups provide increased flexibility by allowing you to create new DeepSee Listings without modifying the cube definition.

3 3
0 257