Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Shab

  1. Shab

    Error HRESULT E_FAIL has been returned from a call to a COM com

    Hi, What do you use to browse the cube? Do you use Visual Studio? Have you tried browsing it by using SQL Server Management Studio? or Excel? It sounds like you are missing a DLL or need an update on the software installed. Do you have the latest version of SPs installed? I also found...
  2. Shab

    Aggregation type - NONE; but setting aggregation through MDX - how to?

    Hi eo, I have a couple of suggestions. If your base physical measure is not visible to end users, then you don't have to set its aggregation to NONE. Set it to SUM and let the engine do its work. Then you only use its value when you want for your calculated measure. Since this is all users...
  3. Shab

    KPIs help

    One way is to use SharePoint and Excel Services. SharePoint has a KPI Viewer part that can connect to SSAS and read the KPIs. You can also create an Excel book with Office 2007 and export it to SharePoint Excel Services. Look at ...
  4. Shab

    Ranking ties

    I found the answer to one of the questions I had. In order to get ranking with ties to sort the set in Ascending order, all you have to do is to specify the negative of the third paramter: For example Rank( Deimension.Currentmember, YourSet, - [Measures].[Sales])
  5. Shab

    Ranking ties

    The Rank function specifies an optional 3rd parameter for tied ranking. If you specify this parameter, the ranking ignores the sort order of the set (even if you sorted it before) and it sorts the set in descending order based on the third parameter value. Ties get the same rank but the next one...
  6. Shab

    Error when using calculated members in filters area

    In AdventureWorks database, I cretaed a calculated member as following: CREATE MEMBER CURRENTCUBE.[Product].[Product Categories].[Subcategory].&[26].Product1 AS [Product].[Product Categories].[Product].&[483], VISIBLE = 1 ; Product1 is equal to Accessories-->Bike Racks-->Hitch Rack -...
  7. Shab

    Time Intelligence Wizard YTD and error message

    I followed the Time Intelligence Wizard in Adventureworks sample database to implement YTD,QTD and MTD for the Amount Measure in the Fiscal Hierarchy. When I use the BIDS browser to look at the data, I put Amount in the columns, Date.Fiscal hierarchy in the rows and then I filter on...
  8. Shab

    Automatic Refresh warning in Excel Services

    How do you turn automatic refresh warning off in the Excel Web Parts with an embedded external data source? I have created a SharePoint site where I have couple of Excel Pivot tables loaded in the Excel Web Services web parts. The Excel books get their data from SQL Server Analysis Services...
  9. Shab

    Anyone else have problems with excell services? mossb2tr

    Yes, I had the same problem. You need to define a Trusted Location for Excel books. You can do this using the Central Administration site. Once you define a folder (for example a document library) you can put all your Excel books in there.
  10. Shab

    Default value or value provided for the report parameter is not a val

    I am using Microsoft Reporting Services 2005 with SP1 on Windows 2003 server. I have also installed a HotFix that puts "Select All" back into the parameter option list. My report has 4 parameters, all of them have multi-select enabled. Sometimes when I run the report, if I choose every option...
  11. Shab

    Inventory implementation

    Hi, If you have a monthly fact table that gives you the end of the month balances, and a change table that for each month gives you changes since the beginning of the month, how do you implement this in MSAS so that users can pick any day in the calendar and see the inventory levels for that...
  12. Shab

    User Defined Functions on the server

    I know it seems to be tough if not impossible. This article makes it sound like it is possible: http://www.windowsitpro.com/SQLServer/Article/ArticleID/6115/6115.html But of course it didn't work. Thanks for the reply anyways.
  13. Shab

    User Defined Functions on the server

    I have a dll file that I generated using VB 6.0. It has a user defined function in it. One I register the dll on my computer I can use the "USE LIBRARY <file Path> command in MDX Sample App to register it for the session and I can use the functions in the file in my MDX. Is there a way that I...
  14. Shab

    Reporting Services installation question

    Hi Catadmin, Thanks for your reply. No I haven't been able to install reporting services on my server yet. I have the report designer on my computer (a client machine) and I can open the designer. On the server however, there is no need for the designer and I should be able to install the...
  15. Shab

    Reporting Services installation question

    Hi Catadmin, Thanks for your reply, but I am not clear on what you suggested. What do you mean by Visual Studio 2004 edition? We have VS .NET 2003 and then I am not sure if we have an additional license of VS for the server. Do you mean I can get to the Reporting Services installation through...
See more

Part and Inventory Search

Back
Top