Evgeny Shvarov · Jun 22, 2016 go to post

Hi, Rob! It would be better if you post the whole text of the solution here in Developer Community, instead of supplying the link only. I think this is the better approach to engage the discussion. 

Evgeny Shvarov · Jun 21, 2016 go to post

Copy-paste the current index from the previous post and add a new link to the previous post?

Evgeny Shvarov · Jun 15, 2016 go to post

Yes. But what if Debug Target is not a Class method or Routine?

In that case you can use locks or hang as Fabio suggested to catch the line and the moment and attach to the process with Studio.

Evgeny Shvarov · Jun 15, 2016 go to post

I think the problem is that you use calculated measure for the measure with the same name - f.e. count.

To solve this introduce the measure for Count with another name, f.e. CubeACount and use calculated measure to use this measure in the expression.

Hope it helps.

Evgeny Shvarov · Jun 14, 2016 go to post

I believe it should just work. Place CubeB.TotalClients in pivot based on CubeC and you'll get the CubeB.TotalClients for the facts in CubeB only.

The idea of compound cubes is that you get pivot table with  different measures from different fact tables sliced by same shared dimension. 

Evgeny Shvarov · Jun 14, 2016 go to post

It's not very clear. You want to use CubeB.TotalClients  in CubeC compound cube?

What this measure should show in CubeC?

Evgeny Shvarov · Jun 8, 2016 go to post

Very nice Alexander!

Will it work only for time dimensions with the help of %Timerange or I can use the similar approach for any type of dimensions?

Evgeny Shvarov · Jun 6, 2016 go to post

One more solution from Russian forum:

ClassMethod gluconatV2(xAs %String ProcedureBlock = 1 ]
{
 y="" i=1:1:$l(x){c=$e(x,i),a=$a(c)-97-(c]"r")-(c]"y"),z=c]" ",d=a\3+2*s:d=$e(y,*) y=y_" " j=0:1:a#3+("sz"[c)*y=y_dy
}

And one "extremum" version:

ClassMethod ToPhone( t, "(t){s s="" f i=1:1:$l(t) {f N=0:1:3 s n=$f(""adgjmptw "",$c($a($e(t,i))-N)) s:n n=n#10,s=s_$e("" "",s_-1[(n_-1))_$e(n_n_n_n,1,N+1),N=9} q s}"As %String CodeMode = expression ]
{
$xecute(a,t)
}
Evgeny Shvarov · Jun 3, 2016 go to post

Hi, Asaf!

Yes, you are right - Compound Cubes!

In any case, I believe that giving the option (in Architect and Studio), to mark a date dimension to include all dates (or a range of years), would be a good enhancement to DeepSee.

That would be great!

Evgeny Shvarov · Jun 2, 2016 go to post

Good news, thanks!

My question was because importing smth to %SYS needs temporary write permission to CACHELIB database to be turned on and everything installed in %SYS will be erased with the next Caché update.

Evgeny Shvarov · May 31, 2016 go to post

One more variant from Russian forum:

p(t)
{
R="" %=1:1:$l(tN=0:1:3 n=$f("adgjmptw ",$c($a($e(t,%))-N)) s:n n=n#10,R=R_$e(" ",$e(R,*)=n)_$e(n*1111,1,N+1),N=9 
}

132 symbols.

Evgeny Shvarov · May 31, 2016 go to post

Thank you for this great tool, Tony!

One question: is it possible instead of importing into %SYS, import to OTHERNAMESPACE and map the package to %All?

Evgeny Shvarov · May 30, 2016 go to post

Hi, Joe!

Thanks for the article!

Is it possible to use one Listing Group for several cubes?

Evgeny Shvarov · May 30, 2016 go to post

Personally, I think looking at different ways of doing the same thing are a great learning lesson.  Judging based on the length of the code, simply encourages bad programming.

Agreed. So I think is good to provide two versions: readable and the shortest.

Evgeny Shvarov · May 30, 2016 go to post

And would you please provide "readable" version too just to see the algorithm better? TIA!

Evgeny Shvarov · May 30, 2016 go to post

Alexander Koblov, thank you for such interesting problem for the Contest Final. Your variant? ;)

Evgeny Shvarov · May 25, 2016 go to post

I've added couple updates to the dashboard - so it now supports click filter for the counties too. Click on the county to see it's data in the indicator widget on the right.