Viewing 15 posts - 256 through 270 (of 596 total)
coool_sweet (4/14/2015)
so what data type i should give so that it wont come as $ in my excel sheet
Anything other than currency if you want to avoid the dollar sign....
April 14, 2015 at 9:37 am
For the columns that show "####", have you tried expanding the column width in the worksheet?
As for the $ sign - you have set the Amount columns to be currency,...
April 14, 2015 at 9:12 am
Manic Star (4/13/2015)
PB_BI (4/13/2015)
coool_sweet (4/13/2015)
its not correct after phone its breaking into new line.
what should i change in my stored...
April 13, 2015 at 9:01 am
So when you look at the generated text file in notepad++ it still has the LF there where it shouldn't be or is it something else? Can you post your...
April 13, 2015 at 8:50 am
coool_sweet (4/13/2015)
its not correct after phone its breaking into new line.
what should i change in my stored proc , to...
April 13, 2015 at 8:23 am
xsevensinzx (4/10/2015)
PB_BI (4/9/2015)
xsevensinzx (4/8/2015)
Alternatively, you do have Microstrategy for ROLAP too. It works rather well compared to SSAS.Yes, go out and spend $600,000 per core to solve your problem 😀
If...
April 10, 2015 at 1:14 pm
It's simple.....there is a problem with your flat file and you create this flat file with your stored procedure. It must be a problem with the procedure.
You have an...
April 10, 2015 at 12:21 pm
In which case it's not your DBA that is the problem. As I said in my first reply, SSAS reads DECIMAL as DOUBLE or SINGLE which are FLOATs. Change the...
April 9, 2015 at 8:48 am
Jeff Moden (4/9/2015)
PB_BI (4/9/2015)
Show your DBA that, if they continue to argue the point then they are a moron of the highest order.
Not really. Without using FLOAT datatypes, you...
April 9, 2015 at 8:31 am
You are correct in the sense that Floats shouldn't be used for monetary data. In database terms, DECIMAL or NUMERIC should be used. The problem with SSAS is that it...
April 9, 2015 at 7:36 am
You could achieve this using the Axis function in MDX. Here is an example in AdventureWorks:
WITH MEMBER Measures.PercentOfAxis AS
[Measures].[Internet Sales Amount]
/
SUM(AXIS(1), [Measures].[Internet Sales Amount]), FORMAT_STRING="Percent"
SELECT {
[Measures].[Internet...
April 9, 2015 at 5:59 am
xsevensinzx (4/8/2015)
Alternatively, you do have Microstrategy for ROLAP too. It works rather well compared to SSAS.
Yes, go out and spend $600,000 per core to solve your problem 😀
April 9, 2015 at 3:15 am
This has been answered before on this very site:
http://www.sqlservercentral.com/Forums/Topic953520-150-1.aspx
🙂
April 9, 2015 at 3:11 am
coool_sweet (4/8/2015)
but its coming correctly for all the records except 2.my stored proc return it correctly
Before simply dismissing what has been suggested, at least try it out. What's so difficult...
April 8, 2015 at 1:01 pm
Seems as if you probably have the row and column delimiters set incorrectly for that file. Have a look at the file in a text editor that allows you to...
April 8, 2015 at 11:19 am
Viewing 15 posts - 256 through 270 (of 596 total)