1 of 1 people found this helpful
Are you using that query in a Custom SQL connection? Could you paste that query here so we can look for possible problems?
Note that if you are using RAWSQL calculated fields, you will have very limited success trying to express an entire SELECT statement within the RAWSQL formula. If that's really what you're after then you should change your connection to a Custom SQL connection and place your query there.
It is difficult to help you without having more information about your scenario. As Robert Morton mentioned in his post, we need to know first if your are using your query in a Custom SQL connection and to have an idea of that query.
Can you provide the query and a package workbook with a sample (extracted) data set?
Assuming you connect to your data source using a Custom SQL connection, please verify if option Aggregated Measures is checked in the Analysis menu. By your comment it seems that option is unchecked.
If Aggregated Measure is checked, verify if you have a dimension in level of detail and make sure you are counting the records using the function SUM([Number of Records])
Again, it is easier for us if you provide a workbook.
Nice!! I didn't know about the Aggregated Measures in the Analysis menu. That's exactly what it was. Thank you so much. I wish I had asked earlier on rather than making my self insane. Funny, the difference between hours of clicking the wrong button and a millisecond of clicking the right one.
I was going to try to create a simple test so I could past a workbook. I'll be sure to do that when possible to make it easier to get help.