All
Accepted answers
Evgeny Shvarov · Mar 31, 2018 go to post

Have no idea, Alessandro.

Just figured out, that there are some extra listings (in addition to those we have in the cube) available for pivots in Analyzer. %Listing only works (for me) with those which are declared in the cube.

You can see (and alter custom listing) if you open Detail Listings section in Analyzer (version 2017.2).

Evgeny Shvarov · Mar 31, 2018 go to post

Hi, Robert!

Thanks for the answer!

Yes, %LISTING this works perfectly with listings declared in the cube definition.

But if you open Analyzer you can see extra "Custom" listings, which are available in the pivot, but not available via %LISTING.

 

Evgeny Shvarov · Mar 28, 2018 go to post

2) It's OK approach for relatively small external source tables because in this case, you need to build the cube for all the records and have no option to update/sync.

If you OK with timings on cube building you are very welcome to use the approach.

If the building time is sensible for the application consider use the approach what @Eduard Lebedyuk already has advised you: import only new records from the external database (hash method, sophisticated query or some other bright idea) and do the cube syncing which will perform faster than cube rebuilding.

Evgeny Shvarov · Mar 22, 2018 go to post

Hi, Max!

I think you have two questions here.

1. how to import data into Caché class from another DBMS.

2. How to update the cube which uses an imported table as a fact table.

About the second question: I believe you can introduce a field in the imported table with a hash-code for the fields of the record and import only new rows so DeepSee Cube update will work automatically in this case. Inviting @Eduard Lebedyuk to describe the technics in details.

Regarding the 1st question - I didn't get your problem, but you can test linked table via SQL Gateway UI  in Control Panel.

Evgeny Shvarov · Mar 18, 2018 go to post

Hi Peter!

Sure, that's why I raised the topic - to gather the best practices of "what works" in production, preferably "for years".

Thanks for sharing your experience. 

BTW, do you want to share your Source Control library on DC someday?

Evgeny Shvarov · Mar 17, 2018 go to post

Hi, Peter!

What situation do you have in mind that could cause the compilation to be unsuccessful?

E.g. compilations using a projection when the result of compilation could be totally unpredictive. 

Also, compilation can be a time-consuming process, comparing to replacing cache.dat file - so it potentially a longer pause in production operation. 

I can't see how deploying/copying the Cache.dat will avoid problems when you have multiple developers or multiple projects on the test server.

I'm not saying that coping cache.dat strategy should be used for a test server. Indeed we can compile the branch on a build/test and then transfer cache.dat to a production if testing goes well.

Evgeny Shvarov · Mar 16, 2018 go to post

Hi, Peter!

I never mentioned deploying cache.dat on a test server. Only for the production site.  Compilation on a test server is OK.

Compilation on a production can be unsuccessful - what do you do in this case?

Evgeny Shvarov · Mar 15, 2018 go to post

Jaqueline!

I guess you have widgets with pivots which include dates in from different cubes/dimensions and want them to be filtered by one control with date dimension. Right?

It's better if you provide the MDX query of at least two of different widgets (better in a new question) and we'll try to find an answer.

Evgeny Shvarov · Mar 15, 2018 go to post

1. Try plaintext editor - it supports markdown.

2. No. If you think we need it - add your issue here?

3.  There is a button in the right corner (highlighted) - it uploads the image into the post/comment in place.

Usually, I need to adjust a width after that. I select it and click the button with an image (see the screenshot). Recommended maximum width is 700px for landscape and 300 for a portrait orientation.

4. Yes, I believe it works in markdown editor. Pinging our DC media manager @Anastasia Dyubaylo to describe how she is doing that.

5. We can introduce better if you know it. Suggest and editor or suggest the requirements to an editor - we will do that.

Evgeny Shvarov · Mar 15, 2018 go to post

Hi, Kevin!

This is useful, thank you. My "default" for development environment is "cuk" which provides int-code for debugging. 

Evgeny Shvarov · Mar 15, 2018 go to post

Hi, Jaqueline!

Could you please share is everything works for you now with filters?

And one more from me as DC Manager - please post only one question in every question in DC ) so for this case, it should be 2 different posts about two different questions) THe reason is that you can have more than one answers which cover different questions. Thanks in advance!

Evgeny Shvarov · Mar 14, 2018 go to post

Hi, Arto!

Sorry for the delay with the reaction on the question, just figured out what you are requesting for. I don't know the direct answer, but can recommend the article and pinging @Maxim Yerokhin to provide more details.

Evgeny Shvarov · Mar 13, 2018 go to post

Just tried the installation on Cache for UNIX (Apple Mac OS X for x86-64) 2017.2 (Build 744U).

Installed in USER. works fine 

 

There is a note in installation:

Note that importing ClassExplorer.WebAppInstaller class will also create a /ClassExplorer application. If you want to create WEB application manually, please, do not import this class. Anyway, importing this class requires %SYS permission.

Maybe you have not enough rights to have everything installed properly? 

Evgeny Shvarov · Mar 8, 2018 go to post

Containers were invented for it. 

The idea is that you have a git repo with docker container in it and a new developer can just checkout the repo and call "docker build" or even "docker up" to get the full prepared environment with one server in a container, two servers for client-server apps, and more for complex solutions.

See @Luca Ravazzolo posts on (one, two) on containers with InterSystems.  Also, see @Eduard Lebedyuk series on continuous delivery with Gitlab , it is a very related topic.