Evgeny Shvarov · Feb 6, 2017 go to post

Hi, Timur!

How to add the project to the community package manager?

What are the requirements for the project to be listed in CPM?

Evgeny Shvarov · Feb 3, 2017 go to post

I think it's not a problem, but nice use of Caché namespaces and package mapping feature.

Evgeny Shvarov · Feb 3, 2017 go to post

Here is the list of packages currently available:

CPM:CPM>> list

   bdeboe~isc-iknow-dictbuilder 0.0.1-a  Demo application for data-driven modelling, building or refining a dictionary through exploratory analysis of text using InterSystems' iKnow technology

   bdeboe~isc-iknow-explorer    0.0.1-a  

   bdeboe~isc-iknow-extractor   0.0.1-a  Information Extraction demo app based on InterSystems' iKnow technology

   bdeboe~isc-iknow-ifindportal 0.0.1-a  A Search Portal demo app for iFind, part of InterSystems' iKnow technology

   bdeboe~isc-iknow-rulesbuilder0.0.1-a  Demo application to build rule patterns based on sequences of terms to be matched, based on InterSystems' iKnow technology

   bdeboe~isc-iknow-setanalysis 0.0.1-a  Set Analysis Demo app for InterSystems' iKnow technology

   eduard93~Cache-FileServer    0.0.1-a  Seed for sharing files via uid with InterSystems Cache

   eduard93~Cache-MDX2JSON      2.2.0-b  RESTful web api for MDX to JSON transformation (plus JSONP and XML/A) for InterSystems Caché. Also provides information about DeepSee objexts. 

   intersystems-ru~CacheGitHubCI0.6.0-a  InterSystems Caché and GitHub Continous Integration

   intersystems-ru~EnsembleWorkflow0.0.1-a Restful web API for InterSystems Ensemble Workflow

   intersystems-ru~EnsembleWorkflowUI0.0.1-a Angular UI for InterSystems Ensemble Workflow

   intersystems-ru~REST         0.8.0-a  Basic classes for REST web API on InterSystems Cache

   intersystems-ru~iknowSocial  0.0.1-a  iKnow implementation approach for social networks (vkontakte, facebook and twitter)

   intersystems-ru~monlbl-viewer0.0.1-a  MONLBL Viewer - a web UI for inspecting Caché Monitor (%MONLBL) results.

   intersystems-ru~webterminal  4.1.3    The first and the most powerful web-based terminal for InterSystems Caché®, Ensemble®, HealthShare®, TrakCare® and other products built on top of InterSystems Caché.

   tsafin~cache-map-reduce      0.0.1-a  Simple Map-Reduce interface implementation for Caché ObjectScript

   tsafin~cache-zerocopy-tree   0.0.1-a  Experiment to create multidimensional tree with zero-copy capabilties

How do you know the version of the Package?

How should I be confident that the version of the package is really true?

Evgeny Shvarov · Feb 3, 2017 go to post

2nd: Some Cache -opensource tools have serious bugs(e.g. the cache class explorer destroys on 2016.1. the creation of soap-clients in studio) . Therefore it must be checked that all used 3rd-party-libs doesnt destroy something.

Hi, Steffen! What do you mean by "destroys"?  Would you please put the issue regarding this? Every software has bugs, not only open source community tools.

For the community tools, I prefer the practice to install every other tool in special Namespace, to be sure it will not harm my projects. And we can use the %All Namespace to let the tool be visible from other Namespaces.

If I want to deinstall the tool I just delete the Namespace.

Evgeny Shvarov · Feb 3, 2017 go to post

Hi, Raghuram!

Sorry for the disturbing messages.

You are receiving everything because of the default subscription settings to get any DC content notifications. 

Please adjust your subscription settings as it shown here.

Evgeny Shvarov · Jan 30, 2017 go to post

Hi, Scott!

There is no such possibility at this moment, but we have it in a queue.

Evgeny Shvarov · Jan 24, 2017 go to post

Hi, Mike! Thanks for the comment, but it is so long that makes it quite unreadable. 

Please consider to post the class's code with gist (how to) for the long listing like here, or see the DC code formatting for the smaller pieces.

Evgeny Shvarov · Jan 24, 2017 go to post

Michael thanks! It works for nonsliced data. But if I include dimensions on the rows it shows percentages which doesn't include Online dimension:

The MDX expression:

SELECT NON EMPTY {NONEMPTYCROSSJOIN([Channel].[H1].[Channel Name].&[2],{[Measures].[Amount Sold],%LABEL([MEASURES].[PCTMICHAEL],"","#%")}),[Measures].[Amount Sold]} ON 0,NON EMPTY [Outlet].[H1].[Region].Members ON 1 FROM [HOLEFOODS]

I mean, what should I do if I want to see 100% for Pct in Total row? 

Evgeny Shvarov · Jan 24, 2017 go to post

Hi, Natasa!

If Alexander's answer fits the question for you would you please mark it as "Accepted"?

Thank you in advance!

Evgeny Shvarov · Jan 21, 2017 go to post

IMHO it should be a tag for every article.

If there is no tag which fits the article let's introduce the tag?

Evgeny Shvarov · Jan 20, 2017 go to post

Wow, that's great! I should check it!

BTW, maybe one day the break command will work too? I mean as it works as a debugger in usual terminal?

Evgeny Shvarov · Jan 12, 2017 go to post

True. We just will reproduce Stackoverflow approach here: "No answers" - for the questions without any answer, and "Unanswered" for without accepted answer.

Evgeny Shvarov · Jan 11, 2017 go to post

Update for Questions' list with the Authors' links and introduced few new questions in Most commented list.

Evgeny Shvarov · Jan 10, 2017 go to post

That is the question. I think there should be two filters: unanswered and ... "True answered".

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.