If you are using Analysis Services 2005 you can mark the key attribute in the attributes window(left) in the dimension editor.
In the properties window, down to the right, you will see a AttributeHierarchyVisible property that you set to false.
HTH
Thomas Ivarsson
|||Thank you very much! :-)sqlExpressions in the page header/footer can only reference report items on the current page. One thing to check is whether the hidden textbox in the report body is repeated on both pages? If the textbox only appears on the first page, expressions in the header/footer for the second page would always get a null value for this textbox.
sqlExpressions in the page header/footer can only reference report items on the current page. One thing to check is whether the hidden textbox in the report body is repeated on both pages? If the textbox only appears on the first page, expressions in the header/footer for the second page would always get a null value for this textbox.
I am trying to hide a group header (table row) based on the value of that group, but have not been able to get it working.
Let's say I have 2 groups in my table:
Group 1: State
Group 2: City
I want to hide the group header (tablerow2) where State = "Unknown" but I want the Group 2 cities to still display - just w/o a header.
I tried putting the following expressions on the hidden property of tablerow2 with no luck:
First I tried referencing the field that it's grouped on:
=Iif((Fields!state.Value = "Unknown", true, false)
I also tried refereing the name of the group:
=Iif(("State_GRP" = "Unknown"), true, false)
In both cases, nothing gets hidden - all rows, including the group header that says "Unknown", are visible.
Any help would be greatly appreciated!
Kathleen
You are doing this correctly, and I was not able to reporduce the behavior--it works as you are thinking. I would make sure that the case of "Unknown" is consistent with the field value. I would do this in the expression (or change the query to do the trimming), so that case and extranious white space is not a factor.
=IIF(Fields!state.Value.Trim().ToLower()="unknown", true, false)
Ian
|||Thanks Ian - the trim/tolower seemed to resolve whatever issue I was having.trying to login to ... SQL.Exception occurs
The result is SQL Server does not exist or access denied . . .
The code Im working with connection string is a forum fix from
http://p2p.wrox.com/topic.asp?TOPIC_ID37898
and the user account has been established.
<appSettings>
<add key="connection String" Value="server=(local)\MYSQLSERVERNAME; database=bids; Trusted_Connection=true"/>
</appSetting>
SQL Service Manager shows Server: SNOEMASTER
Services: MSSQLServerOLAPService
SQL Server Enterprise Manager indicates my SQL Server Group consists of
(local) (Windows NT)
and somewhere along the line I ran into something telling me to rename
(local) (windows NT) = MSSQLServer
Although when I do switch it over through the new registration wizard the connection fails. Stating MSSQLServer does not exist and come up with a error 1722 (RPC Server Unavailable) although in componet services it shows it running.
Initially I tried correctinig this because SQL SERVER repilcation does not support nicknames such as "." or (local) as server names and was given a message to
DELETE THE SQL SERVER REGISTRATION FOR THE SERVER AND REGISTER IT USING THE ACTUAL SERVER NAME MSSQLServer which component services confirmed in the properties tab "Dispaly Name" = MSSQLSERVER.
The problem seems to become two -fold because in the above connection string it maintains (local) as part of the string and instructs me to add on MYSQLSERVERNAME. ex. (local)\MYSQLSERVERNAME; database="bids"
Note: The database folder is named Bid.
Thanks for any input on this one anyone.
What you need to do is to replace MYSQLSERVERNAME with whatever your instance name is. If your SQL Server is the default instance, then user (local) or . directly rather than (local)\MSSQLSERVER or .\MSSQLSERVER
|||
Thank You!
i'm getting an access denied error but i can reset the user property from here. its better then the other errors I was recieving!
It clears up alot.! will make additional instance's of it in the future, one step at a time of course. I just installed SQL 2000 recently and want to make sure i have a solid understanding of what was happening.
http://192.168.1.65/Bid/default.aspx
icon_snowman
|||
After having reinstalled the Bid database and set the IUSR_SNOEMASTER permissions for the it from the SQL enterprise manager Bid \Properties\Security directory , i'm still recieving the double error . SQL server does not exist or access is denied..
I tried several combinations off the above resolution you mentioned but , not working yet. Will try Later.
On the second try I recieved a popup box to remember the passwaord and a confirmation that the user was added to the pool although checking the web.config file I realized I did not replace its original extension and had left it at web.txt to edit it.
Ohhhh is me
|||Latest SQL.Exception recieved using
<appSettings>
<add key="ConnectionString" value="server=(local);database=bids;Trusted_Connection=true" />
</appSettings>
Anyone have any ideas or previous same problem.?
icon_snowman
|||From your latest error, your client is able to find the SQL server. The new problem is that you login account may not have login privilege to the database "bids". In order to login successfully, the login account must have login priviledge to the initial database (i.e. bids for your case).|||In the above example the user (IUSER_SNOEMASTER) was left out of the connection string on purpose.
If I include the user in the connection string ( value="server=(local)\(IUSR_SNOEMASTER);databes=bids; . . . )then the error SQL Server does not exsist or access is denied to the user.
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.ConnectionPool.CreateConnection() at System.Data.SqlClient.ConnectionPool.UserCreateRequest() at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction
SQL Server Enterprise Manager:
Console Root|Microsoft SQL Servers|SQL Server Group|(local)(Windows NT)|Databases||bid|Users
In the right pane windows "Login Name" SNOEMASTER\ISUR_SNOEMASTER
"Database Access" status is Permit
If I use value="server=(local)\(SNOEMASTER\IUSR_SNOEMASTER); database=bids the following error occurs
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Access is denied: 'Bid'.
Source Error:
|
|
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
Using the code below:
<appSettings>
<add key="ConnectionString" value="server=(local);database=bids;Trusted_Connection=true" />
</appSettings>
<appSettings>
<add key="ConnectionString" value="server=.\;database=bids;Trusted_Connection=true" />
</appSettings>
The following error is created:
System.Data.SqlClient.SqlException: Cannot open database requested in login 'bids'. Login fails. Login failed for user 'SNOEMASTER\IUSR_SNOEMASTER'. at System.Data.SqlClient.ConnectionPool.CreateConnection() at System.Data.SqlClient.ConnectionPool.UserCreateRequest() at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction
|||
server=(local)\(IUSR_SNOEMASTER);
Here (IUSR_SNOEMASTER) should be the instance name, NOT USER ACCOUNT. If your SQL Server is a default instance, then just use "(local)" or "." The client user account is determined by under which Windows account your client application is running if Windows authentication is used. From your last exemple, it looks like you have a default instance and your client app is running under 'SNOEMASTER\IUSR_SNOEMASTER'. So, you need to make sure this account has login priviledge to database "bids", as I said before.
OK Have Login Working:
<appSettings>
<add key="ConnectionString" value="server=(local);database=Bid;Trusted_Connection=true" />
</appSettings>
The problem was that the database=bids was not allowing it to access the Bid folder.
Initially building the data base as prescribed in the http://p2p.wrox.com/toTOPIC_ID=37898 pic.asp?the query uses a plural version of the database "bids" so I continued with this in the connection string. Doesnt work. I read about two lines in the SQL Server Books Online stating that the database names are case sensitive and made the adjustment from bids=Bid and a slight adjustment in the permissions by :
Console Root|Microsoft SQL Servers|(local)(Windows NT)|Databases|bid
In the right-hand pane right clicked properties, highlight SNOEMASTER\IUSR_SNOEMASTER
Clicked Permissions and set settings as instructed http://p2p.wrox.com/toTOPIC_ID=37898 pic.asp?
Clicked Ok then clicked Properties on the bottom. Check that Public is selected.(For what ever reason mine was not. Possibly an over sight having reinstalled the database and permissions.)
Once again set the settings as instructed http://p2p.wrox.com/toTOPIC_ID=37898 pic.asp?and clicked apply and OK and everything seems to be running as it is supposed to.
Thank You Xinwei Hong your response helped me sort it out. Knowing better I should have immediately changed bids=Bid If you recall I made a note of this in my first post at the bottom of the name difference.
I am having difficulties working with SQL Server SmallDataTime...
I use TransactionDate as smalldatetime.. Now for reporting purpose my client needs
date as ccyymmdd format and
time as hhmmss format
I am able to get date in ccyymmdd using
CONVERT(varchar(8), @.fDate, 112) )
How do I get time in hhmmss format .. its little urgent pls help...
I tried using DATEPART(hh, @.fDate) DATEPART(mm, @.fDate) DATEPART(ss, @.fDate)
how do I make one string of hhmmss..
Is there a better way?How about this:
replace(Convert (varchar(8),GetDate(), 108),':','')
Is it going to work for you?
First, you get hh:mm:ss and then you replace : with empty string.|||
select convert(varchar, getdate(), 108)
hth|||Waow.. Replace convert combo worked perfectly fine..
Thx....|||Another problem I am running into is this
if I write SELECT LEN('2000') I get answer = 4
However I write function for this I get wrong answer... I always get 1
Here is my function.. can anyone tell whats wrong?
CREATE FUNCTION fnc_GetLen (@.str nvarchar)
RETURNS nvarchar(10)
AS
BEGIN
DECLARE @.L nvarchar(10)
SET @.L = LEN(@.str)
RETURN (@.L)
END|||Not so sure what the purpose of this function since it does exactly what LEN does.
Anyway, the problem is you did not give a length on the input string. Try change to this:
|||I just need to find length.. once I find length I do processing inside that function.. like appending 0's or spaces etc..
CREATE FUNCTION fnc_GetLen (@.str nvarchar(500))
I will give it a try.. thanks|||also your return type should be int and not nvarchar.
RETURNS int
hth|||Return nvarchar worked perfectly fine. No Problem at all...
I am using padding function and its giving me nightmare when I use blank space (white space) as padding char. Can you see whats wrong?
CREATE FUNCTION fnc_AddPadding ( @.text nvarchar(30), @.padChar char(1), @.maxLen int, @.padType char(1))
RETURNS nvarchar(50)
AS
BEGIN
DECLARE @.resultText nvarchar(50)
SET @.resultText = ''
-- Left Padding
IF @.padType = 'L'
BEGIN
SET @.resultText =RIGHT( REPLICATE ( @.padChar, @.maxLen) + @.text, @.maxLen )
END
-- Right Padding
IF @.padType = 'R'
BEGIN
SET @.resultText = LEFT( @.text + REPLICATE ( @.padChar, @.maxLen) , @.maxLen )
END
-- No Padding
IF @.padType not in ( 'R', 'L')
BEGIN
SET @.resultText = NULL
END
RETURN @.resultText
END
For every other padding char it works ok.. but when I use white space as pad char it is bad...
My Return Type nvarchar(50) or nvarchar(512) and mann..... instead of 5 - 10 white space I end up with 50 or 512 white space...
Create a stored procedure called spDepartmentAddUpdate. This procedure
accepts two parameters: Name, and GroupName. The data types are
VarChar(50), and VarChar(50) respectively. Define logic in this
procedure to check for an existing Department record with the same Name.
If the department record exists, update the GroupName and ModifiedDate.
Otherwise, insert a new department record.
A.Execute your stored procedure to show that the insert logic works.
B.Execute your stored procedure to show that the update logic works.
Any hints from the wizards out there would be greatly appreciated!
*** Sent via Developersdex http://www.developersdex.com ***Nep Tune (neptuneca@.go.com) writes:
Quote:
Originally Posted by
It goes like the following:
Use AdventureWorks database and HumanResources.Department table.
>
Create a stored procedure called spDepartmentAddUpdate. This procedure
accepts two parameters: Name, and GroupName. The data types are
VarChar(50), and VarChar(50) respectively. Define logic in this
procedure to check for an existing Department record with the same Name.
If the department record exists, update the GroupName and ModifiedDate.
Otherwise, insert a new department record.
>
A. Execute your stored procedure to show that the insert logic works.
B. Execute your stored procedure to show that the update logic works.
>
Any hints from the wizards out there would be greatly appreciated!
But permit me to not that the parameters to the procedure should really
be nvarchar(50) and not varchar(50) to go along with the table definition.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||YOU WRITE:
you should talk to the teacher, rather than sneak behind his back. Your
teacher knows what you are supposed to know, and what you yet have to
learn.
I WRITE:
Well, thanks for the suggestions. You and my teacher ought to team
teach; I'd learn about the same from both of you: NOTHING!
*** Sent via Developersdex http://www.developersdex.com ***|||Nep Tune (neptuneca@.go.com) writes:
Quote:
Originally Posted by
I WRITE:
Well, thanks for the suggestions. You and my teacher ought to team
teach; I'd learn about the same from both of you: NOTHING!
On a more serious note, newsgroups are not the best place to learn. If
someone asks a "how do I write this query", it can be fairly simple to
write that query, provided that the question is clear enough. But
explaining what is actually happening can be a lot more difficult, and
I usually don't do that in my posts. That's OK if the poster has some
experience and has run into a little more difficult problem at work.
If he is interested he will try to understand the solution and use it.
If he is not interested, well at least he got help with doing his part
in his work. After all, it could be that SQL is something he does left-
hand and his main skills are with VB, C++ or whatever. And I would expect
him to be able to write the procedure you were asked to.
Anyway, some hints: you will need to use INSERT and UPDATE. You will also
learn to master IF EXISTS. If you ever grow up to be a developer, you
will write tons of such procedures in your career! :-)
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On 12 Aug 2006 13:59:56 GMT, Nep Tune <neptuneca@.go.comwrote:
Quote:
Originally Posted by
>YOU WRITE:
>you should talk to the teacher, rather than sneak behind his back. Your
>teacher knows what you are supposed to know, and what you yet have to
>learn.
>I WRITE:
>Well, thanks for the suggestions. You and my teacher ought to team
>teach; I'd learn about the same from both of you: NOTHING!
The "sp-" prefix violates ISO-11179 rules. Even Microsoft gave up on
camelCase because it is a bitch to read.
Quote:
Originally Posted by
Quote:
Originally Posted by
>This procedure accepts two parameters: Name, and GroupName. <<
Quote:
Originally Posted by
Quote:
Originally Posted by
>The data types are VarChar(50), and VarChar(50) respectively. <<
Quote:
Originally Posted by
Quote:
Originally Posted by
> Define logic in this procedure to check for an existing Department record [sic] with the same Name [was this the key in the DDL you did not post?]. If the department record [sic] exists, update the GroupName and ModifiedDate. Otherwise, insert a new department record [sic]. <<
No auditor will allow you to put "modified_date" in a table. Audit
trails have to be separate from the data by law (see SOX compliance
rules), by GAAP and by common sense.
Quote:
Originally Posted by
Quote:
Originally Posted by
>Any hints from the wizards out there would be greatly appreciated! <<
Quote:
Originally Posted by
Quote:
Originally Posted by
Quote:
Originally Posted by
>>The data types are VarChar(50), and VarChar(50) respectively. <<
Quote:
Originally Posted by
No auditor will allow you to put "modified_date" in a table. Audit
trails have to be separate from the data by law (see SOX compliance
rules), by GAAP and by common sense.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Hi,
I am working in Share point service now.
I created a website using share point.
I worked in mining algorithms in sqlserevr 2005.
I am able to view scorecard, BIP in my website.
My Question is:
I am having a forecasting model developed using Time series algorithm in Sqlserver 2005.
I need viewer to view my forecasting model, I created.
Plz suggest me any viewer like DataAnalyzer, to view my forecasting model.
Tx in Advance!
Was your question answered in the newsgorup, or do you still need more information?
Realistically you can use any charting control and simply query the model for the data if the redistributable viewers don't work for you.
|||Hai,
I used pivot table OWC to show my data.
Unfortunately, it doenot work with DMX query.
But spreadsheet OWC accepts DMX query. why not pivot table?
I need some solution to run my DMX query and give as input to my chart/pivot control.
plz help me.
its urgent
Tx in advance.
|||You will have to write some custom Excel code (you can find samples on sqlserverdatamining.com) to execute the DMX query and put it in a worksheet. Then you can put the result into an Excel pivot tableHi,
I am working in Share point service now.
I created a website using share point.
I worked in mining algorithms in sqlserevr 2005.
I am able to view scorecard, BIP in my website.
My Question is:
I am having a forecasting model developed using Time series algorithm in Sqlserver 2005.
I need viewer to view my forecasting model, I created.
Plz suggest me any viewer like DataAnalyzer, to view my forecasting model.
Tx in Advance!
Was your question answered in the newsgorup, or do you still need more information?
Realistically you can use any charting control and simply query the model for the data if the redistributable viewers don't work for you.
|||Hai,
I used pivot table OWC to show my data.
Unfortunately, it doenot work with DMX query.
But spreadsheet OWC accepts DMX query. why not pivot table?
I need some solution to run my DMX query and give as input to my chart/pivot control.
plz help me.
its urgent
Tx in advance.
|||You will have to write some custom Excel code (you can find samples on sqlserverdatamining.com) to execute the DMX query and put it in a worksheet. Then you can put the result into an Excel pivot table