Viewing 15 posts - 256 through 270 (of 893 total)
January 17, 2017 at 2:33 pm
I am currently working on design phase of an integration of a new CRM system...
January 17, 2017 at 8:00 am
MDX is the language used to query SSAS cubes, and it is to Analysis Services what T-SQL is to the SQL Server RDBMS.
Why should you learn MDX if you could...
January 10, 2017 at 8:11 am
The SQL Browser service does not resolve IP addresses...DNS does that. It provides information about the instances on a server and the port numbers used for each instance. See the...
January 9, 2017 at 1:51 pm
The only way I know of is to access WMI programmatically and periodically to check the status of the service.
January 9, 2017 at 1:34 pm
Your conversion needs to be the other way around. Excel expects Unicode values, so you'll have to convert everything to Unicode coming out of your source (if it isn't Unicode...
December 28, 2016 at 9:33 am
It is possible to create branches in Git and then merge them. Are you not utilizing that functionality?
I think most source control systems (I've used Git, TFS and SVN...
December 12, 2016 at 2:01 pm
This is not an SSAS bug/error. By design, SSAS requires non-null key references between fact and dimensions...and between dimension tables if multiple tables are used (in a snowflake design). There...
November 4, 2016 at 4:52 am
Disclaimer: I'm answering this purely from "muscle memory", and haven't tested or verified it...but I think it's worth a try.
I think the problem here is your dimensional reference, which steps...
November 4, 2016 at 4:44 am
What are you using for reporting, SSRS?
The only way I can see you do this is if you include a ranking function as part of your query (based on the...
November 4, 2016 at 4:40 am
My first (very superficial) guess would be that when you query the SQL database directly, query folding happens (i.e. Power BI is able to simplify and filter the query which...
November 4, 2016 at 4:37 am
Do you see the same behavior if you add a calculated member to the cube?
November 4, 2016 at 4:31 am
As far as I am aware, adding a column to a back-end dimension table will not break your cube build. The next time you update metadata, the column will be...
November 4, 2016 at 4:24 am
I guess the question is: Is the overhead of using the OpenRowset() in the documented stored proc and the additional columns enough reason to use an undocumented function/stored proc? Do...
October 31, 2016 at 11:48 am
Yes, create a cube dimension with the fact table as its source and add the required attributes.
October 20, 2016 at 9:13 am
Viewing 15 posts - 256 through 270 (of 893 total)