Posts by Evgeny Shvarov on InterSystems Developer Community

Question

Evgeny Shvarov · Jul 27, 2016

Add Tag Tips&Tricks discussion

Hi, Community!

We want to introduce tag Tips & tricks.

It's not a snippet sometimes, but some small piece of best practice and useful experience.

Please vote if you think it makes sense and we need this tag and we'll introduce it as the first level tag in taxonomy.

#DC Feedback

4 1

0 147

Question

Evgeny Shvarov · Jul 8, 2016

Top from the group SQL query in Caché

Hi!
There is interesting question in Stackoverflow.
This query works for MS SQL:

SELECT * 
FROM 
(
    SELECT *, ROW_NUMBER() OVER (PARTITION BY client_id ORDER BY date_updated DESC) AS rn
    FROM client_address
) a
WHERE a.rn = 1

There is one answer there, which solves the task:

#SQL #Caché

2 5

0 2.2K

Question

Evgeny Shvarov · Jun 23, 2016

How to extract the root in Caché properly

Hi!

Here is the question in Russian Forum regarding roots extracting.

In Caché ObjectScript we use exponentiation operator (**) to raise an exponent to power. F.e. let's raise 3 to power of 3:

USER> write 3**3 

27

And we use the same operator to extract the root.

USER> write 27**(1/3) 

2.999999999999999963

And 2.999999999999999963 is not 3, obviously.

How to extract roots properly in Caché ObjectScript?

#Caché #ObjectScript

0 5

0 388

Question

Evgeny Shvarov · May 30, 2016

Solution for T9 Spelling Problem in Caché ObjectScript

Hi, Community!

Last weekend we held the Final of InterSystems Contest on Caché, DeepSee and iKnow under the aegis of IT Planet Student Championship in Ekaterinburg. BTW, this year we had more than 1,400 participants in InterSystems Contest.

#Caché #ObjectScript

3 20

0 1.2K

Question

Evgeny Shvarov · May 12, 2016

Full series of dates in Time Dimensions in DeepSee

Hi!

Sometimes, especially when I work with Combined Cubes, I need to have all the dates in Date Dimension, not only members with rows in Fact table.

Is there any way to switch it on?

#InterSystems IRIS BI (DeepSee)

1 6

0 322

Question

Evgeny Shvarov · Apr 24, 2016

Import/export data from InterSystems Caché

Hi!

Suppose I have full access to Caché database instance A and want to export consistent part of the data and import it into another Caché instance B. Classes are equal.

What are the most general and convenient options for me?

TIA!

#Databases #Data Import and Export #Object Data Model #Caché

0 11

0 6.8K

Question

Evgeny Shvarov · Apr 16, 2016

Atelier project hidden files. What should I commit?

Hi!

In every Atelier project you can find following hidden files:

.buildpath

.version

.connection

.project.

Should I include all of them into commit?

I understand that .project is mandatory. But what about the rest? Is there any general rule?

F.e. if we work in team and everybody has their own connection on locale machine .connection should not be included. Yes?

1 1

0 364

Question

Evgeny Shvarov · Apr 5, 2016

How to avoid writing duplicate code in dtl InterSystems Ensemble

Hi!

There is a question for Ensemble on Stackoverflow:

I have the below dtl. In the foreach loop, I am just copying the same code in another part under anif condition. How can I avoid this redundancy? Can I reuse using sub transformation?

Here is the dtl class file :https://docs.google.com/document/d/1snJXElyw13hAfb8Lmg5IaySc7md_DE8J40FB79hBaXU/edit?usp=sharing

#Ensemble

1 2

0 552

Question

Evgeny Shvarov · Mar 31, 2016

Running total without %CELL

Hi!

There is an example in Samples which shows how to implement 'running total' measure: "Pareto Chart for Category" dashboard.

To calculate running total this pivot uses calculated measure with %Cell expression:

Measures.[Revenue as Percent of Total] + %CELL(0,-1)