Viewing 15 posts - 391 through 405 (of 893 total)
Description: Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was being used: Conversion overflows.. End Error
I've highlighted what I think to be...
September 7, 2015 at 1:52 pm
Are you looking at the data in Excel, or did you write an MDX query? It is possible to only show certain levels within that hierarchy, but it's not clear...
September 3, 2015 at 7:42 pm
The developers would not need access to the SSAS Instances.
The one exception to this is with a tabular instance. When developing tabular models, you need access to a "workspace", i.e....
September 3, 2015 at 5:32 pm
In my opinion, your DBA's comments are premature. The two technologies (Multidimensional and Tabular) are very different. In order to make the best decision, it will be important to know...
September 3, 2015 at 5:21 pm
In theory, it would be possible to take the results of an MDX query and import that into a table. I don't think there are any built-in tasks in SSIS...
September 2, 2015 at 2:51 pm
It's been a while since I've worked with Cognos, but I believe you can create a "pointer cube" in Cognos that will read from and essentially duplicate an SSAS cube.
You...
September 1, 2015 at 9:16 am
From a quick look, it looks like the issue is the following:
You are not including the Date hierarchy on an axis in your query, and therefore the "CurrentMember" property will...
August 31, 2015 at 9:16 am
Could it be that you're still using BIDS and not SSDT? You'd have to open your solution in SSDT for SQL 2014 to effectively upgrade your solution.
August 28, 2015 at 2:40 pm
HookSqlDba7 (8/21/2015)
I am going to make another post regarding "separation of duties between DBAs and Developers...
August 21, 2015 at 9:26 am
The encryption keys for the SSIS Catalog database is different and separate from your TDE keys. You should backup the SSIS encryption keys as well.
Outside the scope of this question,...
August 21, 2015 at 8:46 am
HookSqlDba7 (8/19/2015)
August 19, 2015 at 3:23 pm
That section is to assign instance wide administrative privileges only. Go into the "Roles" section of each SSAS database to assign specific roles/permissions.
August 19, 2015 at 2:45 pm
We'll need a bit more information to help you. Could you please post the results you are getting, as well as the Dimension Usage tab in your cube.
August 19, 2015 at 9:39 am
Alvin Ramard (8/18/2015)
Martin Schoombee (8/18/2015)
August 18, 2015 at 2:22 pm
If I understand your posts and image correctly, you needed to ensure that the "StageProviders" task to complete before the "Insert Providers" task started...but you still need the non-matching output...
August 18, 2015 at 12:46 pm
Viewing 15 posts - 391 through 405 (of 893 total)