Hi all,
I've created a KPI and it is working correctly, however, I don't see it in the cube browser under the measures group? Where can I set the property to have it appear?
Thanks,
Mark
You can see KPI on "Browser View" mode on KPI's tab or sending an MDX query from the SQL Server Management Studio.
Francesco
|||Thanks Francesco, I do see it there. How can I get it to render via an Excel (2007) pivot table? I recall having generated one when I was using the Beta version of 2007.I know my problem is not directly associated w/ SSIS, so please forgive the post here. I figured this would be the "most" appropriate place to post this challenge.
We're attempting to edit a 2000 DTS package in Design mode from within the 2005 SQL Management Studio. To do this we downloaded/installed the following packages from the MS download site:
Microsoft SQL Server 2000 DTS Designer Components
Microsoft SQL Server 2005 Backward Compatibility Components
We're able to open the package in design mode from the Management Studio (Server > Management > Legacy > Data Transformation Services > DTS Package Name). But, when the DTS designer is open, the backspace and arrow keys won't respond in the Management Studio. They begin responding when we close the DTS designer. There are no error messages when we close the DTS designer.
Does anyone know of a fix or a workaround? Any help would be greatly appreciated.
Thanks, Mike
Do you have the Logitech MX5000 BlueTooth keyboard/mouse? I encountered this problem just yesterday and assumed it was my bluetooth connection going in and out.
That is very strange...
|||Nope, I have a wired Compaq keyboard. My colleague has the same problem w/ a different brand of wired keyboard.|||If you do a search there are a lot of people that have had problems with this component. It hosed enterprised manager on my machine and one of my co-workers. Even when it installed correctly a bunch of us still got errors opening packages. So far the only solution I've heard is to grin and bear it.|||Thanks for the feedback, this was identified as a bug and was fixed. The fix will be in the next release after SP1
wenyang
|||
Is this fix out yet?
|||I saw a reference to this recently which indicated it was fixed in SP2, or the associated feature pack. That is currently released as a CTP, so you may wish to risk it. I cannot find the source niow, which is rather annoying...
Download details: Feature Pack for SQL Server 2005 SP2 CTP
(http://www.microsoft.com/downloads/details.aspx?FamilyID=7A9AD90F-7F95-4369-A206-E84053D63FD3&displaylang=en)
Thanks,
but unfortunately, the same behavior is happening with the CTP version of the dts designer :(
Table of course takes this form key | value
----------
config_setting1 | value1
config_setting2 | value2
I'm working with a System.Collections.Specialized.StringDictionary Class object which contains all of the pairs from my webform... anybody have a creative way to build an UPDATE string using this object?
Thanks for any help and suggestions,
ecolner@.yahoo.comI suggest you to create static method to your database class that updates the configuration. The idea is simple.
1) Create parameterized SqlCommand for updates (update conf set value=@.value where setting=@.setting).
2) Start database transaction.
3) Iterate through you string dictionary and on every turn evaluate @.value and @.setting parameters again and then execute the command.
4) If there is errors then roll back database changes, otherwise commit the changes
5) Dispose the update command
Anyone gotten Kerberos delegation working in an extranet scenario?
We've followed the instructions outlined here:
http://support.microsoft.com/default.aspx/kb/917409
http://www.mosha.com/msolap/articles/kerberos_delegation.htm
Kerberos delegation is working as long as the user's browser has the website in the Intranet Zone (so that it automatically logs them on). If the website is not in the Intranet Zone, it prompts them to type in their Active Directory credentials, they're able to connect with the website fine once they've entered their credentials, but then Kerberos delegation doesn't succeed.
I don't want to get into detail in troubleshooting Kerberos tickets in this forum. Just wondering if anybody else has run across this problem and found a fix/workaround.
For internal users, we can ensure the website is in the Intranet Zone. This won't work for external users (a) because they have logged onto their laptop with credentials from a different domain and (b) we can't control their IE browser settings.
Hello! If you are talking about reports build on top of SSAS2005 this issue can be related to NTFS(file system) issues.
If you build a report in a client tool and save it to disk you will have prompts for user credentails for outsiders.
If you build a report with a HTTP connection to SSAS2005 with a third party tool it can work.
Kerberos is for authenticating users between two servers?
Regards
Thomas Ivarsson
|||Thomas-
Kerberos delegation is needed is so that we can put SSAS on a separate server than our web server. There will be several web servers. One for SSRS and one for PerformancePoint. Both web servers need to support passing through the authenticated user's credentials all the way to the cube (so that cube security will work as designed).
The testing we've done thus far is with SSRS as the web server and a report that hits the cube using the authenticated user's credentials. That's the scenario I described above where we're seeing the Intranet Zone thing.
Can you elaborate on the NTFS file system issues or provide a link?
Users don't need to connect directly to SSAS (just through a SSRS or PP) so I'm thinking we don't need to turn on HTTP connectivity for SSAS. But if that helps workaround kerberos restrictions or something, let me know.
Thanks for the reply.
|||Furmangg:
I have read your post once again:
All external users have an account in AD?
Quote:
"This won't work for external users (a) because they have logged onto their laptop with credentials from a different domain and (b) we can't control their IE browser settings"
It is about IE settings? You have a setting like "Allow database connections across domains" . This is disabled in IE7.
HTH
Thomas Ivarsson
|||Thomas-
Yes, external users will have an account in our company's AD in this particular deployment. But they don't sign into their laptop with our company's AD... they sign into their laptop under their company's AD... then when they pull up our extranet, they're prompted to login as someone in our company's AD. And that, from what I've read, won't allow Kerberos.
As for the "Allow database connections across domains" setting in IE, I don't think that applies. We're talking about thin-client web apps. If I understood that setting correctly, it's for thicker client web apps which are doing fancy stuff like databinding inside the webpage with ActiveX or something: http://www.microsoft.com/technet/prodtechnol/ie/ieak/techinfo/deploy/60/en/secopt.mspx?mfr=true
|||I got some help from a number of smart people and the following two options look promising:
1. ISA 2006
http://www.microsoft.com/technet/isa/2006/authentication.mspx
2. Protocol Transition
http://justpickanything.adopenstatic.com/cs/blogs/ken/archive/2007/07/18/8460.aspx
Just wanted to give everyone an update.
Anyone gotten Kerberos delegation working in an extranet scenario?
We've followed the instructions outlined here:
http://support.microsoft.com/default.aspx/kb/917409
http://www.mosha.com/msolap/articles/kerberos_delegation.htm
Kerberos delegation is working as long as the user's browser has the website in the Intranet Zone (so that it automatically logs them on). If the website is not in the Intranet Zone, it prompts them to type in their Active Directory credentials, they're able to connect with the website fine once they've entered their credentials, but then Kerberos delegation doesn't succeed.
I don't want to get into detail in troubleshooting Kerberos tickets in this forum. Just wondering if anybody else has run across this problem and found a fix/workaround.
For internal users, we can ensure the website is in the Intranet Zone. This won't work for external users (a) because they have logged onto their laptop with credentials from a different domain and (b) we can't control their IE browser settings.
Hello! If you are talking about reports build on top of SSAS2005 this issue can be related to NTFS(file system) issues.
If you build a report in a client tool and save it to disk you will have prompts for user credentails for outsiders.
If you build a report with a HTTP connection to SSAS2005 with a third party tool it can work.
Kerberos is for authenticating users between two servers?
Regards
Thomas Ivarsson
|||Thomas-
Kerberos delegation is needed is so that we can put SSAS on a separate server than our web server. There will be several web servers. One for SSRS and one for PerformancePoint. Both web servers need to support passing through the authenticated user's credentials all the way to the cube (so that cube security will work as designed).
The testing we've done thus far is with SSRS as the web server and a report that hits the cube using the authenticated user's credentials. That's the scenario I described above where we're seeing the Intranet Zone thing.
Can you elaborate on the NTFS file system issues or provide a link?
Users don't need to connect directly to SSAS (just through a SSRS or PP) so I'm thinking we don't need to turn on HTTP connectivity for SSAS. But if that helps workaround kerberos restrictions or something, let me know.
Thanks for the reply.
|||Furmangg:
I have read your post once again:
All external users have an account in AD?
Quote:
"This won't work for external users (a) because they have logged onto their laptop with credentials from a different domain and (b) we can't control their IE browser settings"
It is about IE settings? You have a setting like "Allow database connections across domains" . This is disabled in IE7.
HTH
Thomas Ivarsson
|||Thomas-
Yes, external users will have an account in our company's AD in this particular deployment. But they don't sign into their laptop with our company's AD... they sign into their laptop under their company's AD... then when they pull up our extranet, they're prompted to login as someone in our company's AD. And that, from what I've read, won't allow Kerberos.
As for the "Allow database connections across domains" setting in IE, I don't think that applies. We're talking about thin-client web apps. If I understood that setting correctly, it's for thicker client web apps which are doing fancy stuff like databinding inside the webpage with ActiveX or something: http://www.microsoft.com/technet/prodtechnol/ie/ieak/techinfo/deploy/60/en/secopt.mspx?mfr=true
|||I got some help from a number of smart people and the following two options look promising:
1. ISA 2006
http://www.microsoft.com/technet/isa/2006/authentication.mspx
2. Protocol Transition
http://justpickanything.adopenstatic.com/cs/blogs/ken/archive/2007/07/18/8460.aspx
Just wanted to give everyone an update.
Anyone gotten Kerberos delegation working in an extranet scenario?
We've followed the instructions outlined here:
http://support.microsoft.com/default.aspx/kb/917409
http://www.mosha.com/msolap/articles/kerberos_delegation.htm
Kerberos delegation is working as long as the user's browser has the website in the Intranet Zone (so that it automatically logs them on). If the website is not in the Intranet Zone, it prompts them to type in their Active Directory credentials, they're able to connect with the website fine once they've entered their credentials, but then Kerberos delegation doesn't succeed.
I don't want to get into detail in troubleshooting Kerberos tickets in this forum. Just wondering if anybody else has run across this problem and found a fix/workaround.
For internal users, we can ensure the website is in the Intranet Zone. This won't work for external users (a) because they have logged onto their laptop with credentials from a different domain and (b) we can't control their IE browser settings.
Hello! If you are talking about reports build on top of SSAS2005 this issue can be related to NTFS(file system) issues.
If you build a report in a client tool and save it to disk you will have prompts for user credentails for outsiders.
If you build a report with a HTTP connection to SSAS2005 with a third party tool it can work.
Kerberos is for authenticating users between two servers?
Regards
Thomas Ivarsson
|||Thomas-
Kerberos delegation is needed is so that we can put SSAS on a separate server than our web server. There will be several web servers. One for SSRS and one for PerformancePoint. Both web servers need to support passing through the authenticated user's credentials all the way to the cube (so that cube security will work as designed).
The testing we've done thus far is with SSRS as the web server and a report that hits the cube using the authenticated user's credentials. That's the scenario I described above where we're seeing the Intranet Zone thing.
Can you elaborate on the NTFS file system issues or provide a link?
Users don't need to connect directly to SSAS (just through a SSRS or PP) so I'm thinking we don't need to turn on HTTP connectivity for SSAS. But if that helps workaround kerberos restrictions or something, let me know.
Thanks for the reply.
|||Furmangg:
I have read your post once again:
All external users have an account in AD?
Quote:
"This won't work for external users (a) because they have logged onto their laptop with credentials from a different domain and (b) we can't control their IE browser settings"
It is about IE settings? You have a setting like "Allow database connections across domains" . This is disabled in IE7.
HTH
Thomas Ivarsson
|||Thomas-
Yes, external users will have an account in our company's AD in this particular deployment. But they don't sign into their laptop with our company's AD... they sign into their laptop under their company's AD... then when they pull up our extranet, they're prompted to login as someone in our company's AD. And that, from what I've read, won't allow Kerberos.
As for the "Allow database connections across domains" setting in IE, I don't think that applies. We're talking about thin-client web apps. If I understood that setting correctly, it's for thicker client web apps which are doing fancy stuff like databinding inside the webpage with ActiveX or something: http://www.microsoft.com/technet/prodtechnol/ie/ieak/techinfo/deploy/60/en/secopt.mspx?mfr=true
|||I got some help from a number of smart people and the following two options look promising:
1. ISA 2006
http://www.microsoft.com/technet/isa/2006/authentication.mspx
2. Protocol Transition
http://justpickanything.adopenstatic.com/cs/blogs/ken/archive/2007/07/18/8460.aspx
Just wanted to give everyone an update.
I am using RS2005.
KeepTogether=true is not working both in the Preview tab nor when I export to PDF.
My tables still get split by a page break.
RepeatHeaderOnNewPage works as expected.
For a while I was simply putting each table on its own page, but this is such a tacky solution.
Any ideas?
As of now, repeating header on every new page is the only solution.
Shyam
|||OK.
Thanks Shyam.
|||So, can you please mark the post as answer?
Shyam
I am using RS2005.
KeepTogether=true is not working both in the Preview tab nor when I export to PDF.
My tables still get split by a page break.
RepeatHeaderOnNewPage works as expected.
For a while I was simply putting each table on its own page, but this is such a tacky solution.
Any ideas?
As of now, repeating header on every new page is the only solution.
Shyam
|||OK.
Thanks Shyam.
|||So, can you please mark the post as answer?
Shyam
I selected "Repeat Group Header" in my grouping properties. This is working fine; however, if a group is to start as the last line in a page, the header prints on that last line and then the header is printed once more in the next page. Consequently I end up with two consecutive headers with no detail lines in between.
How do I prevent the printing of two consecutive headers for the same group? I want to get rid of the one that occurs as the last line on the page.
Thanks, Shyam.
The dropdown would not accept a selection of the same group.
I tried other selections, but did not work.
JR.
|||If there is only one such situation in your report, try increasing the height of the detail or the header so that it is stretched to the next page.|||Thanks for the reply. I appreciated you trying to help me.
I found this problem in several reports and the problem repeats a few times in each report.
I tried your suggestion, it was a good thought, but did not work. It shifted the problem to a different page.
Do you have another suggestion ?
|||For all the textboxes in the group header, select hide duplicates and select that group in the dropdown below that. It's just a suggestion which may or may not work.
Shyam
