SSRS 2005 probplem with mdx prameter passsing

SQL Server Analysis Services

Index ‹ SQL Server

- Previous
  - 1
    - Cannot connect to SQL Server 2005 Express with Management Studio Express On my home machine without permanent network connections enabled, I cannot get the Management Studio connect to the database server. Always get this error: Cannot connect ot MPLIAM\SQLEXPRESS Additional Information: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, erro: 26 - Error Locating Server/Instance Specified)(Microsoft SQL Server) I have used the SQL Surface Area Configuration Tool to reset the defaults to allow remote connections, stopped and restarted the server, but still get the same message. Please help. Tag: SSRS 2005 probplem with mdx prameter passsing
  - 2
    - password cannot be saved Hi, there; I have a SSIS package which has SQL2005 as its destination. When I setup the connectionmanager, I'd like to use SQL authentication. But I found that the password field cannot be saved (Checkbox "Save password" is selected).Everytime I open the this package's connectionmanager, that password field is cleard. The result is that my C# application that loads that package to execute failed with "Login failed..." Did I do something wrong or anybody know how to save that password field Cheers Tag: SSRS 2005 probplem with mdx prameter passsing
  - 3
    - Unable to change SQL 2005 database Autogrowth through Server Management Studio I have a database that seems to change its autogrowth settings every so often. When I initially set this up, I set the autogrowth at 500MB. After some time, I noticed that the autogrowth was set to 645000%. When I tried to change it through Management Studio but recieve the following error ' Value of '645000' is not valid for 'Value'. 'Value should be between 'Minimum and Maximum'. Parameter name: Value(System.Windows.forms) This occurs when I try to open it in order to change it. The only way to change it is through Transact. USE master GO ALTER DATABASE mydb MODIFY FILE (NAME = mydb_data, FILEGROWTH = 500MB) GO This will work, but for how long I do not know. I have done this twice before. The first problem is why am I unable to change this value using SQL Management Studio. Second is why is this value being changed and how does such a large value get inputted. So far, this is only happening with only one of my 2005 database. Any direction would be of great help. Thanks Akinja Richards Tag: SSRS 2005 probplem with mdx prameter passsing
  - 4
    - Sorted Input If a component requires a sorted input it would seem reasonable that you can check the IsSorted property of the attached input, but this will always return false. I have tried this when connecting the output of the Sort transform to my component, and then check the IsSorted property for this input. It is always false. How can this be, and also how can I see if the path is indeed sorted If using a virtual input column in my UI, I get a SortKeyPosition on the columns, but when overriding SetUSageType in the component class I always get zero for the key. Why is the sort information not quite there for me Tag: SSRS 2005 probplem with mdx prameter passsing
  - 5
    - Need to change Authentication type of my first DB in SQL05 * I was able to configure and install the DB * I accidentally selected Windows Authentication Now it won't let me login and keeps giving me an error. Question: how do i change the authentication type without getting into the db is there something I'm missing Tag: SSRS 2005 probplem with mdx prameter passsing
  - 6
    - While creating a snapshot... Hello, Here's the idea: There is a central SQL Cluster Server and there are branches in different cities. I'll replicate databases from branch SQL Servers to the central SQL Server. Every city will have a database in the central SQL Server. While i was creating publication for replication, i get the following errors from different (6-7) tables among 289 articles. ---------------------------------------------------- 2007-04-20 12:00:45.18 [46%] The replication agent had encountered an exception. 2007-04-20 12:00:45.18 Source: Replication 2007-04-20 12:00:45.18 Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException 2007-04-20 12:00:45.18 Exception Message: Incorrect syntax near the keyword 'percent'. 2007-04-20 12:00:45.18 Must declare the scalar variable "@metadata_type". 2007-04-20 12:00:45.18 Must declare the scalar variable "@compatlevel". 2007-04-20 12:00:45.18 Must declare the scalar variable "@lineage_old". 2007-04-20 12:00:45.18 Must declare the scalar variable "@lineage_old". 2007-04-20 12:00:45.18 Must declare the scalar variable "@compatlevel". 2007-04-20 12:00:45.18 Must declare the scalar variable "@p8". 2007-04-20 12:00:45.18 Failed to generate merge replication stored procedures for article 'mf_pro_processeditem_financial'. 2007-04-20 12:00:45.18 Message Code: 156 2007-04-20 12:00:45.18 ---------------------------------------------------- These articles are belong to a software which is developed by another company. Any ideas SQL Version : Enterprise 2005 with SP2 Replication type: Merge Thanks, Eko Tag: SSRS 2005 probplem with mdx prameter passsing
  - 7
    - Adding linked measures without rebuilding? Is it possible to added a linked measure group without having to rebuild the base cube Or, is it possible to build a cube that exists of nothing but linked measures Tag: SSRS 2005 probplem with mdx prameter passsing
  - 8
    - How to export to a fixed width flat text file with row delimiters? We're having issues exporting a set of data from SQL to a fixed width flat text file by just doing a right click on the DB, then choosing Tasks > Export Data. You can not specify a row delimiter when you choose a Fixed Width format. The only way around this that we've found is to specificy char(13) and char(10) at the end of the SQL select statement. Without row delimiters you end up with 1 giant record rather than 20,000 regular sized records. Is there any other way around this that we're missing Using Ragged Right is not an option either since the record lengths will be inconsistent if the last field doesn't contain a consistent length to the data. Thanks, Mike Tag: SSRS 2005 probplem with mdx prameter passsing
  - 9
    - error running ssis package I run an ssis task with right click in the BIDS. the task transform data of the tables between sql2005 DB to another sql2005 DB. this is the error I get: Code Snippet An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: " TCP Provider : The semaphore timeout period has expired . ". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}" . Task failed : CopyTables2 i have a similar task, only diffrent tables that being transfered, same settings. this task run succesfully. for the task that fails it takes a long time to run (something like half an hour, maybe more) and then it falils. the task that succeeds finish fast (something like 5 minutes). the data in the tables that being transeferred in the good task is much smaller than the data in the tables in the failed task. Anyone knows the reason to the error. Thanks. Tag: SSRS 2005 probplem with mdx prameter passsing
  - 10
    - Recursive Multi-Level Query using CTE. Attn: Experts! I am attempting to do the following.... I have standard tree setup. The tree can be up to 4 nodes deep. User permissions may be assigned at any level in the tree. Any permission should cascade down the tree to the lowest child node. For example, if a user had a role of 1 for the root node (101), the sql should return: OrgID RoleID 101 1 102 1 103 1 etc... My table structure is as follows.... Org OrgID ParentID 101 Null 102 101 103 101 105 102 106 102 107 105 108 105 109 106 110 106 111 106 UserOrgRole UserID OrgID RoleID User1 101 1 User1 102 2 User1 103 2 User1 107 2 User2 101 1 User3 106 3 etc... What I would like to retrive from the above table data is.... OrgID RoleID 102 2 105 2 106 2 107 2 108 2 109 2 110 2 111 2 This is so because all the nodes (except for 101 and 103) are somehow decedent from the 102 node and 102 has a roleid of 2. I am only concerned with the RoleID 2 and User1. I have worked for two days trying to figure out how to do this. I am not a DBA or SQL expert by any means. I cannot seem to figure out how to traverse multiple levels of the tree. I have been using the new CTE and made some progress, but I think I reached my plateau and haven't been able to get any further. If someone could help me, I would be forever in your debt! I am really starting to get very frustrated and I know there are some of you experts out there that would know exactly what to do. thanks! Tag: SSRS 2005 probplem with mdx prameter passsing
  - 11
    - Need urgent help on Aggregate Function Hi, I need to do something similar to Proclarity in SSAS 2005. In Proclarity i can create a named member by selecting a few members from a dimension. The underlying mdx looks like this Aggregate ({ [Channel].[Channel].[CON - Contractor], [Channel].[Channel].[DIS - Distributor], [Channel].[Channel].[END - End-User], [Channel].[Channel].[GRP - Group], [Channel].[Channel].[OEM - OEM], [Channel].[Channel].[PLA - Private Label], [Channel].[Channel].[SER - Service Provider], [Channel].[Channel].[SYS - System builder] }) Once i select the named member all the calculated measures reflect the result based on the members selected in the aggregate function. How can I do something similar in SSAS 2005. I dont want a named set and calculated member does not work if i use the plain mdx as above. But i also tried using Aggregate ({ [Channel].[Channel].[CON - Contractor], [Channel].[Channel].[DIS - Distributor], [Channel].[Channel].[END - End-User], [Channel].[Channel].[GRP - Group], [Channel].[Channel].[OEM - OEM], [Channel].[Channel].[PLA - Private Label], [Channel].[Channel].[SER - Service Provider], [Channel].[Channel].[SYS - System builder] }, [Measures].Orders Received Local) just to try to to see teh behaviour but to no avail. after processing the cube and selecting this meausre shows up empty cells. How can I solve this problem. thanks in adavance for helping Tag: SSRS 2005 probplem with mdx prameter passsing
  - 12
    - Problem: Formatting The Sql Report I created a report using SQL Report Server project. I was able to retrieve my data without any problem. I am having a hard time to format the data correctly: when somebody access the report he will have the option to export it to PDF file Here is how I would like to format the PDF File: Test (title) Department : A Mike Jebson St Address State City 14111 NC Test 12541 NC Test2 Page 1 For the second user I will have all the above template to be Repeated again ------------------------------------------------------------------------------------------------------------ Test (title) Department : B George Jebson St Address State City 14111 NC Test 12541 NC Test2 Page 2 I could not make it to copy the title in the second page. This is what I have so far ------------------------------------------------------------------------------------------------------------ Test Mike Jebson St Address State City 14111 NC Test 12541 NC Test2 Department : A George Jebson 14111 NC Test 12541 NC Test2 Department : B Steve J 14111 NC Test 12541 NC Test2 I want the whole template to be repeated for each user. I do group by name but still I can��t repeat title and the lines for each page. It will put everything under one title. Is there a design screen for pdf Or i just need to do everything in the layout tab for the report then expor it as a PDF Tag: SSRS 2005 probplem with mdx prameter passsing
  - 13
    - Guidelines for choosing collation If I am doing a fresh installation of SQL 2005 for a new application which will utilize database engine, report server and analysis services is my best choice Latin_General_BIN2 Thank you, Alex Ivanoff Tag: SSRS 2005 probplem with mdx prameter passsing
  - 14
    - SQL Server 2005 Install fails on Vista During the install, I get the following message: Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed. Microsoft .Net Framework 2.0 is either not installed on this system or is corrupt. I cannot uninstall 2.0, as its part of the Vista. I have tried repairing it. I tried downloading 2.0 and installing it, but it says that its allready installed. I was able to install Visual Studio with Sql Server 2005 express. I am stuck. Is the case that Sql install dosent know about the latest version of 2.0 that came with vista Tag: SSRS 2005 probplem with mdx prameter passsing
  - 15
    - New features of Reporting Service in SQL 2008 Where can i find the new upcoming features in reporting service for 2008 Tag: SSRS 2005 probplem with mdx prameter passsing
  - 16
    - roll back in for each container Hi, I'm using data flow as flat file source -> derived column ->Data Conversion-> oledb destination I have a fifty thousand record in a delimited file. while processing i got error in 45000th row. In database only 40000 records are there(why is there no all 45000 records). Is there any way to roll back all the 40000 records. Tag: SSRS 2005 probplem with mdx prameter passsing
