All
Accepted answers
Evgeny Shvarov · Aug 3, 2017 go to post

Thanks, Daniel!

So %Resultset vs %SQL.Statement can perform 4-7x faster in some cases? Did I understand properly?

It would be fantastic if we have some speed test coming with our Samples database classes which would show any win in performance.

Evgeny Shvarov · Jul 29, 2017 go to post

I think in your case of migrating MS SQL cube to DeepSee cube means building the whole BI solution in DeepSee from the scratch. 

I mean:

1. ETL the data from MS SQL into Caché fact tables (Caché classes).

2. Build DeepSee cube(or cubes) against the fact tables.

3. Introduce pivot tables with MDX-queries against DeepSee cube (cubes).

4. Make dashboards to provide the UI for this pivot tables.

Profit!

Evgeny Shvarov · Jul 28, 2017 go to post

Hi, Razvan!

I doubt that it is possible at the moment.

Caché has DeepSee embedded technology to build BI solutions.

What exactly do you want to do? Move BI Solution from SQLServer to Caché?

Evgeny Shvarov · Jul 25, 2017 go to post

Hi, Sebastien!

If Robert's answer solves your problem, would you please mark it as an accepted? See the details.

Thank you in advance!

Evgeny Shvarov · Jul 20, 2017 go to post

Hi, Mike!

What is a dedicated playlist?

If we have series of video related to one topic we put them in playlists.

Today we have following playlists on DC YouTube channel:

InterSystems: Who We Are - videos which describe our corporate code, who we are, what we do and what matters.

InterSystems iKnow - videos describing InterSystems iKnow technology which helps to build solutions by managing unstructured data.

Atelier - videos, related to InterSystems IDE Atelier.

Global Summit 2016 - videos from last year Global Summit sessions.

Community Projects - videos related to some community projects and solutions presentations. BTW, if you want to describe your solution, tool or a framework in a video we would love to upload it on DC channel in this playlist.

Also, are the video available on a plain hyperlink?

Sure.  E.g. here is the link: Many Data Sources - One Application.

Evgeny Shvarov · Jul 18, 2017 go to post

Hi, Lexi! 

Thanks for sharing that! 

Do you have any performance tests how much %SQL.Statement faster than %Resultset?

Evgeny Shvarov · Jul 18, 2017 go to post

Hi, Benjamin!

Am I able to deploy Aviation demo in a namespace other than Samples? What should I do to make it happen?

Evgeny Shvarov · Jul 17, 2017 go to post

Hi, Russel!

You can always use $name for any operations with  global name, either simple as ^G or with subscripts as "^G(1,"something").

It is intended for this.

In your case it would look like:

set x=$Name(^G)

or you can set global name with subscript, e.g.:

Set x=$Name(^G(1,"second"))

It's very convenient to use indirection operator @ in this case to deal with variable with global name inside.

E.g. you can refer to any subscript with global inside x, like this:

set @x@(1)=2

which would be equal to:

set ^G(1,"second",1)=2

And with your $Order example you can have:

USER> set x=$Na(^G(1,"second"))
USER> set @x@(1)=2
USER> set y=$O(@x@(""))
USER> write y
1

HTH

Evgeny Shvarov · Jul 15, 2017 go to post

Why do you want CSP files to be exported? Why not take them from /csp/ folder as files and put directly to the repo as is?

Evgeny Shvarov · Jul 8, 2017 go to post

If you are looking for the projects with Caché ObjectScript with sources in UDL you can find it with cacheobjectscript-udl topic on Github. 

And if you have some open projects on Github with sources in UDL please mark it with cacheobjectscript-udl topic? Thank you in advance!