hi,
i've year attribute with duplicate values and i need to pull all data including duplicate values,
hanse i need to remove group by clause generated by sql.how would i approach the result.
remoovin group by clause
Wed, 2010-08-25 07:25
myMSTR.com
MicroStrategy Community Website - Ask, Discuss, Share....
You might be interested in..
- Can we create a conditional Freeform SQL
- I need to display week to date in report
- issue regarding displaying of data in documents.
- Web displaying Error(Mismatch data)
- Custom Subtotal
- how to resrtict drilling to a perticular level
- how to prepare MSTR Dashboard from Informatica Reporting Services
- Drilling with a Template
- Discrepency in rows between MSTR and BO
- Distinct customer count
Blog Posts
- Applying selections as filters or slices
- Create Highly Visual Dashboards in Minutes using visual insight.
- How to configure MicroStrategy Mobile Server
- Compatibility Issue (older Desktop clients against 921m I-Server)
- BI Conference - Pune - Feb 11th 2012
- Intelligence Server Engines and Query Flow
- MicroStrategy Access and Privilege Control by Project
- MicroStrategy Security Model
- Intelligent Cubes in MicroStrategy 9.x
- ODBC set up for MicroStrategy 64 bit I-Server.
To remove group by clause in the SQL, you can define this as a level metric. Target will the Year attribute. Grouping should be set to "None". This should ignore "year" in group by clause. Leave "Report Level" as is.