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!

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

Search results for query: *

  • Users: Shab
  • Order by date
  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...
  16. Shab

    Reporting Services installation question

    We have Windows 2003 server with SQL server Enterprise with sp3a installed on it. It also has IIS and ASP.Net installed and configured. When we try to install Reporting Services (doesn't matter what edition) we don't get any options to select the parts that we want. The installation skips all...
  17. Shab

    How to get a list of hidden cube measure with ADOMD

    Hi all, I have a cube that has some hidden measure and I would like to get a list of them with ADOMD. However I can only get the visible ones. Any ideas? Do you know an API that would do that? Here is my code: Set iCubeD = mCatalog.CubeDefs.Item(mCubeName) For i = 0 To...
  18. Shab

    Summing over time

    Scott, Have you tried: [Year].Currentmember: this will always return the current year. Shab
  19. Shab

    Analysis Services and Citrix

    Hi Justin, I made a mistake, the AS is not installed on the Citrix server it is installed on another server, but still if you use Citrix server the program runs faster than if you logged to your NT account and connected to the server. I am wondering if there is a location for cellset that I...
  20. Shab

    How to get curret member in a calculated set of calculated members?

    Thanks Justin57, I thought I never get an answer to this. I posted this 9 months ago! I changed the GUI so that the user is not able to make a selection on a higher level when they make selections at a lower level :) and that seemed to be fine with users. Thanks so much for the solution, I...

Part and Inventory Search

Back
Top