INF: MDX: How to Query for the 10 Best Customers and the Top 5 Products for Each Customer

INF: MDX: How to Query for the 10 Best Customers and the Top 5 Products for Each Customer: "--The top 10 customers can be defined in a named set, using the TopCount
--function to limit the set and to return the names of the customers with
--the 10 highest Units Sales for the year 1997.

WITH SET Top10Cust AS
'TopCount( { [Customers].[Name].Members }, 10, ([Time].[1997], [Unit Sales]) )'

--Then use the Generate and CrossJoin functions in the body of the query
--to combine the Top10Cust Named Set with the top 5 products for those
--customers.

SELECT { [Time].[1997] } ON COLUMNS ,
Generate( {Top10Cust}, CrossJoin( {Customers.CurrentMember},
TopCount([Product].[Product Name].Members, 5, ([Time].[1997], [Unit Sales])))) ON ROWS
FROM [Sales]"

How find info regarding MOSS 2007 metadata

Sharepoint_config database stores metadata information related to sharepoint websites and content.  While I did my own digging through the tables i found the below SQL statement from Bert Van Landeghem's blog:

SELECT [Id]

,[ClassId]
,[ParentId]

,[Name]

,[Status]

,[Version]

,[Properties]

FROM [Sharepoint_Config].[dbo].[Objects]

WHERE properties LIKE '

BI Thoughts and Theories » Blog Archive » View Permissions for Reporting Services in SharePoint Integrated Mode

BI Thoughts and Theories » Blog Archive » View Permissions for Reporting Services in SharePoint Integrated Mode: "You simply need to ‘Publish a Major Version’ of the item in SharePoint with the context menu in the library. Once you do this the users no longer need the edit capabilities and you can follow the security here – http://msdn.microsoft.com/en-us/library/bb283148.aspx. If you don’t publish a major version then the only way the end-users will see the items is if they have the edit items permission which is something that you definitely do not want to provide them."

The Permission granted to user DOMAIN\UserName is insufficient for performing this operation.(rsAccessDenied)

Found this link and seems to be logical and interesting solution to the problem.  But I could not figure out the approval part for data sources.  Could not find the option.

Permission to reports in Sharepoint integrated mode.

Update:  The option to approve a data source appears if a subsite is created and data connection library exists under this subsite.  I am not sure why it should not show up under default website.

Sharepoint Enabling Usage Analysis and Importing data

Usage analysis in Sharepoint 2007 can be enabled by navigating to Central Admin -> Operations -> under Logging and Reporting -> Usage Analysis processing.

Check the Logging Setting's,  Enabling Logging box.
Set the time when want the log needs to be processed under Processing Settings.
Note :  The log generation job is daily job and only runs once in a day.

Once set you would need to wait for a day to get the generated log file.  The log file is generated under
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\.  The web application GUID can be extracted by connecting to Sharepoint_Config Database and running the following query.


select o.id,, o.* from objects o
inner join Classes c on c.Id = o.ClassId and c.FullName like '%SPWebApplication%'
where o.name like

If your sharepoint infrastructure on configured in a farm then each server on the farm generates its own log.  you would need to search for the web application guid folder and the folder for each day to view the log.