Hi, All!
What is the calculated measure expression for the percentage of a member?
Say in Holefoods I want to see in a Cols Online sales in Revenue, All the revenue and % of Online sales for the Revenue?
I have the following:
With expression:
SELECT NON EMPTY {NONEMPTYCROSSJOIN([Channel].[H1].[Channel Name].&[2],[Measures].[Amount Sold]),[Measures].[Amount Sold]} ON 0 FROM [HOLEFOODS]How can I add the percentage of All in Revenue for Online channel?
Hi, Community!
Over 600 different authors posted anything on Developer Community in 2016.
Developer Community contains some brilliant pieces of content because of you. Thank you!
With one of the latest DC releases we introduced "Member Follow" functionality, so you can open any members' page, follow him and be subscribed to all his new posts and comments.
Just to give you ideas who to follow in 2017 here is top 10 authors in 2016 for several nominations ;)
All the nominations do not include postings within Developer Community tag or group.
Top 10 Contributors
Authors who posted the most articles
Hi, Community!
We are fixing groups, tags and message types for the several last year's postings.
So that's why you are getting "strange" notifications now with no any new comment.
As a result, you'll get better tagging and for the DC articles and questions.
Anyway, you can turn off the "OnUpdate" notifications as it is described here.
Hi Community!
In this release we turned off the digest mode for all the members (until it would be fixed) and fixed the Update notifications: now this settings can be found in the same place for all the members: Subscriptions/Content types tab.
Meet in this small release the new very valuable feature: marking answers as "true" answers.
If you are an author of the question now you can choose the right answer if there are more than one and mark it with the green checkbox. Like it is shown here:
If there are more than one answer, the "true" one will be shown topmost.
The question for the Community:
Hi!
I want to optimize the cube and delete the measure. Is there any easy way to find pivots which use it?
Does anyone have any snippet regarding this?
Would be great to have "out of the box" dashboards which will show the dependencies of pivots vs measures and dimensions.
Hi!
Today DC supports the notifications for the posts' updates. It means if someone changes the post text, title, group or tag you can be notified about that.
But this notifications just inform that there were updates, but do not show what exactly was changed in the post.
So through this, you can get the notifications for the posts from previous years without any reason what's happened.
I would suggest to turn off this types of notifications until we'll implement the details in notifications, what exactly was changed in the post and why did you get it.
To turn off the update notifications go to
Hi, Community!
You published 499 articles regarding InterSystems technology in 2016.
Here are the most noticed and interesting articles of the year.
Introducing new JSON capabilities in Caché 2016.1, by Stefan Wittmann 2478
InterSystems Data Platforms and Performance Part 4 - Looking at Memory , by Murray Oldfield 1598
Writing better-performing loops in Caché ObjectScript, by Timothy Leavitt 1509
InterSystems Example Reference Architecture for Microsoft Azure Resource Manager (ARM), by Mark Bolinsky 1468
Class Queries in InterSystems Caché, by Eduard Lebedyuk 1441
Hi, Community!
We have 2017 year on the calendar, so it's time to look back on 2016 and find some highlights.
Here is the set of Top-20 questions regarding InterSystems technology you posted in 2016.
Most viewed
Anyone using Visual Studio Code?, by John Murray 1062
Import/export data from InterSystems Caché, by Evgeny Shvarov 942
How can I pass multiple parameters to an Ensemble REST service and return an authorization token as a response JSON message, by Joshua Goldman 917
How to install and configure Atelier?, by Ronaldo Nascimento 793
Hi, Community!
Please see the digest of Articles and Questions published in December 2016.
Most viewed
Declarative development in Caché 383
RESTForms - REST API for your classes 267
Licensing: Ubuntu and SUSE with 2017.1 and later 259
Merry XMas :) 250
Platform Compatibility: HP Open VMS 177
InterSystems Technologies on Amazon EC2: Reference Architecture 174
Atelier, The Productivity Boost Tool 170
InterSystems Developer Community Birthday! 167
Most voted
First, register to make postings.
Here is the short gif which demonstrates how to post, paste text from Word, make COS highlighting and put Group and tag.
Here it is:
Hi, community!
Consider you need to exclude substring(s) from a string.
I did it with the following snippet:
/// excludes all the substrings from the string
ClassMethod ExcludeSubstring(substr,str as %String) As %String
{
while ($L(str,substr)>1) {
set str=$Piece(str,substr)_$Piece(str,substr,2,*)
}
quit str
}So, for example:
USER> set str=”ExcludemeGoodstringExcludemeExcludemeGoodstring” w ##class(User.Utils).ExcludeSubstring(“Excludeme”,str) GoodstringGoodstring
Is this the optimal approach or I reinvented the wheel?
Hi, Community!
We have our internal backup system which produces *.cbk files for Full, Incremental and Cumulative backup modes.
Does anyone have an automation procedure to restore this files on some target testing system, check the integrity and mark the files as "restorable"?
Please, share?
Thank you in advance!
Hi, Community!
We just introduced the Tools tag to mark the articles where you are describing, announcing, promoting the Tools for development in InterSystems Caché.
Hi, Community!
Today, the 7th of December is the very good day - today is InterSystems Developer Community birthday!
Hi!
We updated the DC a bit.
Member's answers
With this release, you can see the answers on the member's page too.
E.g. see the answers by Timothy Leavitt.
Post updates don't move the post to top
So we can fix the tags, spelling and make other updates to the post and it would not be moved to top anymore.
Now only new answers and comments move the post to the top of the feed.
RSS and other bug fixes
Now bugs for RSS feeds are fixed.
Also, Votes renamed to Rating and has the color indication now. Green means good!
Stay tuned for the next DC improvements!
Hi, Community!
Here is the digest of Articles and Questions published on InterSystems Developer Community in November 2016.
Most viewed
Caché and Ensemble 2017.1 field test now available 212
Importance and Collection of Exact Version Information ($zv / $zversion) 162
How do you iterate through SQL in Cache ObjectScript; and across namespaces? 129
Connect Cache client to GT.M database 128
Round to next whole number 128
How to work out the cause of a STORE error 121
Caché Localization Manager or i18N in InterSystems Caché 118
Hi!
We want to introduce the tag for the posts which describe the tools for the developers. How about #DevTools?
Your ideas?
Does anyone have a snippet to create the Namespace and database with defaults in one command?
Something like:
do ##class(Utils.Namespace).Create(Name)Please share?
Thank you in advance!
Hi!
Is there any way to export a class package to xml file programmatically which will include all the classes of the package?
Hi, Community!
We introduced the monthly digest a few months ago.
Now it consists of articles and questions by tags in the post and only articles in your email.
Do you like it?
How can we make it better?
Should we do it weekly?
Hi, Community!
Let me introduce Dmitry Maslennikov as our new Developer Community Moderator.
Dmitry continuously shows the outstanding contribution to InterSystems Developer Community and we decided to trust Dmitry this role and hope that Dmitry can even help to make the Developer Community better in this new status.
Thanks for your great contribution, Dmitry!
And, we are looking for the new moderators from Community!
InterSystems Developer Community is growing! 
Hi, Community!
Here is the digest of Articles and Questions published on InterSystems Developer Community in October 2016.
Most viewed
Internal Structure of Caché Database Blocks, Part 1 407
Caché and Ensemble 2016.2.0 Release 306
How to execute terminal commands from a webpage 214
How to Parse a URL in Caché 196
Internal Structure of Caché Database Blocks, Part 3 191
Tips & Tricks - SQL to Excel 188
Internal Structure of Caché Database Blocks, Part 2 184
Data Platforms and Performance - Part 7 ECP for performance, scalability and availability 180
Lines of Code 147
Hi, Community!
We deployed the new update on DC and it brings:
The new post subscriptions/favorites model:
with every post you now see the star in the left bottom corner of the widget in the feed or of the post.
Click on it and it turns to yellow which means that you store it in your "Favorites" tab which you can find later in your member's page like it is shown in my one.
Also, that means you automatically subscribed to email notifications on all the changes in this post.
Click it again to unfavorite/unsubscribe the article.
The
There is an interesting discussion in the Russian forum going.
What is the best solution for the function which returns the max for the set of parameters?
From the listed solutions I like this one:
ClassMethod max(args...) {
for i=1:1:args { s max(+$g(args(i))) = i }
s i="", max=$o(max(i),-1, i) Q $lb(max, i)
}Hi, Community!
This place is getting bigger and today we reached 2.000 of registered members on InterSystems Developer Community!
Recently we introduced online analytics (build on InterSystems DeepSee) of main figures regarding Developer Community.
You can find the analytics in the menu Community->Analytics:
So you can click on the dashboards and cells and drill down to the daily posts, tags or examine the current leaderboard of the most active and helpful members.
Thanks for your participation and contribution!
Hi, Community!
We put in production the new DC update today. With this update we fixed some bugs, like publishing drafts with proper date and RSS fix and introduced the new look to the member page.
Now member's page consists of Posts, Comments, and Favorites: e.g. this is the page of Alexander Koblov:
With this update you can see all the contributions and interests of your favorite author on DC.
Hope you like it!
Next weeks we prepare some new good updates! Stay tuned!
Hi, Community!
I'm glad to announce UK Technology Summit 2016 started!
#ISCTech2016 tag will help be in touch with all is happening in the Summit.
You are very welcome to discuss the Summit here in comments too!
Hi, Community!
Here is the digest of Articles and Questions published on InterSystems Developer Community in September 2016.
Most viewed
Mirroring 101: a brief guide and FAQ - 238
NewBie's Corner Session 27 Traversing A Global with $Order Part 1 - 214
Cache for Raspberry Pi? - 209
Free Text Search: The Way To Search Your Text Fields That SQL Developers Are Hiding From You!* - 199
REST in Pieces - 196
User authentication using Arduino with RFID - 146
Windows 7 performs shutdown too fast for Cache to close and so it gets forced down - 143
Cache or Caché? - 141
NewBie's Corner Session 28 Various Methods to Traverse a Global - 134
Cache Certification - 128
Most voted
Ensemble and file outbound adapters - a small hint - 11
Free Text Search: The Way To Search Your Text Fields That SQL Developers Are Hiding From You!* - 9
Advanced URL mapping for REST - 6
Windows 7 performs shutdown too fast for Cache to close and so it gets forced down - 6
Featured InterSystems Video: OAuth 2.0 Overview - 6
The Art of Mapping Globals to Classes (2 of 3) - 5
Running HealthShare XSLTs from Terminal - 5
Cache or Caché? - 5
Most commented
NewBie's Corner Session 27 Traversing A Global with $Order Part 1 - 16
question on ExternalFreeze on windows platform -- - 14
Cache or Caché? - 12
Mirroring 101: a brief guide and FAQ - 10
Windows 7 performs shutdown too fast for Cache to close and so it gets forced down - 9
Multiple namespaces in web application - 8
cleaning up CSP sessions (aka where/who/what is the %CSP.Daemon?) - 8
NewBie's Corner Session 28 Various Methods to Traverse a Global - 8
Free Text Search: The Way To Search Your Text Fields That SQL Developers Are Hiding From You!* - 7
Hi, Community!
We want to introduce tag for the posts, which are related to the newbies.
What is the best tag for it?
Newbie's corner?
Newbie?
Beginner?
Your option?
Hi, Community!
I've introduced new "Developer Community FAQ" tag, which gathers all the posts on "How to make this on Developer Community".
Also, you can find this link in the Learn menu. See the screenshot:
