Display a KPI need the same Dimension on its Value and Target?

I mean, I have a KPI, it's value is set to a measure of a measuregroup based on a facttable A. and it's Target is set to a measure of another measuregroup based on another facttable B.

Now I want to display the KPI, with a given dimension's slice. My question is, is it needed that the dimension I chose must be shared by both the measures of KPI's Value and Target? For an example, If I dispaly the KPI with the Promotion Dimention, and the Promotion Dimention has a relation to the KPI's Value's related measure(There's a PromotionKey column in facttable A; ), but it has no relation to the KPI's Target's related measure(There's NOT a PromotionKey column in facttable B).

Could I do so?

I think this is SSAS question. I moved it to the SSAS forum...|||

OK.

Help, Help! Thanks.

|||

The KPI should work similarly to the underlying measures - so, in your example, the KPI Target behavior will depend on how the IgnoreUnrelatedDimensions property of the "facttable B" Measure Group is set. If true (default), then the KPI Target should be unaffected by slicing the Promotion dimension; if false, the KPI Target should become null.

http://sqljunkies.com/WebLog/mosha/archive/2005/12/31/cube_init.aspx

>>

Default members, MDX Scripts, Security, KPIs and Perspectives

...

KPI trigger creation of hidden calculated measures only if the MDX expression for the KPI property is not a simple reference to some measure (either calculated or physical). However, if the expression is a simple reference, such as [Measures].[Sales], then no hidden calculated measure will be created, and KPIValue, KPIGoal, KPITrend etc functions will simply return that measure.

>>

http://msdn2.microsoft.com/en-us/library/ms365411.aspx

>>

Configuring Measure Group Properties

...

IgnoreUnrelatedDimensions

Determines whether unrelated dimensions are forced to their top level when members of dimensions that are unrelated to the measure group are included in a query. Default setting is True.

>>

|||Thanks! that's what i am looking for! Thank you, Puri.

Display a image based on a value field

Hello friends
I have a problem displaying a picture on a table detail based on a value of
a column.
If this column have a value greather than 10, show a image, else show
another image. I don't know how to call the images on the statement below
=IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
I've added the images to the project as a embedded images.
Can anyone please help me or give me an example?
Thanks for Help
BrunoI only know one line of VB code, which is what I use to show/hide
report elements. Maybe you can use it to help you write yours to work
the way it needs to.
=IIF(Parameters!ReportGroup.Value = 1 AND Parameters!ReportType.Value =1, False, True)|||Hi Bruno
I'm only a novice, but this works:
Create two identical table rows, one below the other, each row has one cell
showing the (same) database field - e.g. "ID" and one cell to hold the
appropriate image - row 1 holds image1, row2 holds image2.
Now set the visibility of each row using expressions:
row1: =iif(Fields!ID.value<10,true,false)
row2: =iif(Fields!ID.value>=10,true,false)
when you run the report, the rows will be visible with the appropriate
images appearing as the ID.values change
~grasshopper~
"Bruno" wrote:
> Hello friends
> I have a problem displaying a picture on a table detail based on a value of
> a column.
> If this column have a value greather than 10, show a image, else show
> another image. I don't know how to call the images on the statement below
> =IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
> I've added the images to the project as a embedded images.
> Can anyone please help me or give me an example?
> Thanks for Help
> Bruno|||Create an image control on the report, make it show one of the images
you've embedded. In the properties of the image, you should be able to
see how the image is referred to in the "value" property. Now wrap the
=IIf statement around this. The image name will have to be in double
quotes because you are passing a string value to the property. For
example;
=IIf(Fields!DIAS.Value > 10, "Image1.gif", "Image2.gif")
If you wanted to show now image you could do;
=IIf(Fields!DIAS.Value > 10, Nothing, "Image2.bmp")
I haven't tried this but see no reason it shouldn't work for both
RS2000 or RS2005.
Cheers
Chris
Bruno wrote:
> Hello friends
> I have a problem displaying a picture on a table detail based on a
> value of a column.
> If this column have a value greather than 10, show a image, else show
> another image. I don't know how to call the images on the statement
> below
> =IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
> I've added the images to the project as a embedded images.
> Can anyone please help me or give me an example?
> Thanks for Help
> Bruno

Disk level encryption

G/Day forum,
I've been asked to find a disk level encryption software, that will be
installed on a Windows 2000 based file server, and basically encrypt credit
card data thats
stored on disk. In this case EFS isn't sufficient.
So far I've only looked at one product: NetLib Encryptionizer DE (
http://www.netlib.com/file-encryption.shtml ). Does anyone have any opinions
on this product? Alternatives?
Regards,
Steve.PGP Disk with a 2048 bit key should do it.
- Mark Randall
http://zetech.swehli.com
"The Poster" <nospam@.nospam_dontyoudare.net> wrote in message
news:%234TfDq7hFHA.1248@.TK2MSFTNGP12.phx.gbl...
> G/Day forum,
> I've been asked to find a disk level encryption software, that will be
> installed on a Windows 2000 based file server, and basically encrypt
> credit
> card data thats
> stored on disk. In this case EFS isn't sufficient.
> So far I've only looked at one product: NetLib Encryptionizer DE (
> http://www.netlib.com/file-encryption.shtml ). Does anyone have any
> opinions
> on this product? Alternatives?
> Regards,
> Steve.
>|||Hi
Ask the vendor if they support SQL Server on it.
Any reason why you want to encrypt the disk? If a user with the correct
permissions copies the DB off that disk, your data is open. Your backup is
open too.
Rather encrypt the data in the application before you save it into the DB.
Then only the application can get to it.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"The Poster" <nospam@.nospam_dontyoudare.net> wrote in message
news:%234TfDq7hFHA.1248@.TK2MSFTNGP12.phx.gbl...
> G/Day forum,
> I've been asked to find a disk level encryption software, that will be
> installed on a Windows 2000 based file server, and basically encrypt
> credit
> card data thats
> stored on disk. In this case EFS isn't sufficient.
> So far I've only looked at one product: NetLib Encryptionizer DE (
> http://www.netlib.com/file-encryption.shtml ). Does anyone have any
> opinions
> on this product? Alternatives?
> Regards,
> Steve.
>|||Hi Mike,
The reason I want to encrypt the contents of the disk (remember its a file
server not a database server) is because its a requirement for the PCI
Credit Card security standard.
NetLib seem to lead the way when it comes to providing encryption software,
and they understand the security standard.
Regards,
Steve.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:espnhh9hFHA.1444@.TK2MSFTNGP10.phx.gbl...
> Hi
> Ask the vendor if they support SQL Server on it.
> Any reason why you want to encrypt the disk? If a user with the correct
> permissions copies the DB off that disk, your data is open. Your backup is
> open too.
> Rather encrypt the data in the application before you save it into the DB.
> Then only the application can get to it.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "The Poster" <nospam@.nospam_dontyoudare.net> wrote in message
> news:%234TfDq7hFHA.1248@.TK2MSFTNGP12.phx.gbl...
>|||Check out http://beyondifsolutions.com/html/catalog1.html
Excellent encryption, negligible processing overhead and affordable.
"The Poster" wrote:

> Hi Mike,
> The reason I want to encrypt the contents of the disk (remember its a file
> server not a database server) is because its a requirement for the PCI
> Credit Card security standard.
> NetLib seem to lead the way when it comes to providing encryption software
,
> and they understand the security standard.
> Regards,
> Steve.
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:espnhh9hFHA.1444@.TK2MSFTNGP10.phx.gbl...
>
>sql

Disable the "All" option in a parameter

Does anyone know how to disable the option "All" in a parameter which is in a 2005 reporting Services Report based on a 2005 AS Cube?

Thanks in advance,

Pieter

The only way I found, is to build another dataset based on sql query returning the same data.
Regards
Ayzan
|||

Thanks for your reply

This is not a good option because the options given in the parameter have to be limited by the role which the cube user is in.

But thanks anyway.

Pieter

|||

If your roles are correctly set, the "All" option will displays informations for all the items your user can access.

Regards

Ayzan

|||

Yes that is correct, but it does not give me the solution for my problem.

From Microsoft I got this information: "The <Select All> option in the parameter drop down is only a UI item. This will be removed with the SP1 release. "

So 'll wait for the SP I guess!

Thanks for your help!

disable all SA accounts remotly - access only for low user ?

Hi,
I need to access my web based SQL 2005 express edition database on 1433
using a user with minimal privileges that can only run a stored procedure. I
do this by connecting to IP / port.
Is there anyway I can disable SA using this same method but still allow SA
when I remote desktop to the machine and connect using Management Studio
Express.
I.e if I disable the account the SA account or other admin accounts I cant
login when I RDP into the machine.
The minimal privileges user can simply run a single stored procedure but
must do using 1433.
I just need to disable 1433 access for all other accounts and cant figure
out how to (I guess Management Studio Express connects using 1433 anyway so
im stuck).
If this is the case I guess I need to use SQLXML.
Thanks for any help
Scott
I'm not sure, but you could try playing with something like:
DENY CONNECT ON ENDPOINT::TCP TO "sa"
(Check BOL for exact syntax)
I'm not sure whether such permissions are actually checked for sysadmins (let us know after your
test), and of course, you'd have to make sure some other netlib is used when inside the private
network (like Shared Memory, which only work locally).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scott" <www.sage-eshop.com> wrote in message news:O$T7b0J3GHA.4764@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to access my web based SQL 2005 express edition database on 1433 using a user with minimal
> privileges that can only run a stored procedure. I do this by connecting to IP / port.
> Is there anyway I can disable SA using this same method but still allow SA when I remote desktop
> to the machine and connect using Management Studio Express.
> I.e if I disable the account the SA account or other admin accounts I cant login when I RDP into
> the machine.
> The minimal privileges user can simply run a single stored procedure but must do using 1433.
> I just need to disable 1433 access for all other accounts and cant figure out how to (I guess
> Management Studio Express connects using 1433 anyway so im stuck).
> If this is the case I guess I need to use SQLXML.
> Thanks for any help
> Scott
>

disable all SA accounts remotly - access only for low user ?

Hi,
I need to access my web based SQL 2005 express edition database on 1433
using a user with minimal privileges that can only run a stored procedure. I
do this by connecting to IP / port.
Is there anyway I can disable SA using this same method but still allow SA
when I remote desktop to the machine and connect using Management Studio
Express.
I.e if I disable the account the SA account or other admin accounts I cant
login when I RDP into the machine.
The minimal privileges user can simply run a single stored procedure but
must do using 1433.
I just need to disable 1433 access for all other accounts and cant figure
out how to (I guess Management Studio Express connects using 1433 anyway so
im stuck).
If this is the case I guess I need to use SQLXML.
Thanks for any help
ScottI'm not sure, but you could try playing with something like:
DENY CONNECT ON ENDPOINT::TCP TO "sa"
(Check BOL for exact syntax)
I'm not sure whether such permissions are actually checked for sysadmins (le
t us know after your
test), and of course, you'd have to make sure some other netlib is used when
inside the private
network (like Shared Memory, which only work locally).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scott" <www.sage-eshop.com> wrote in message news:O$T7b0J3GHA.4764@.TK2MSFTNGP05.phx.gbl...[
vbcol=seagreen]
> Hi,
> I need to access my web based SQL 2005 express edition database on 1433 us
ing a user with minimal
> privileges that can only run a stored procedure. I do this by connecting t
o IP / port.
> Is there anyway I can disable SA using this same method but still allow SA
when I remote desktop
> to the machine and connect using Management Studio Express.
> I.e if I disable the account the SA account or other admin accounts I cant
login when I RDP into
> the machine.
> The minimal privileges user can simply run a single stored procedure but m
ust do using 1433.
> I just need to disable 1433 access for all other accounts and cant figure
out how to (I guess
> Management Studio Express connects using 1433 anyway so im stuck).
> If this is the case I guess I need to use SQLXML.
> Thanks for any help
> Scott
>[/vbcol]

disable all SA accounts remotly - access only for low user ?

Hi,
I need to access my web based SQL 2005 express edition database on 1433
using a user with minimal privileges that can only run a stored procedure. I
do this by connecting to IP / port.
Is there anyway I can disable SA using this same method but still allow SA
when I remote desktop to the machine and connect using Management Studio
Express.
I.e if I disable the account the SA account or other admin accounts I cant
login when I RDP into the machine.
The minimal privileges user can simply run a single stored procedure but
must do using 1433.
I just need to disable 1433 access for all other accounts and cant figure
out how to (I guess Management Studio Express connects using 1433 anyway so
im stuck).
If this is the case I guess I need to use SQLXML.
Thanks for any help
ScottI'm not sure, but you could try playing with something like:
DENY CONNECT ON ENDPOINT::TCP TO "sa"
(Check BOL for exact syntax)
I'm not sure whether such permissions are actually checked for sysadmins (let us know after your
test), and of course, you'd have to make sure some other netlib is used when inside the private
network (like Shared Memory, which only work locally).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scott" <www.sage-eshop.com> wrote in message news:O$T7b0J3GHA.4764@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to access my web based SQL 2005 express edition database on 1433 using a user with minimal
> privileges that can only run a stored procedure. I do this by connecting to IP / port.
> Is there anyway I can disable SA using this same method but still allow SA when I remote desktop
> to the machine and connect using Management Studio Express.
> I.e if I disable the account the SA account or other admin accounts I cant login when I RDP into
> the machine.
> The minimal privileges user can simply run a single stored procedure but must do using 1433.
> I just need to disable 1433 access for all other accounts and cant figure out how to (I guess
> Management Studio Express connects using 1433 anyway so im stuck).
> If this is the case I guess I need to use SQLXML.
> Thanks for any help
> Scott
>