All
Accepted answers
Evgeny Shvarov · Nov 1, 2017 go to post

Hi, Lin!

You are creating this calculated dimensions as shared members. In this case, they are stored in some ^DeepSee.* global.

One of the options to avoid calculated dimensions' storage in the global and further deployment difficulties you can use calculated members with Shared Storage option turned off.

You can alter this option if you create calculated dimension in a named and saved pivot.

In this case, the calculated measure definition will be placed directly in the MDX query of this pivot thus you don't need to deploy it, cause it will live with the pivot.

Evgeny Shvarov · Oct 31, 2017 go to post

Thanks, Eduard!

This is very helpful. 

May I ask, what are the caveats using basic authentication instead of CLP (Caché Login Page)?

Evgeny Shvarov · Oct 30, 2017 go to post

Sergey, thank you for the thorough answer!

Then, in your client app settings 

Do you mean web-app settings like in the following screenshot?

But why not using basic authentication? Can I consider using it?

Evgeny Shvarov · Oct 28, 2017 go to post

Hi, Constantin!

When I search documentation with your online tool what is the version of documentation it works with?

Would you please add the version of the product in the results or somewhere?

Thanks in advance!

Evgeny Shvarov · Oct 28, 2017 go to post

Hi, [@Rubens Silva]!

You mean we shouldn't be shrinking replies?

But how about indent in the discussion tree? I think indent helps to follow the discussion. Thoughts?

Evgeny Shvarov · Oct 25, 2017 go to post

Got it now.

Steve, you can introduce your own data hierarchy build with expressions on this property which will have levels:

Year, Month, Day, hour  (or minute).

And thus with LASTCHILD on Day level you can get the last member of the day.

Evgeny Shvarov · Oct 24, 2017 go to post

Hi, Thomas!

It's a great idea! Do you want to provide a description for the group?

Evgeny Shvarov · Oct 23, 2017 go to post

Steve, but it does for me exactly what you are describing.

WITH  MEMBER [DateOfSale].[LastDayOfMonthRevenue] AS 'AGGREGATE([DateOfSale].[Actual].[MonthSold].CurrentMember.LASTCHILD,MEASURES.[Amount Sold ])' 

This will show last child member which has value in the next level of hierarchy. And with AGGREGATE you can alter the Measure you want to show up.

Hope [@Alessandro Marin] can provide more info.

Evgeny Shvarov · Oct 19, 2017 go to post

One week left for the meetup! Come to discuss Sharding - the new feature which comes with InterSystems IRIS, High Availability and Atelier with InterSystems Developers and Product Managers. See you in Cambridge!