| T O P I C R E V I E W |
| nm8201 |
Posted - 07/20/2010 : 21:58:27
I am trying to prepare a quick ROLAP report. I just want to understand if this the manner that the ROLAP works. It appears that any measure that counts any Alpha column will get an SQL convert error on execution when any Dimension is added to the columns.
Is that correct?
TIA Ron |
| 5 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 08/16/2010 : 07:21:22
Build 171 should be out this week. Please contact support@reportPortal.com if you need an immediate hot fix. |
| nm8201 |
Posted - 08/15/2010 : 10:04:52
Is Build 171 near release or is it possible to obtain a hot fix?
Thanks - Ron |
| admin |
Posted - 07/23/2010 : 03:51:49
Thank you for reporting this problem. This is a bug will be fixed in the coming build (171). |
| nm8201 |
Posted - 07/22/2010 : 10:34:01
This only occurs when the counted measure column is alpha and a dimension is added to the "columns" on the report. We are on SQL 2008, Build 169.
SQL and error below the counted measure Bene_ID is a member id that is a combination of alpha and digits. Since the SQL case is using 0 I guess SQL expects Bene_IDS to be numeric --
Conversion failed when converting the varchar value 'Z1325582T' to data type int.
SQL: SELECT
Count(DISTINCT CASE SPD.Aid_CD WHEN '10' THEN SPD.Bene_ID ELSE 0 END) as [10],
Count(DISTINCT CASE SPD.Aid_CD WHEN '14' THEN SPD.Bene_ID ELSE 0 END) as [14],
Count(DISTINCT CASE SPD.Aid_CD WHEN '1E' THEN SPD.Bene_ID ELSE 0 END) as [1E],
Count(DISTINCT CASE SPD.Aid_CD WHEN '1H' THEN SPD.Bene_ID ELSE 0 END) as [1H],
Count(DISTINCT CASE SPD.Aid_CD WHEN '20' THEN SPD.Bene_ID ELSE 0 END) as [20]
FROM SantaClaraSPD SPD
Thanks -- Ron
|
| admin |
Posted - 07/21/2010 : 20:08:59
No, you should not get an error. What is the SQL and the error description? |
Report Portal
