RonKyle (10/11/2016)

---

Thanks. A blank would be good enough. I know you weren't trying to tie a bow on the "Nope" answer, but a better way in this case...

RonKyle (10/11/2016)

---

What do you mean by unpredictable results if you mix calendar hierarchies? Blank? #ERR? I can't think of a reason these would be mixed either, but...

chris.stuart (10/11/2016)

---

Something I totally forgot to add is that the SSIS packages are stored in a file directory on the server and not in the SQL Server SSIS instance. Maybe...

chris.stuart (10/11/2016)

---

Hi PB_BI

Thanks for the response, at least you have given me some real world suggestions that I can have a look at.

Im not sure how to check the...

chris.stuart (10/7/2016)

---

Hi

I have various packages which checks if a file is in a directory and if found kicks off the rest of the package.

If I run the package in dev...

BlackRabbit (10/10/2016)

---

OK cool, things are starting to move in the right direction 🙂

I have 2 hierarchies in the cube related to the store:

1. Division

- Division ID

...

The issue is that there is no parent-child relationship between [Store ID] (child) and [Division ID] (parent). So when you are saying [Store].[Store ID].CURRENTMEMBER.PARENT what you are returning is [Store].[Store...

BlackRabbit (10/7/2016)

---

Hi! I'm new with this howl MDX thing and cant seem to figure out how to make the following work.

I have a few Calculated measure that calculates a value...

prem.m38 (9/29/2016)

---

Script using for taking backup

<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>

<DatabaseID>Am_Focus</DatabaseID>

</Object>

<File>G:\SSAS Backup\Foc_Re.abf</File>

<AllowOverwrite>true</AllowOverwrite>

<ApplyCompression>false</ApplyCompression>

</Backup>

My SSAS DB daily backup failing with below...

Personally I think DAX is the one of the two which is syntactically more coherent with its subject. That is, unlike MDX, Microsoft haven't tried to make it look like...

PB_BI (9/26/2016)

---

No. https://msdn.microsoft.com/en-us/library/hh212940.aspx

You can directly query Tabular cubes with...

No. https://msdn.microsoft.com/en-us/library/hh212940.aspx

You can directly query Tabular cubes with both...

imani_technology (9/22/2016)

---

Is there a quick way to determine the number of rows in a Tabular table from SSMS? I'm wondering if there is something similar to when you right-click...

Brad Allison (9/22/2016)

---

thanks for the response. I actually think it was the table that I was querying against as it stored millions of records. I changed to a...

Brad Allison (9/20/2016)

---

I am running a stored proc from EXEC in a ado.net source and getting the following error: "[ADO NET Source [49]] Error: System.Data.SqlClient.SqlException: Timeout expired. The timeout...