- Next
  - 1
    - SSIS SCript Transform Parallelism Hi, I need some urgent help on a conceptual question. Requirement: I have a simple package with one dataflow task. In that I need to read from a sql table and for every row in that table loop through n times and generate new output rows based on certain conditions (which are best evaluated in custom script as they are rather complex). Hence, if I have 100 rows in the table as my input, I may end up with 100*n rows as output. My Design: To implement this I have used an OLE DB Source which outputs to a Script Transform (ST). In the ST I intend to loop through in custom code and generate new rows using the .AddRow feature when I need new rows. This ST then feeds into another OLE DB Destination which writes the data to the table. Simple! I am using the default buffer settings. All I have tweaked is the Synchronous... property on the script transform (otherwise I do not get to the Output0Buffer within the script!). Problem: I wish to do as much as possible in parallel. So I would expect the OLE DB Source to provide more than one row at a time to the script transform and that should process more than one input row simultaneously. It seems the script componenet is serializing input, so it seems to take one row at a time from the OLE DB source, loop through and process in the script transform). AM I RIGHT IN THINKING THAT THE SCRIPT TRANSFORM IS EXECUTING THE INPUT IN A SEQUENTIAL MANNER CAN I PARALLELISE THIS If so, how Thanks, Tirthankar Tag: SSRS 2005 probplem with mdx prameter passsing
  - 2
    - SQL Server Express authentication mode greyed out Having problems connecting to SQL Server Express using 'sa' account and having read threds re problem and MS, advice is that Authenticaion mode needs to be set to both Windows and SQL. I have studio express installed and go to Security from the properties of the Server to change this option to use both authentication modes, however the options are greyed out! Can anyone advise pse. And will amending this option help me to enable the sa login which is refused at the moment, error as follows: Login failed for user 'sa'.The user is not associated with a trusted SQL Server connection Thank you in advance Tag: SSRS 2005 probplem with mdx prameter passsing
  - 3
    - how to call a stored procedure in SSIS I have to transfer data from source to destination using stored procedures result set. There might be some more transformation needed to store the final result in the destination table. Appreciate an early feedback. Qadir Syed Tag: SSRS 2005 probplem with mdx prameter passsing
  - 4
    - change the background color in table in report I have a table that i need to display data for each row I want the background color to be diff anybody knowhow to do it color blank color blank Tag: SSRS 2005 probplem with mdx prameter passsing
  - 5
    - WebRequest over HTTPS fails under SQLCLR, but works elsewhere I have some code in a SQL CLR stored procedure that calls out to a web service at UPS to obtain tracking information for a package. The code fails on the last line, in the call to WebRequest.GetRequestStream(), with the following exception: "System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it\r\n at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)\r\n at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)\r\n at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)\r\n --- End of inner exception stack trace ---\r\n at System.Net.HttpWebRequest.GetRequestStream()\r\n at UPSTracking.TrackShipment(String TrackingUri)" Here is the relevant code: WebProxy proxyObject = new WebProxy(); WebRequest request = WebRequest.Create(" https://www.ups.com/ups.app/xml/Track "); request.Proxy = proxyObject; request.Method = "POST"; request.ContentLength = strXMLData.Length; request.ContentType = "application/x-www-form-urlencoded"; StreamWriter sw = new StreamWriter(request.GetRequestStream()); This same code works just fine when not running in the SQL CLR assembly. The assembly is marked as External, but I've also tried marking it as Unsafe, which did not work either. Any suggestions on what the problem might be or how to troubleshoot this further would be greatly appreciated. Thanks, Steve F. Tag: SSRS 2005 probplem with mdx prameter passsing
  - 6
    - Table design question - subject matter expert database I would like to create a database that keeps track of our companies subject matter experts. I have roughed out some of the tables. I would appreciate any feedback on if this is the right approach and if there might be any issues when I start writting a front-end (probably VB 2005). What makes this interesting (at least for me) is that a subject has an owner and at least 1 "expert", possibly up to 3. Here is what I am thinking for tables: tblEmployee EmployeeID (PK) LastName FirstName etc...... tblSubject SubjectID (PK) Description tblOwner SubjectID (FK) EmployeeID (FK) tblExpert1 SubjectID (FK) EmployeeID (FK) tblExpert2 SubjectID (FK) EmployeeID (FK) tblExpert3 SubjectID (FK) EmployeeID (FK) Does this make sense Would I run into any issues when trying to display this on a form in VB Thanks in advance for any help!!!!! Cal Tag: SSRS 2005 probplem with mdx prameter passsing
  - 7
    - Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on... Is there an expression syntax that will do this Does it have something to do with ROWNUMBER(). Any help is greatly appreciated! Thanks in advance! Probably an easy one for you gurus out there! Tag: SSRS 2005 probplem with mdx prameter passsing
  - 8
    - Activation I was testing around with a sample service broker app using activation, and came across an interesting question. The little app sends a series of four messages to a queue, either on the same conversation or on seperate ones. Each message invokes one stored procedure in my activation procedure. All the procedure does is enter a record into a test table and then wait for an allotted amount of time. In my example, the first message called a proc that waited 20 sec, the 2nd one that waited 10 seconds, the third 5 seconds, and the 4th 1 second. I am using internal activation on the queue. It seemed that in both scenarios (sending on 4 separate conversations and on one conversation) the procedures executed "almost" sequentially. "Almost" meaning that the first procedure was done before the last one started executing. It makes sense to me that this would happen where I sent them on the same conversation, but not really when I sent them on 4 seperate ones. Is it because when I call a procedure from my activation procedure it locks the queue so that another message cannot be processed (I'm processing a message at a time) How could I make it so that the 4th procedure (the one that only waits 1 second) returns before the 1st procedure (the one that waits 20 seconds) Tag: SSRS 2005 probplem with mdx prameter passsing
  - 9
    - Disable Save Changes prompt Is there a way in SQL Mgt Studio to disable the "Save changes to the following items " prompt that comes up every time I close a query window Tag: SSRS 2005 probplem with mdx prameter passsing
  - 10
    - Programatically adding a Timeout value for BulkInsertTask? I've searched around for a while and can't seem to find out how/where I set the timeout on a bulk insert task programmatically. Here is a snippet of code that works as long as the input file is pretty small....when I attempted to pump 1.3 million rows through the default timeout value was not big enough and a timeout exception occurred. Package loadPackage = new Package (); Stopwatch timer = new Stopwatch (); timer.Start(); ConnectionManager conMgr = loadPackage.Connections.Add( "FLATFILE" ); conMgr.ConnectionString = @"C:\BWR.txt" ; conMgr.Name = "FileInput" ; conMgr = loadPackage.Connections.Add( "ADO.NET:ODBC" ); conMgr.ConnectionString = @"Data Source=FOO;Initial Catalog=DestinationDb;Integrated Security=True;" ; conMgr.Name = "DestinationDB" ; TaskHost task = loadPackage.Executables.Add( "STOCK:BulkInsertTask" ) as TaskHost ; BulkInsertTask biTask = ( BulkInsertTask )task.InnerObject; biTask.UseFormatFile = true ; biTask.FormatFile = @"C:\BWR_1.fmt" ; biTask.SourceConnection = "FileInput" ; biTask.DestinationConnection = "DestinationDB" ; biTask.DestinationTableName = "StageBWR" ; biTask.BatchSize = 100; DTSExecResult result = loadPackage.Execute(); timer.Stop(); Console .WriteLine( string .Concat( "Process took(ms): " , timer.ElapsedMilliseconds.ToString())); Console .WriteLine(result.ToString()); if (loadPackage.Errors.Count > 0) { foreach ( DtsError error in loadPackage.Errors) { Console .WriteLine(error.Description); } } Again, the code above works just fine until we hit a timeout. There is no Timeout property on the BulkInsertTask class, nor can I see a way to set it on the Sql Connection. I don't even see them in the Connectionmanager.Properties collection for either the file connection or the database connection. Am I overlooking the obvious somewhere Tag: SSRS 2005 probplem with mdx prameter passsing
  - 11
    - MDX Query Help...Please Hi, I have a fact table containing the following columns: CustomerID RegionID CategoryID ItemID Price Relationships: A customer belongs to only one particular region and category Each customer can buy the same item at different prices The measures are LowPrice and AveragePrice Query For a particular customer, what was the customer price, average price and low price for some other combination of region and category ( this not the region and category,the customer belongs to) For ex: CutomerId RegionID CategoryID ItemID Price 1 1 2 1 2.00 2 2 3 1 6.00 3 2 3 1 4.00 Report should display for Customer 1 , Region 2 and Category 3 as ItemID Price LowPrice AveragePrice 1 2.00 4.00 5.00 Iam stuck with this query for a long time now...Any help on the query will be appreciated. Also, how would find the above result for all combinations of (regions and categories) Thanks, Prash Tag: SSRS 2005 probplem with mdx prameter passsing
  - 12
    - Maintenance Tasks didn't install Hi There I have just done my first clean install of SQL 2005. I have previously upgraded several boxes from SQL 2000 without incident. The clean install seemed to go fine but the Maintenance Tasks didn't install I have looked on the web but have been unable to unearth any information. Has anyone encountered this before and if so I how do I add Maintenance Tasks to the Management folder Tag: SSRS 2005 probplem with mdx prameter passsing
  - 13
    - AMO: Can't update dsv when delete a column Hi, friends, please have a look at this: I am using AMO, and I do this: 1 step: I drop a column from the source table by SQL: ALTER TABLE TargetTable Drop COLUMN ColumnName 2 step: I try to update the dsv by AMO: Dim adapter As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter( _ "SELECT * FROM [dbo].[" + tableName + "] WHERE 1=0", connection) Dim i As Integer For i = 0 To dsv.Schema.Tables.Count - 1 If dsv.Schema.Tables(i).TableName = "dbo_" & tableName Then MessageBox.Show("Before dsv.Schema.Tables.Count:" & dsv.Schema.Tables(i).Columns.Count) Dim dataTable As DataTable = adapter.FillSchema(dsv.Schema.Tables(i), SchemaType.Mapped) MessageBox.Show("After dsv.Schema.Tables.Count:" & dsv.Schema.Tables(i).Columns.Count) End If Next But, from the first messagebox and the second messagebox, I see the dsv is not updated after I delete the column. 3 step: I save the dsv to the server. If Mainform.tDatabase.DataSourceViews.Count > 0 Then Mainform.tDatabase.DataSourceViews(0).Update(Microsoft.AnalysisServices.UpdateOptions.ExpandFull) End If Then I check the server, the dsv still include the columnname I have deleted. Why and how to update the dsv after I delete a column Thanks! Tag: SSRS 2005 probplem with mdx prameter passsing
  - 14
    - File System Error after Restore Hi Guys, I have issues in restoring our Analysis Services database. Any help will be great. I took backups of our production olap database and Unfortunately, I had to restore next day and it didn't worked out very well. Restore process was successful but when I tried to Query database I was getting error - "File system error: The following error occurred while the \\ \F:\Program File( x86)\ Microsoft SQL Server\MSSQL.2\OLAP\Data\<Olap db name>.0.db\<Cube name>.0.cub\...........\4.fact.data' ... My cubes have 4 partitions. I used SSMS to back and restore. Used compressed option only. Let me know if I need to put more information. Thank you - Ashok Tag: SSRS 2005 probplem with mdx prameter passsing
  - 15
    - Creating Simple Report using Reporting Services SP2 and SharePoint 2007 Integration I've been running around in circles all afternoon trying to create one simple report using Reporting Services (with latest SP2 installed) and SharePoint 2007. To the best of my knowledge, I have everything configured correctly: When I access http://<server>/ReportServer , I see the server name of my SharePoint site. When I click on the name of my SharePoint site, it shows me the directory structure I have created within my SharePoint Site When I drill down in the directory, I can ultimately see the forms I created in my forms library (created via InfoPath 2007). The next step is to create one simple report from the data in one of these forms libraries and a report on all the items within a form library. I'm stuck at the first step of creating a report, namely what to enter as the Data Source and the connection string. With a SQL database this isn't an issue. How does one create a data source that will allow reporting over SharePoint content with the setup described above And, if you have information that is found in the SQL Books Online, please be kind and post links so others know where to find this information. Tag: SSRS 2005 probplem with mdx prameter passsing
  - 16
    - Parameter Valid Values I am deploying an rdl that is being deployed in a server.But i am encountering a problem regarding the valid values of the parameter.My parameters have dependencies,and one of my parameter comes out with two dependencies. Scenario : User needs to input his userID to access Book A. Book B needs Book A because the output will be depending on the its content. And Book C depend on Book B. Problem: when deploying, only Book A will have the initial value.The dependency in Book B is only one,which is fine.It shows its valid values. But how about for Book C which have 2 dependencies Because it doesnt show it's valid values.. Tag: SSRS 2005 probplem with mdx prameter passsing

lk_wick

hi ,
i am trying generate a report using following query. but the parameter is nt properly passing. (OLEDB). i need to correct it. pls help me.

="WITH "+

"MEMBER [Measures].[Amount] AS 'IIF(ISEMPTY([Measures].[Amount Usd]),0,[Measures].[Amount Usd])'"+

"SET [FilteredBUList] AS 'descendants((STRTOSET ( '{" & Join(Parameters!BU.Value,",") & "}', CONSTRAINED),[Account��BillingCodeDsc].[Billing Code Description],leaves) ' "+

"SET [CustomTimeSet] AS Descendants([Date��Fiscal].[2006].[Quarter 1]:"+
"[Date��Fiscal].[2007].[Quarter 4],[Date��Fiscal].[month],Leaves)"+

"SELECT "+
"{[Measures].[Amount]} ON COLUMNS,"+

"{ [FilteredBUList] "+
"}on rows"+

" FROM Profitability"

That BU parameter is multi value parameter. query should accept multi values .

Top

Re: SSRS 2005 probplem with mdx prameter passsing

Deepak Puri

Such expressions can be difficult to debug by visual inspection alone - I'd suggest temporarily adding a text box to your report, with its value set to the above expression. When you run the report, you'll see the actual query string generated. If the problem isn't obvious, posting this string here would be helpful.

Top

Re: SSRS 2005 probplem with mdx prameter passsing

lk_wick

i need to knw how the parameter should pass to this query.

Top