All
Accepted answers
Evgeny Shvarov · Jan 10, 2017 go to post

You are right. Maybe we cannot cook Drupal properly yet. But the site is getting (slowly) better.

Evgeny Shvarov · Jan 9, 2017 go to post

Hi, Samual! 

Would you please send a piece of your MDX which has a bad performance.

Alessandro's example is very general.  In many cases you can reach the same result without PERIODSTODATE and PARALLELPERIOD functions and any %OR statements.  E.g. to make the Year-to-Year(YTY) monthly comparison you can just use the following (Holefoods Sample Cube):

SELECT [Measures].[Amount Sold] ON 0,NON EMPTY {[DateOfSale].[Actual].[MonthSold].&[201612],[DateOfSale].[Actual].[MonthSold].&[201512]} ON 1 FROM [HOLEFOODS]

Which shouldn't cause any performance issues for any number of rows.

If you want to parametrize the month with pivot variable the expression for YTY for any month could look like the following (assuming the $variable.month is a list of months):

SELECT [Measures].[Amount Sold] ON 0,NON EMPTY {[DateOfSale].[Actual].[MonthSold].&[$variable.month],PARALLELPERIOD([DateOfSale].[Actual].[YearSold],1,
[DateOfSale].[Actual].[MonthSold].&[$variable.month])} ON 1 FROM [HOLEFOODS]

HTH

Evgeny Shvarov · Jan 9, 2017 go to post

It turns out that it is yet another setting! (Oh, Drupal...).

So, there is Subscription->Overview->Settings->Visibility of Controls section which controls the visibility of Update and Comment settings in "Content types" tab. Don't ask me whoever needs this setting, so if you make it Visible you can find this settings in "Content types" for Posts and Answers.

We plan to turn on this Visibility of Controls thing for all the members with the next DC release.

Evgeny Shvarov · Jan 9, 2017 go to post

Hi, John!

I see you have digest mode turned on. Please turn it off to get reasonable notifications.

Regarding your question - I bring my apologies. This checkbox will influence only the new future subscriptions (as it documented in this settings section).

So if you were subscribed to the post you have this setting already and it cannot be unchecked or unsubscribe and subscribe again.

Maybe it's not a bad idea to turn off this "notifications on updates" setting for all the current subscriptions for all the users.

Evgeny Shvarov · Jan 9, 2017 go to post

Thanks, Jiri!

The search feature works not very effective, to be honest. We plan to fix it, hopefully, next month.

Evgeny Shvarov · Jan 6, 2017 go to post

We are working on it.

This feature will appear in the next DC release, hope in January.

Evgeny Shvarov · Jan 6, 2017 go to post

Hi, John!

That's strange.

Try to check on Overview/Preferences section as I posted in Pete's comment?

Evgeny Shvarov · Jan 6, 2017 go to post

Hi Pete!

For you I would suggest please turn off the Digest mode! It sends broken messages now.

And for the question about updates - I have another user on DC it has this "On Updates" settings on Overview-> Preferences section:

Evgeny Shvarov · Jan 5, 2017 go to post

And you was notified, cause I changed the type of the post from "Unknown" to "Question".

Evgeny Shvarov · Jan 5, 2017 go to post

So, here is TOP-20 Articles of the year. To see the rest of them open this DeepSee Analytics link and click on the header to sort the posts for Views, Comments, and Votes. And open the desired article.

Like it is shown here:

Evgeny Shvarov · Jan 5, 2017 go to post

Hi, Tani! 

Very good snippet! Would you, please upload the sample to the Github repo?

Thank you in advance!

Evgeny Shvarov · Jan 5, 2017 go to post

Hi, Scott!

You got this message because somebody changed the post.

Two things about that:

First turn off please the Digest mode - it doesn't work properly and sends senseless messages :/

Second: turn off the Update trigger for notifications. The checkboxes should be off as on the screenshot:

 

 

 

After that you'll get reasonable notifications and only for the reasonable causes. 

Evgeny Shvarov · Dec 30, 2016 go to post

Off-topic: tried now google who is mister "Roger Kovalev" and found this article on DC in top-10 results :)

Evgeny Shvarov · Dec 30, 2016 go to post

Hi, Joel!

Thanks for the nice sample! Would you please upload the code to a Github repo too to let it be forked and pull-requested?

Thanks!

Evgeny Shvarov · Dec 26, 2016 go to post

Ed!

Consider you have another Github repo in which you want to use REST Forms repo. What is the best way to achieve this?

Evgeny Shvarov · Dec 26, 2016 go to post

Download and import from latest release on release page 20161.xml (for Caché 2016.1) or 201162.xml (for Caché 2016.2+) into any namespace

If you have 2016.2+ Forms would not be compiled,  $-methods should be renamed.
You can do it with the following:

Import and compile in NameSpace classes from SystemMethodsRemover 

Run in terminal:

And it works.

Or if you have CacheUpdater installed, import and compile from the Github repo can be reached with this one command:

d ##class(CacheUpdater.Task).Update("intersystems-ru","SystemMethodsRemover")