Viewing 15 posts - 271 through 285 (of 596 total)
Very informative thread there. I'd say you probably need to look at your flat file connection manager to see what's going on. As for any specific errors, you don't mention...
April 8, 2015 at 6:25 am
If I get what you're saying correctly, you want to pad out your rowcount with leading zeros up to 8 characters?
If so, you would first need to convert the rowcount...
April 7, 2015 at 5:52 am
sushil_dwid (3/27/2015)
1.When dimension data change but measure data doesn't change
2.When measure data change but dimension data doesn't change.
3.When both change
do we have...
March 31, 2015 at 6:50 am
rayishome (3/30/2015)
We can't just write MDX and actually depend on the Designer to allow our business users to build their own queries for Power Pivot.
Tread carefully there. Perhaps consider...
March 31, 2015 at 1:34 am
The problem with the MDX designer in those applications is that it often brings back more records than you need because it always uses the lowest level of granularity in...
March 30, 2015 at 10:13 am
Try having a look here: http://www.sqlbi.com/tools/datetool-dimension/
March 9, 2015 at 11:12 am
This clip from Snatch springs to mind:
https://www.youtube.com/watch?v=MepMN-1fO90
Glad I could help 😀
February 26, 2015 at 10:14 am
It depends on how the hierarchy is being referenced in the calculations. For example if a calculation referenced the hierarchy like this:
[Your Hierarchy].[Operating Unit].MEMBERS
then you would be ok. However if...
February 25, 2015 at 6:12 am
No that's not what I mean. You are talking about an SSRS report right, you mentioned a report and I have just assumed? If so you will have an MDX...
February 13, 2015 at 8:58 am
The only thing I can think of is to have a look through the source code of the ASSP project and see if they have done anything similar that you...
February 12, 2015 at 5:59 am
Here's a way of doing this in AdventureWorks which you can apply to your own data:
WITH MEMBER [MonthsFilled]
AS COUNT(EXISTING([Measures].[Internet Order Count], [Date].[Calendar].[Month]))
MEMBER [InternetFullYearOrders]
AS IIF([MonthsFilled]=12,[Measures].[Internet Order Count], NULL)
SELECT
{[InternetFullYearOrders]} ON 0
,
NON EMPTY
{[Date].[Calendar].[Calendar...
February 12, 2015 at 3:11 am
Well if the report is using the name (which is WCHAR) and ordering by it (I take it you are ordering in SSRS via the rendering) then it will be...
February 11, 2015 at 10:02 am
Install the ASSP assembly on the AS instance (http://asstoredprocedures.codeplex.com/)
Then run the following:
CALL ASSP.DiscoverXmlMetadataFull("\Databases\Database")
That's the only way I know of to look at it programatically unless you start querying the file...
February 10, 2015 at 6:18 am
Alright, then your options are to either split up the dimension and renormalise it or go through the dimension data types and see where you can reduce the sizes. Have...
February 2, 2015 at 5:09 am
Viewing 15 posts - 271 through 285 (of 596 total)