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

BTW, when you download Atelier installer first time on a clean machine (Mac OS 10.12.6) and run it tells that it needs java and JRE 6.0 to make Atelier work. Which is not true obviously. Can it be fixed?

Evgeny Shvarov · Aug 11, 2017 go to post

Thank you, John! You helped a lot! ) DC would work better (from Google point of view :).

We have browser notifications on the new postings. Would it solve the issue for you?

Evgeny Shvarov · Aug 10, 2017 go to post

Hi, John!

Yes, it is done on purpose. We are working on better SEO for DC and this is part of the work. It is called by google as circular link - the link on the page which directs on itself. Google "doesn't like it". 

I got used to clicking on it too. So it is still clickable on other than home page, but doesn't work on home page.

Reload can work? Ctrl+R on Chrome?

Evgeny Shvarov · Aug 10, 2017 go to post

I've just introduced new tag Indexing to tag this and other related questions and articles. Thanks Uri for the interesting question.

Evgeny Shvarov · Aug 8, 2017 go to post

With DO you can pass parameters into method or procedure/function and get the result back, with GOTO you can't. 

Evgeny Shvarov · Aug 7, 2017 go to post

Right.

But if your method does something meaningful.

E.g. what about the method which checks, if a class exists, like in another neighboring post:

ClassMethod ClassExists(ClassName as %String) as %Boolean {

return ##class(%Dictionary.CompiledClass).%ExistsId(ClassName)

}

Why would you need %Status here?

Evgeny Shvarov · Aug 7, 2017 go to post

Thanks, Dan! Cool stuff!

Never knew about .prepare() and .execute() and my +1 vote for .next() to introduce.

One more general question: is it a good practice to embrace everything in a method in try/catch?

Consider I have some method which interacts with UI and it has try/catch in it and it catches everything it calls. Let's name it UpperUIMethod. But should I introduce try/catch in every methods I'm calling from this UpperUIMethod? 

Sometimes I want to avoid it to give more sense to the logic itself.

Evgeny Shvarov · Aug 7, 2017 go to post

Hi, Dan! Thanks!

Maybe you have a similar general snippet for %SQL.Statement usage?

Evgeny Shvarov · Aug 4, 2017 go to post

Hi, community!

Unfortunately, there would be no InterSystems Developers Meetup on 8th of August!

The meetup postponed and shortly I will post about the new date and time.

Hope you'll join the next meetup too!

Evgeny Shvarov · Aug 3, 2017 go to post

Hi, Kevin!

Actually, we are working to make the search better at the very moment.

Today you can use the google search option we added to retrieve the reasonable search result - see the related post.

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!