Viewing 15 posts - 46 through 60 (of 451 total)
You're creating a member [Amanda P-D] that adds Amanda D and Amanda P., but then you don't use it in your query. Jut looking at this, it looks like your...
May 18, 2017 at 12:22 pm
Please don't post the same question in multiple forums. It splinters the replies and makes helping you harder. I've responded to your SQL 2016 question.
Thanks,
Rob
May 18, 2017 at 12:14 pm
Would creating a 'create database' .xmla script (right click on database in dev and script out create) work? Take the script to your test server and create there. (Delete the OLAP database...
May 18, 2017 at 12:12 pm
You're really not giving much information so anyone can help you. What is the error? How's it not working? The query I posted above, was just an idea -- you needed...
May 18, 2017 at 12:01 pm
Write three separate queries against the three cubes. Can you have three separate datasets in SSRS (or whatever reporting tool you're using) and do the combining of the data there?
May 18, 2017 at 7:32 am
Not knowing what your date dimension looks like (assuming SSDS_Tim_Dim is your date/time dimension) you could do something like:
SELECT
{
[SSDS_Tim_Dim].[Month]
} ON AXIS(0),
May 18, 2017 at 7:28 am
Permissions -- I can't see the test or prod server from the dev server that has SSDT. I've done what you suggest and just deployed directly from SSDT to different...
May 16, 2017 at 1:09 pm
So I can copy the .ispac file from my SSDT project's \bin\Development directory and that let's me import on dev or other servers just fine. There's some security...
May 16, 2017 at 12:40 pm
Thank you Lowell. That's exactly what I was after.
Thanks,
Rob
May 11, 2017 at 5:57 am
Is it just a matter of adding a WHERE clause to your query so that it doesn't bring back those out of range records? I'm not totally sure what you're...
April 18, 2017 at 12:39 pm
I'm guessing the MAX() and/or MIN() aren't working as they're only looking at the one row. Could you add a CTE to your query to add these max and min...
April 18, 2017 at 12:36 pm
Do you use your DimEmployee dimension linked to other Fact tables (other than your monthly snapshot)? Do you care about multiple changes that happen to an employee during the month? ...
April 18, 2017 at 7:21 am
Mystery solved. I talked with our network folks, and these errors are from our network scanner. New and interesting things to discover on a new system. 🙂
Thanks,
April 18, 2017 at 6:43 am
Jeff and Ron, thank you for your feedback. This is something I'll have to correct over time. As I get to know the usage better, I'll be able to determine...
April 3, 2017 at 7:26 am
Add a data conversion (or a derived column) task to convert from the data type of your input file to the data type you want for your output file. Change...
March 20, 2017 at 7:51 am
Viewing 15 posts - 46 through 60 (of 451 total)