Viewing 15 posts - 1 through 15 (of 95 total)
If i understand correctly then all you really need to do is create one combined dimension that has all combinations of the current dimensions.
This would all depend on your...
October 11, 2017 at 9:09 pm
Im not quite sure what you are doing or where you are doing it ?
Can you provide a screenshot with what you are trying to do ?
Is...
September 28, 2017 at 7:04 pm
Instead of changing the MDX why not create a new dataset for this particular feature ?
August 31, 2017 at 7:04 pm
August 30, 2017 at 7:14 pm
Try adding the where statement like below.
SELECT NON EMPTY { [Measures].[Measure1] } ON COLUMNS
FROM [Cube]
where (strtomember(@Parameter))
Make sure you set up the Parameter...
August 24, 2017 at 6:55 pm
So keep in mind the options you selected didn't say "keep my partitions processed no matter what".
Most likely the new structures invalidated the current data and if its an...
August 14, 2017 at 6:18 pm
Also take a look at this
http://www.daxpatterns.com
It may even have the calc you are after.
July 23, 2017 at 8:50 pm
What do you usually provide the report in ?
If excel can handle the amount of data then you could create it in excel with the data connection.
We are...
July 20, 2017 at 7:12 pm
Unless i dont understand the question, can you just add the variable you want to see in the output of the stored proc ?
eg
[code...
July 20, 2017 at 7:09 pm
Are you processing the entire cube each time ?
Do any of the tables have partitions ?
You can most likely change this to only process changed data but it...
July 13, 2017 at 5:36 pm
We have had it in production (and other environments) for a month now.
No issues on our side.
June 29, 2017 at 7:04 pm
You could always just create the database with the same name and restore onto that.
March 9, 2017 at 8:01 pm
If you are just remoting into the server you wont need a hige amount.
I survived on a 1.5MB connection a few years ago and since it was only sending...
February 1, 2017 at 5:42 pm
January 30, 2017 at 8:53 pm
One thing i will recommend is to grab a copy of The Data Warehouse Toolkit.
This should answer your questions around this.
Its a great book and well worth it.
January 24, 2017 at 5:47 pm
Viewing 15 posts - 1 through 15 (of 95 total)