Your settings are all in a file called MSMDSRV.INI which will be located in the location specified in the DataDir property on your AS instance. As for documenting it, it's...

I've had an interesting scenario recently involving SSAS and nested Scope statements in MDX to provide calculation functionality for multiple calendars. I know it's not related to anything on the...

imani_technology (8/17/2016)

---

We are doing some load testing, using 100 XMLA scripts containing MDX queries. We have discovered that not all 100 queries are running concurrently. Is there a...

imani_technology (7/20/2016)

---

Thanks for your help.

I believe the company wants to use CAWA to run Windows batch scripts instead of SQL Agent. It's the same concept as what you're...

The syntax looks okay. What property have you got the expression in?...

What error do you get?

According to page 9 of this document: https://support.ca.com/cadocs/0/CA%20Workload%20Automation%20Agent%20for%20Microsoft%20SQL%20Server%20r11%203%201-ENU/Bookshelf_Files/PDF/WA_Agent_for_Microsoft_SQL_Server_Impl_ENU.pdf

You can start SQL Server Agent jobs. So just set up an agent job which processes your cube(s) and then...

bkaurelien (7/13/2016)

---

I PB_BI

thanks for you reply.

but i don't want to use time intelligence.

when you say i can use scope it is like this

scope([Annee en cours]);

this = StrToMember...

It sounds as if you need to implement time intelligence in your cube. The best (if not the simplest) way of doing this is by using the DateTool dimension methodology,...

lindsayscott23 (7/11/2016)

---

Hi,

I have a requirement to identify reports where a range of values (customer preference codes) have been hard coded.

For reports that use stored procedures this is easy (using...

TheComedian (6/29/2016)

---

I've noticed that since SQL Server 2012, SSAS's focus has been pretty much exclusively into developing tabular mode. My question is: has anything changed significantly for SSAS...

vineet_dubey1975 (6/28/2016)

---

Thanks for being so nice.. i was just downgrade my Enterprise Version Cube to SE Edition ...

Cube processes successfully

1- set semi-additive Aggregation function Sum/Count

2- Created Calculated Members using...

vineet_dubey1975 (6/28/2016)

---

Hi All,

Are there any MDX Functions which are not supported in the SQL Server standard edition ?

Would be great , if i can get a list of those...

Amit Chandra (6/26/2016)

---

Here is the MDX -

SCOPE ([Measures].[YTD Rolling POD Outlet],

[Outlet].[Customer].AllMembers,

[Date].[Fiscal Month].[Fiscal Month].MEMBERS,

[Item].[Brand Category].[Brand Category].MEMBERS,

[Item].[IPL].[IPL].MEMBERS,

[Item].[IPL Familyand Bottle].[IPL Familyand Bottle].MEMBERS

);

...

Amit Chandra (6/25/2016)

---

Sorry for arriving late. I actually got around the problem using resources shared by you. Chris Webb's blog helped. I had to play around with the scope definition...