Peter Steiwer · Jul 28, 2016 go to post

Great tip Evgeny!

Because of this reason, I like to create a new hierarchy to contain my week level. This will allow me to keep a single time dimension that uses my date property as the source, but separating the hierarchies will allow my Year->Month->Day structure to be preserved.

Peter Steiwer · Oct 14, 2016 go to post

This documentation page describes the use of { } within MDX. As Lexi points out, a single member inside of { } should behave the same way without the { }. This is the syntax for a set. If you come across something that is not working as expected without the { }, please consider submitting a WRC so we can get the behavior resolved.

Peter Steiwer · Nov 21, 2016 go to post

As Daniel suggests, the class should extend %DeepSee.Time.AbstractLevel to be visible from Architect

Peter Steiwer · Nov 21, 2016 go to post

Some interesting things to note:

If you DO NOT put your custom class in the %DeepSee.Time package, it will not be visible through the Architect UI. Even if you do not include it in the %DeepSee.Time package, you will be able to modify your cube definition from Studio and specify your custom class. For example, I created the following class:

      Class User.CustomTime1 Extends %DeepSee.Time.AbstractLevel

 

This custom class IS NOT visible in the Architect's "Extract value with function" drop down. However, I created a level with the following timeFunction value in my cube class from Studio:

      timefunction="CustomTime1"

 

Manually entering this value will work and your custom time functions will be able to survive upgrades. If you do include your class in %DeepSee.Time, it will be listed in the Architect UI

Peter Steiwer · Dec 7, 2016 go to post

Ah yes, creating some new dimension, for example, called "IsDifferent" and having values of 0 or 1 would definitely work. If this dimension makes sense within your cube, then it would be OK to add (for performance and simplicity reasons). If the case presents itself where you have another two dimensions you need to compare, you will need to add "IsDifferent2". This pattern may repeat based on the use case.

It would be possible to create a PlugIn that takes dimension names as parameters, which would allow you to dynamically compare values without needing to pre-define all of your combinations.

Peter Steiwer · Dec 11, 2016 go to post

I am occasionally logged out, I do not know how frequently though. Maybe once or twice per week?

Peter Steiwer · Dec 12, 2016 go to post

For the programmatic purpose of comparing two instances of the same object (I was hoping to keep the use case separate from this post in order to get a good generic example of iterating through properties of an object - but I can go into more details if needed).

Peter Steiwer · Dec 14, 2016 go to post

I got the same results for this specific course. Did you submit anything through the learning site? On the bottom of the "About" page, there is a contact section for feedback/questions. I can submit this if you have not already

Peter Steiwer · Dec 14, 2016 go to post

Ok, I have reported it to the learning services team to take a look at. If I receive any updates, I will let everyone know here

Peter Steiwer · Mar 7, 2017 go to post

In Architect, if you select a Dimension, there will be a checkbox that says "Enable the All level for this dimension "

Peter Steiwer · May 5, 2017 go to post

List levels can be confusing because as defined, a single fact can have multiple members. This means that you may see counts higher than the total number of facts in your cube. This can be quite the surprise if you are not expecting it.

Based on the complexity of these types of levels, I would not suggest using them in dimensions with other levels. There may be a particular case where you need this, but I think it would be much safer and a lot more easy to understand if the other levels were placed in different dimensions.

Peter Steiwer · Sep 6, 2017 go to post

I am a big fan of doing this. It helps find the correct instance fast and helps prevent spending time debugging the wrong instance on accident!

Peter Steiwer · Dec 8, 2017 go to post

I was planning on sharing my code at the end of the event, I think it is more fair that way

Peter Steiwer · Dec 15, 2017 go to post
11   00:08:01     90     11   01:55:04   1458      0

Had to take a break between these two, but barely top 100 on the first - the second part was quite easy so if I hadn't taken a break, maybe I would have been able to get top 100 again

Peter Steiwer · Dec 19, 2017 go to post

I just did mine state based, while one needed to wait, just flipped the state to the other

Peter Steiwer · Jan 17, 2018 go to post

That is not the question. The question is about being able to configure Caché cube for example to link to the HTTPS pages, which it can not

Peter Steiwer · Jan 17, 2018 go to post

Very cool, this should definitely help. Another good reason to contact the WRC :)

Peter Steiwer · Jan 23, 2018 go to post

I just tried adding your element to ZENDemo.Home.cls SAMPLE page, and it worked just fine. I added it after the element with id "description"

Perhaps include a picture of what you are seeing?

Peter Steiwer · Jan 24, 2018 go to post

Brace always for me too, unless I am writing some quick debugging code or something along those lines

Peter Steiwer · Apr 7, 2018 go to post

Have you tested this and seen it work? I tried this before posting the question and it does not appear to work for me

Peter Steiwer · Apr 7, 2018 go to post

Thanks for the input on this. I have considered these negative consequences as you describe. I am pulling my data from REST services, so it would be perfectly fine for me to delete all my data if need be. Perhaps once the early phases of development are finished these diffs will become less active and not a problem.

The second reason is that I have been developing on both Caché 2017.2 and InterSystems IRIS. The storage definition changes slightly based on which one I am using, so it creates a little bit of noise, but it is ultimately manageable. Perhaps doing development across products is not recommended, so that could also be the answer

Peter Steiwer · Jun 19, 2019 go to post

Thank you for this quick reference table (and for my *looks up amount of points for comments* 30 points!)