Showing posts with label displays. Show all posts
Showing posts with label displays. Show all posts

Sunday, March 11, 2012

Currency Column in Report Problem

I have a column in a report which displays an amount of currency. The currency is stored in sqlserver databse as 'Money' data type.

My problem is when I run the report it rounds off the value and does not disply to any decimal places. I want it to display the currency as 2 decimal places as this is how it is input and stored in the database.

anyone know how to do this?

macca

You could format the textbox like this:

http://msdn2.microsoft.com/en-us/library/ms251684(VS.80).aspx

Find more info here:

http://msdn2.microsoft.com/en-us/library/ms252073(VS.80).aspx

Saturday, February 25, 2012

cube measure only displays one total

I did something to my cube where it is only displaying a much smaller value for

the sales amount measure than it should.

I have a project with two dimensions and one measure.

After deploying the cube i browsed it and pulled the sales amount into the

details field area. normally i should end up with some 400 + million in dollars instead i get 90+ thousand. It seems as if the cube is not processing fully or the browser tab is somehow being filtered. I checked and there is nothing in the subcube or any other field.

Can someone direct me on how best to debug this?

thanks

I found the problem and thought I would share what I did.

I'm surprised it works this way maybe it is a bug. Perhaps the pros here could add some info to this.

here is what I did.

I have a field called "Rate" which is multiplied by the "Qty" to come up the "Sales Amount" measure. This is done in the DSV as a "Named Calculation" in the measures table.

This same table is also used as a dimension table. In here i considered the "Rate" field to be non-Aggregatable or (IsAggregatable = false). Since i would never add up the rates for a total.

Apparently SSAS does not like this and hence things got really messed up. Switching it back to (IsAggregatable = true) fixed everything.

Hopefully my hair will grow back soon.

Tuesday, February 14, 2012

CSV Export Bug

Hello,
I have a report that displays data from SQL Server, and it also has a
subscription that exports the report as a CSV file to a network share on
specified schedule. There is another external app that picks up the CSV file
and imports it into a proprietary database.
The report uses a stored procedure on the SQL Server to query data that is
displays on the report. When the query returns data, everything works well.
However, there are times when there is no data returned from the query (an
empty result set). If that happens, the report itself looks fine, but the
exported CSV is messed up. When I open up the exported CSV into a text
editor, all it shows is "table1". I am not sure where its getting "table1"
from, but logically, if there is no data to be reported, I would expect the
CSV to contain the headers (field names) and no data. Obviously, the
external app that imports this CSV is not smart enough to recognize that
"table1" means no data and the entire import process crashes.
If there are any workarounds or hot fixes for this bug, I would like to find
out about them ASAP since this is a production system.
Thank you,
MHAROONNo replies, so do I assume that no one else has run into this issue? This is
a pretty serious issue for us, so I would appreciate any help.
"mharoon" wrote:
> Hello,
> I have a report that displays data from SQL Server, and it also has a
> subscription that exports the report as a CSV file to a network share on
> specified schedule. There is another external app that picks up the CSV file
> and imports it into a proprietary database.
> The report uses a stored procedure on the SQL Server to query data that is
> displays on the report. When the query returns data, everything works well.
> However, there are times when there is no data returned from the query (an
> empty result set). If that happens, the report itself looks fine, but the
> exported CSV is messed up. When I open up the exported CSV into a text
> editor, all it shows is "table1". I am not sure where its getting "table1"
> from, but logically, if there is no data to be reported, I would expect the
> CSV to contain the headers (field names) and no data. Obviously, the
> external app that imports this CSV is not smart enough to recognize that
> "table1" means no data and the entire import process crashes.
> If there are any workarounds or hot fixes for this bug, I would like to find
> out about them ASAP since this is a production system.
> Thank you,
> MHAROON