Tag: databases

Suppose i've a table emp and id is one of the column in it, what will be result for this query.select * from emp where id=99999 and 1=0;

for a 'CUBE' maximum number of Dimensions(including Measure Dimesions)

For Outer Join and Simple Join(inner Join) the Native SQL'll be Same

Can u implement 'Multi Measure' analysis in Report Studio with Cross tab.

Lists and Cross tabs Must and Should have a Measure and dimensions to implement/run the report.

Can u create Master-Detailed Reports for Cross-tabs.

'DELETE' command in SQL Will Remove the data as well as Structure

can u change the Governer Settings in Report Level.

'Report Validation' deals with the Data Present in Reoprt.

How can you load universe into the repository?