All
Accepted answers
Evgeny Shvarov · Nov 9, 2017 go to post

Hi, Vitaly!

Thanks for your input! This is very interesting and totally different approach to solve the task which I like every time about InterSystems technology that problems can be solved with different approaches and you never know how many options even exist )

Evgeny Shvarov · Nov 7, 2017 go to post

So, the final recipe looks like following:

For Insert and Update calculate the hash e.g. with MD5 and put it in Hash property. Index it with not unique index.

Find duplicates with SQL query on Hash where group by for hash shows more than one occurrence.

Loop through all the values with same hash just and check Text property values to be sure that they are duplicates but not hash collisions.

Thanks, Alex, Dmitry, Robert!

Evgeny Shvarov · Nov 6, 2017 go to post

Thanks, Eduard. But I'm looking for duplicates, not for similar records. How can %SIMILARITY help here?

Evgeny Shvarov · Nov 6, 2017 go to post

Thanks, Dmitry. Yes, the focus is - best performance.

But what about the index declaration? There is a limitation of 511 symbols in an index, right?

Should I put that in an index declaration or it will solve it for me automatically if I index an entry with value >511 symbols?

Evgeny Shvarov · Nov 1, 2017 go to post

Hi, Lin!

You are creating this calculated dimensions as shared members. In this case, they are stored in some ^DeepSee.* global.

One of the options to avoid calculated dimensions' storage in the global and further deployment difficulties you can use calculated members with Shared Storage option turned off.

You can alter this option if you create calculated dimension in a named and saved pivot.

In this case, the calculated measure definition will be placed directly in the MDX query of this pivot thus you don't need to deploy it, cause it will live with the pivot.

Evgeny Shvarov · Oct 31, 2017 go to post

Thanks, Eduard!

This is very helpful. 

May I ask, what are the caveats using basic authentication instead of CLP (Caché Login Page)?

Evgeny Shvarov · Oct 30, 2017 go to post

Sergey, thank you for the thorough answer!

Then, in your client app settings 

Do you mean web-app settings like in the following screenshot?

But why not using basic authentication? Can I consider using it?

Evgeny Shvarov · Oct 28, 2017 go to post

Hi, Constantin!

When I search documentation with your online tool what is the version of documentation it works with?

Would you please add the version of the product in the results or somewhere?

Thanks in advance!

Evgeny Shvarov · Oct 28, 2017 go to post

Hi, [@Rubens Silva]!

You mean we shouldn't be shrinking replies?

But how about indent in the discussion tree? I think indent helps to follow the discussion. Thoughts?