Internet Explorer 10 Windows 8 version

It is necessary this discussion because Internet Explorer 10 attend just Consumer Preview.

My first remark: in the security settings the default setting allows and not asks loading an active x content.

Moved by Ronnie VernonMVP Sunday, March 18, 2012 12:19 AM Moved to relevant forum (From:Windows 8 General)

Reply:

Here is a detailed description from the team:

http://blogs.msdn.com/b/b8/archive/2012/03/13/web-browsing-in-windows-8-consumer-preview-with-ie10.aspx

Edited by zotya62 Friday, March 16, 2012 2:45 AM

------------------------------------
Reply:

It is necessary this discussion because Internet Explorer 10 attend just Consumer Preview.

My first remark: in the security settings the default setting allows and not asks loading an active x content.

Are you trying to say that Internet Explorer 10 in Windows 8 loads all ActiveX content without asking for permisson?

Logging in to my either favourite forum i can say yes, unlike with Internet Explorer 8.

------------------------------------
Reply:

I do not know where to direct this comment. Windows 8 and IE 10 do not operate correctly with PGATOUR.com. The screen flickers and the Live@ does not work. Everything works correctly with Firefox and Chrome.

------------------------------------
Reply:

Internet Explorer 10 sometimes freezes when it opems stored pages by Google. Anybody has experienced this issue?

------------------------------------

Requirements

I'm looking for a dual profile who can handle both Documentum as well as SharePoint w.r.t. security system management, document management in Documentum, setting up discussions with concerned owners of CEPN website sections, provide active support in document migration activities, coordinate with project IM to align the pre requisites of project handover, uploading forms and reports in CEPN SharePoint website, facilitate training programs to end users on document control aspects

Changed type Jinchun ChenMicrosoft employee Friday, April 20, 2012 4:26 AM

How to stop rebooting the PC on power-button press instead of hibernating if there are pending updates

I configured my machine to go into hibernate when the power button is pressed.

However, if there are pending updates, Vista silently switches the button action to Reboot. This behaviour is silly in several ways:

- The most annoying point: The machine reboots and runs then for hours/days, displaying the login screen.
- And then anagin, After pressing "hibernate", nobody expects the machine to do something different, to require further user interaction or to do some lengthy processing

Therefore: Is there a way to prevent this silent switching of the power button functionality from happening?

Thanks,
Kuno

Changed type Nicholas Li Wednesday, April 25, 2012 7:56 AM

Reply:

Hi,

Due to here is Windows 7 Forum, please repost your thread in Windows Vista Forums so that you can get more efficient help.

Regards.

Jeremy Wu

TechNet Community Support

------------------------------------
Reply:

Thanks. I realized that too, just after having posted :-)

------------------------------------

modelpopup close and refresh the back page

I have small issue with the model popup in sharepoint 2010. i have one button in a custom aspx page . and i am caling the page in the modal popup box.as below:

Naveen

<script type ="text/javascript">    function OpenDialog1() {     var options = SP.UI.$create_DialogOptions();     options.title ="" ;     options.width = 600;    options.height = 400;    //options.url = "/Lists/Announcements/NewForm.aspx";    options.url ="sitepages/ab.aspx" ;     SP.UI.ModalDialog.showModalDialog(options);     return false ;     }</script>              <asp:Button ID="Button1" runat="server" Text="Button" OnClientClick="javascript:return OpenDialog1()" />

but now when i click on the button the backside page to be refreshed.

help me on this.....

Edited by Dasari Naveen Thursday, November 3, 2011 3:56 PM

Reply:

Hi Dasari,

You need to use close callback event of the modal dialog to referesh the parent page. Here is how you can do it,

  <a href="javascript:openModalDialog('form.aspx');">Open My Custom Form</a>    <SharePoint:ScriptLink ID="ScriptLink1" Name="sp.js" runat="server" OnDemand="true" Localizable="false" />    <script type="text/ecmascript">     var options;   function openModalDialog() {   options = SP.UI.$create_DialogOptions();   options.width = 300;   options.height = 100;   options.url = SP.Utilities.Utility.getLayoutsPageUrl('customdialog.htm' );   options.dialogReturnValueCallback = Function.createDelegate(null, CloseCallback);   SP.UI.ModalDialog.showModalDialog(options);     }     function CloseCallback(result, target) {   location.reload(true);   }    </script>

For further information, have a look at the source: http://antoniolanaro.blogspot.com/2011/04/open-sharepoint-2010-modal-dialog-and.html

Ashraf ul Islam
Sharepoint Consultant

------------------------------------
Reply:

You can try this too.

This post explained in both javascript and C# language how to close popup and refersh automatically using simple method which SP2010 by default provides.

http://praveenbattula.blogspot.com/2011/10/close-sharepoint-2010-dialog-through.html

ASP.NET and SharePoint developer
Company: http://www.rampgroup.com/
Blog: http://praveenbattula.blogspot.com

------------------------------------
Reply:

thqanks ashraf for your reply ,

i want know where to put the script i.e inthe form.aspx or customdialog.aspx...

Naveen

------------------------------------
Reply:

hi ashraf ,

i placed above code but i have doubt that where to put the following code

<SharePoint:ScriptLink ID="ScriptLink1" Name="sp.js" runat="server" OnDema:nd="true" Localizable="false" />

is it the javascript file ...?

where can i find it?

Naveen

------------------------------------
Reply:

Hi Dasari,

You need to use close callback event of the modal dialog to referesh the parent page. Here is how you can do it,

<a href="javascript:openModalDialog('form.aspx');">Open My Custom Form</a>    <SharePoint:ScriptLink ID="ScriptLink1" Name="sp.js" runat="server" OnDemand="true" Localizable="false" />    <script type="text/ecmascript">     var options;   function openModalDialog() {   options = SP.UI.$create_DialogOptions();   options.width = 300;   options.height = 100;   options.url = SP.Utilities.Utility.getLayoutsPageUrl('customdialog.htm' );   options.dialogReturnValueCallback = Function.createDelegate(null, CloseCallback);   SP.UI.ModalDialog.showModalDialog(options);     }     function CloseCallback(result, target) {   location.reload(true);   }    </script>

For further information, have a look at the source: http://antoniolanaro.blogspot.com/2011/04/open-sharepoint-2010-modal-dialog-and.html

Ashraf ul Islam
Sharepoint Consultant

Hi,

Nice Post.

I would like to suggest a small change in the CloseCallBack Function of yours.

Location.Relod is a non Ajax based refresh call, instead you can use this

function CloseCallback(result, target) {    SP.UI.ModalDialog.RefreshPage(result);}

This is Ajax based refresh and works very well with SP2010.

Regards,

Amit Dubey

------------------------------------

Access issue in sharepoint 2007 portal

Hi,

I have a sharepoint 2007 portal in my organization.

the problem is that a single employee in my organization was unable to access the site. wenever he tries to access, web page cannot be found error is thrown.

i try adding him in any groups/ as single user but the problem is nt getting resolved for him.

i dunno wat wil be the reason behind it.

for other web applications in the same server has no problem for him. only a single web application creates problem.

any solution is highly appraciable.

Aruna

Reply:

Hi ,

Remove that User from All people and re permission the user on the site .

Site actions => site settings => advanced permissions => all people => remove the user and readd the user with the appropriate permissions .

Regards

Sushant Khambekar

____________________________________________________________ Regards - Sushant Khambekar - MCTS Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you. Sharepoint Admin - Moss 2007 , Sharepoint 2010 http://sharepointtechs.wordpress.com/

------------------------------------
Reply:

Hello Aruna,

First thing you need to check is whether the problem is machine specific. Check with user if he is able to access from another workstation (where it works for any other user)

If its working from another workstation, then its clearly machine specific issue.

In that case verify the IE proxy and other settings.

If its not working from anywhere, then check if this particular web app is configured for NLB and is the user able to ping the web app from workstation

::> Ping www.yourWebApp.com etc.

In that case, also apply the solution provided by Sushant.

Hope this helps,

Regards, Rohan --Please mark as "Answer" if the post resolve your issue--

------------------------------------

Problem in multiple upload in picture library

hello sir ,

i did not able to upload the multiple picture in picture library.

Reply:

Hi ,

Are you able to upload one picture at a time ?

Check whether office is installed on the machine .

Regards

Sushant

------------------------------------

Root CA certificate added to LDAP with CN=com as its name

We have a root certificate for an offline CA that's the root of an enterprise PKI. We're trying to publish it in AD. All the properties in the cert seem to be in order, but when we publish it with certutil, it's injected as "CN=com". Certutil is parsing this out of the cert (the output lines are "ldap:///CN=com,CN=AIA,CN=Public Key Services,CN=services,CN=Configuration,DC=[domain],DC=[ext]?cACertificate") Any idea what we're doing wrong here?

Can I use DSCDPContainer and DSCDPCN to force the name?

Reply:

Perhaps it is off in the registry: HKLM\SYSTEM\CurrentControlSet\services\CertSvc\Configuration\

DSConfigDN

certutil -setreg CA\DSConfigDN "CN=Configuration,DC=<domaincomponent>,DC<domaincomponent>"

http://technet.microsoft.com/en-us/library/cc737740(v=WS.10).aspx

------------------------------------
Reply:

We have a root certificate for an offline CA that's the root of an enterprise PKI. We're trying to publish it in AD. All the properties in the cert seem to be in order, but when we publish it with certutil, it's injected as "CN=com". Certutil is parsing this out of the cert (the output lines are "ldap:///CN=com,CN=AIA,CN=Public Key Services,CN=services,CN=Configuration,DC=[domain],DC=[ext]?cACertificate") Any idea what we're doing wrong here?

Can I use DSCDPContainer and DSCDPCN to force the name?

No, The DSCDPContainer and DSCDPCN can be used to specify CRL related names and you are publishing a CA certificate.

What is the CN value in your CA certificate?

/Hasain

------------------------------------

Windows Server 2008: Training Resources for Certificate Services & Security Functionality

Folks,

I am currently training in Windows Server 2008 (Certificate Services & Security) functionality. Do you know if there are any internal training environments and/or online courses I could access as a Microsoft employee?

Thank you,

edwinro

Changed type Mervyn Zhang Friday, August 14, 2009 10:35 AM

Reply:

Ask this question on the internal DL for Certificate Services.

------------------------------------

certutil -backupDB error

I am getting an error doing a backup of the CA database using certutil -backupDB. The backup files are created but it fails verification.

The error is: Backup content verification failed c:\temp

certutil: -backupDB command failed: 0x800700005 (WIN32: 5)

Certutil: Access id denied.

I have used auditing to try and work out what the restriction is but I can not find anything. I guess it is a security right or ACL.

The account is a member of users and backup operators, NOT local admin

Reply:

http://technet.microsoft.com/en-us/library/ee126140(v=WS.10).aspx#BKMK_BackUpDB

You must use an account that is a CA administrator. On an enterprise CA, the default configuration for CA administrators includes the local Administrators group, the Enterprise Admins group, and the Domain Admins group. On a standalone CA, the default configuration for CA administrators includes the local Administrators group.

If you are using Windows Server 2008 R2, you can now backup the CA by using System State Data. : http://support.microsoft.com/kb/2603469

------------------------------------

Top Issue – after MS12-027 affects VBA in Office

A new security update (MS12-027) released, April 10 has been released that affects MSCOMCTL.OCX.

Example: When you enable macros in an Excel 2003, 2007, 2010 you will receive the following error messages;

Steps to follow after update:

After installing the update you may need to follow the following steps to get rid of the error message listed above.

You install this security update on a computer that has a third-party software solution installed. The software solution is based on Microsoft Visual Basic for Applications (VBA). The software solution creates an instance of the control directly through Microsoft Office. In this scenario, the control may not load in your solution.

To resolve this issue, you must delete the cached versions of the control type libraries (extender files) on the client computer. To do this, you must search your hard disk for files that have the ".exd" file name extension and delete all the .exd files that you find. These .exd files will be re-created automatically when you use the new controls the next time that you use VBA. These extender files will be under the user's profile and may also be in other locations, such as the following:

%appdata%\Microsoft\forms
%temp%\Excel8.0
%temp%\VBE

For more information

MS12-027: Vulnerability in MSCOMCTL.OCX could allow Remote Code Execution: April 10, 2012
http://support.microsoft.com/kb/2664258

Review the Known issues and additional information about this security update section of this KB Article (referencing 14 separate linked URLs), as it contains a lot of information regarding this security update as it relates to individual product versions

Please see the article that applies to your version of Office.

2597112 MS12-027: Description of the security update for Microsoft Office 2003 Service Pack 3: April 10, 2012 (http://support.microsoft.com/kb/2597112) 2598041 MS12-027: Description of the security update for 2007 Microsoft Office system: April 10, 2012 (http://support.microsoft.com/kb/2598041)
2598039 MS12-027: Description of the security update for Office 2010: April 10, 2012 (http://support.microsoft.com/kb/2598039)

Max Meng

TechNet Community Support

Changed type Max MengModerator Tuesday, April 17, 2012 2:40 AM

Top Issue – after MS12-027 affects VBA in Office

A new security update (MS12-027) released, April 10 has been released that affects MSCOMCTL.OCX.

Example: When you enable macros in an Excel 2003, 2007, 2010 you will receive the following error messages;

Steps to follow after update:

After installing the update you may need to follow the following steps to get rid of the error message listed above.

%appdata%\Microsoft\forms
%temp%\Excel8.0
%temp%\VBE

For more information

MS12-027: Vulnerability in MSCOMCTL.OCX could allow Remote Code Execution: April 10, 2012
http://support.microsoft.com/kb/2664258

Please see the article that applies to your version of Office.

Max Meng

TechNet Community Support

Top Issue – after MS12-027 affects VBA in Office

A new security update (MS12-027) released, April 10 has been released that affects MSCOMCTL.OCX.

Example: When you enable macros in an Excel 2003, 2007, 2010 you will receive the following error messages;

Steps to follow after update:

After installing the update you may need to follow the following steps to get rid of the error message listed above.

%appdata%\Microsoft\forms
%temp%\Excel8.0
%temp%\VBE

For more information

MS12-027: Vulnerability in MSCOMCTL.OCX could allow Remote Code Execution: April 10, 2012
http://support.microsoft.com/kb/2664258

Please see the article that applies to your version of Office.

Max Meng

TechNet Community Support

Top Issue – after MS12-027 affects VBA in Office

A new security update (MS12-027) released, April 10 has been released that affects MSCOMCTL.OCX.

Example: When you enable macros in an Excel 2003, 2007, 2010 you will receive the following error messages;

Steps to follow after update:

After installing the update you may need to follow the following steps to get rid of the error message listed above.

%appdata%\Microsoft\forms
%temp%\Excel8.0
%temp%\VBE

For more information

MS12-027: Vulnerability in MSCOMCTL.OCX could allow Remote Code Execution: April 10, 2012
http://support.microsoft.com/kb/2664258

Please see the article that applies to your version of Office.

Max Meng

TechNet Community Support

Top Issue – after MS12-027 affects VBA in Office

A new security update (MS12-027) released, April 10 has been released that affects MSCOMCTL.OCX.

Example: When you enable macros in an Excel 2003, 2007, 2010 you will receive the following error messages;

Steps to follow after update:

After installing the update you may need to follow the following steps to get rid of the error message listed above.

%appdata%\Microsoft\forms
%temp%\Excel8.0
%temp%\VBE

For more information

MS12-027: Vulnerability in MSCOMCTL.OCX could allow Remote Code Execution: April 10, 2012
http://support.microsoft.com/kb/2664258

Please see the article that applies to your version of Office.

Max Meng

TechNet Community Support

Top Issue – after MS12-027 affects VBA in Office

A new security update (MS12-027) released, April 10 has been released that affects MSCOMCTL.OCX.

Example: When you enable macros in an Excel 2003, 2007, 2010 you will receive the following error messages;

Steps to follow after update:

After installing the update you may need to follow the following steps to get rid of the error message listed above.

%appdata%\Microsoft\forms
%temp%\Excel8.0
%temp%\VBE

For more information

MS12-027: Vulnerability in MSCOMCTL.OCX could allow Remote Code Execution: April 10, 2012
http://support.microsoft.com/kb/2664258

Please see the article that applies to your version of Office.

Max Meng

TechNet Community Support

obtain a datetime format compared to a SPFieldDateTime

I am having problems with formats between DateTime and DateTime SPFieldDateTimesince Gets Seconds (4/14/2012 2:37:42 PM) and SPFieldDateTime Only Minutes (4/26/2012 12:00:00 AM).

I need to compare between the date of SPFieldDateTime and DateTime date but does not respect my condition and I think it is in these formats

                     if (DateSendReminder == today)
                     {
                         Notification ();
                     }

I hope I can help. regards

Reply:

If the SPFieldDateTime dosen't support seconds, you will have to remove the seconds from the today datetime object

something like this: DateTime.Now.ToString("MM/dd/yyyy hh:mm tt")

EmpowerIT (Australia) for all your CRM/SharePoint needs. http://mscrmblog.net
Microsoft Certified Business Management Solutions Specialist
Microsoft Certified CRM Developer

------------------------------------

Does Hyper-V Server 2008 R2 need an antivirus?

Hi,

I have to install an Hyper-V 2008 Server R2 as virtualization environment, but I have a doubt:

Is it neccessary to install an antivirus on it?

It is a server core release with only the hyper-V function, so I'm not sure that is neccessary to install an antivirus.

If it is neccessary, can you suggest me some products?

Thanks a lot

Ciao

Fabio

Changed type Vincent Hu Monday, April 16, 2012 2:19 PM discussion is better

Reply:

Hi Fabio,

From my experience you don't need antivirus on your Hyper-V server. If you want to use antivirus sw, I sugest you microsoft security essentials, it's free antivirus and is very good.

Hope this answer could help you.

Romeo Mlinar
MCSA, MCSE, MCTS, MCITP
Blog: Admin troubles
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

------------------------------------
Reply:

Hi,

As a short answer you will need an antivirus for almost all of your Windows powered servers. Some product's documents says you should not install AV but with security eyes open, you need them.

You may want to check myblog about this :

http://erkanaksoy.com/2011/07/17/hyper-v-and-antivirus/

Regards.

MCTS, 2008R2 Server Virtualization http://www.erkanaksoy.com

------------------------------------
Reply:

specifically for the hyper-v role, you dont need av software (it's recommended to exclude the hyper-v files/processes if you use some)

however, the server as such is still potentially vulnerable, for example if you have a worm already in your network, and for such threats, depending on your security policy, an av software would make sense.

so it pretty much comes down to your security requirements. the risk of infection is lower than on a server like a terminal server on which people actually work/execute custom code, but there is a risk

------------------------------------
Reply:

Always use AV. But do the tuning for Hyper-V (exclude files, turn of on access sxan and use time scan instead) If they get malware on your host they have access to everything else to.

------------------------------------
Reply:

Security essentials doesn't install on a server edition of Windows

------------------------------------
Reply:

Security essentials doesn't install on a server edition of Windows

Sorry my mistake. You can install FEP, but isn't free.

------------------------------------
Reply:

Security essentials doesn't install on a server edition of Windows

That 's not looking to be true, you might have missed something. I have already installed it on 2008R2 sp1, you can check my blog.

MCTS, 2008R2 Server Virtualization http://www.erkanaksoy.com

------------------------------------
Reply:

Hi Fabio

It all depends on how you have setup the Hyper-V servers. Ideally you should not need AV on them.

Here is what a couple of MVP's have to say about it:

http://www.aidanfinn.com/?p=11377

http://blogs.msdn.com/b/virtual_pc_guy/archive/2009/03/17/antivirus-and-hyper-v-or-why-can-t-i-start-my-virtual-machine.aspx

If you decide to install AV then you need to get your exclusions right.

Here is a list of exclusions needed for microsoft products: (Hyper-V is 5th on the list)

http://social.technet.microsoft.com/wiki/contents/articles/953.windows-anti-virus-exclusion-list-en-us.aspx

Regards

John

------------------------------------
Reply:

Hi,

It depends.

By the way, the following post discussed a similar issue, you can refer to:

AntiVirus - To have or not to have?
http://social.technet.microsoft.com/Forums/en-US/winservergen/thread/084cefe0-28eb-4219-865d-a843e0a3c7ae/

Vincent Hu

TechNet Community Support

------------------------------------
Reply:

As you can see, this is a highly debated issue.

In the technical sence the frequency of a system to be compromised is all in how it is used. And whether it is a target of exploits.

Hyper-V Server is no more of less vulnerable than ESX or XenServer. Since you should not be using it as a desktop operating system the chance of compromise is very low. Even lower if you harden, use prodent IPSec rules, and segregate your management network. This stands for any server system, Windows or Linux.

Hyper-V Server or Windows Server Core, have an incredibly small attack surface - simply because many of the subsystems that have been traditionally targeted are simply not there. The traditioanl points of exploit are all around the Shell and user actions.

The last time I was involved in this debate was 7 years ago. We had a corporate policy that antivirus had to be installed on all systems. Quite frankly, this made little sence in _all_ cases, but I understood the policy and reason for it. We had some servers where AV killed the servers to such a degree that it might not have enve been installed becuase we had to have so many exclusion rules (AV was not vaery smart back then either).

We also implemented intrusion detection and network sniffing. These were far more effective in the datacenter while AV was far more effective on client machines.

SQL became a great target because of SQL Express being used all over the place in all kinds of little applications and the brower service making it so easy to discover. It was all trusted traffic. The fact that Slammer happened was just a matter of time. MAC has finally had its day of being a target.

We also ran ESX at the time, but there is no AV engine. You can't tell me it cannot get a virus. Same with Unix, same with the mainframe we ran.

My point, either include everything or exclude everything. In the end, it is all about risk and tolerance of risk here but not there.

Brian Ehlert
http://ITProctology.blogspot.com
Learn. Apply. Repeat.
Disclaimer: Attempting change is of your own free will.

------------------------------------
Reply:

Cool, they have changed it :-) Tried it and it now works on server version too.

------------------------------------

Report Parameters

Hello,

I have created a reportto extract information from data warehouse and this report have parameters of type list and when I see the report in the reporting services server I have the option "select all" in my parameter, but if I run the report in the Service Manager Console I don't have the option "Select All", only appears all the parameteres.

Why I do not have that option in the console? is there any special configuration that I have to put in my report?

Regards,

Reply:

Did you also make a "reportname.rpdl" file? This may over-ride the appearance of the parameters if you did.

------------------------------------
Reply:

Hello Rob

Thanks for your help.

This is my first report made by me for the Service Manager.

I just did (report.rdp on the Visual Studio) and put it on the reporting services server, and if I run the report in the reporting services server I have the parameter with the option "select all", but if I run the report in Service Manager the option "select all" does not appear.

Have you got to create a custom report with parameters and works well?

Regards,

------------------------------------
Reply:

Hello Rob,

Is mandatory to have a rpd file along with my report?

I have tried to create a .rpdl file but my parameter values come from a class that I related to the class of incidents.
how can I create my rpdl?

regards

------------------------------------
Reply:

No, it is not mandatory to have the .rpdl file, this allows you to format SCSM controls and use custom strings.

I didn't take in initially that you were talking about a list parameter, sorry. I have tested a report with a list parameter via reporting services and the console and I don't get a "select all" for either.

For example:

How are you populating your list for this parameter? How is it defined in the report?

Edited by Rob.Ford Tuesday, April 3, 2012 7:31 PM

------------------------------------
Reply:

Hello Rob,

I have created a new dataset with a list of values are the IDs from a customer class (I already have a dimension created for this class.).

Now we need a parameter for the customer(s).

Regards,

------------------------------------
Reply:

Not sure what you're asking :)

If you add a parameter in your report definition and populate the list with your ID values, the parameter will automatically be available when the report is run...

Edited by Rob.Ford Tuesday, April 17, 2012 7:14 PM

------------------------------------

Need to increment column value based on Other column In SSIS

I have a scenario like below.

ID CatType Name

1 A Raj

2 A Rai

1 B Raki

2 B Krish

3 A Rem

3 B Rami

ID and CatType are Composite key in my destination table. I am getting CatType from Source.

While loading data I have to increment ID by selecting Max(ID) where CatType=?(based on CatType) in Destination table

How can load these records in SSIS, Can anyone show me right direction

Edited by Ram.BI Monday, April 16, 2012 6:37 PM

Reply:

Is it possible to give the desired output given the sample you already provided?

MCTS, MCITP - Please mark posts as answered where appropriate.

------------------------------------

MDX with multiple NOT In Condition

I Experts ,

I am Working On SSAS 2008,
I have 4 Dimension in my Cube ie 1)DimColor 2)DimStatus 3)DimCity 4)DimProduct

DimColor         DimStatus         DimCity                         DimProduct
     Color                 Status            City                               Product
         White                  Active              London                          Prod1
         Black                  InActive           HongKong                     Prod2
          Red                   Success             Singapore                    Prod3

I have a Default Measure "[Measure].[Revenue]".
I need to find Revenue where
Color=Black and
Status Not Equal to Active and
City Not Equal to London and
Product Not Equal to Prod2

I need to create Calculated Member in my Cube :
I am aware of "Except" Function,But how to use in this scenario
If any One could help me with the syntex ??

Edited by MS308 Monday, April 16, 2012 10:32 AM

Reply:

Hi Mushtaq,

Try this

Select [Measure].[Revenue] on o,  <<something on rows>> on 1  FROM (SELECT ([Color].[Color].&[Black]) on 0  FROM (SELECT -([Status].[Status].&[Active]) on 0  FROM (SELECT -([City].[City].&[London]) on 0  FROM (SELECT -([Product].[Product].&[Prod2]) on 0  FROM <<cube name>>  ))))

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog

------------------------------------
Reply:

Except takes two sets, and will provide you with values in the first that don't exist in the second. If you have duplicates in the first that you want to retain, then you need to specify the ALL as a third parameter.

So you could say

SELECT [Measures].[Revenue] on 0

,{[Color].[Color].&[Black]} * EXCEPT([Status].[Status].[Status], [Status].[Status].&[Active])

* {EXCEPT([City].[City].[City], [City].[City].&[London])}

* {EXCEPT([Product].[Product].[Product], [Product].[Product].&[Prod2])} ON 0

FROM <<Cube Name>>

------------------------------------
Reply:

hi,

A last option! replace: {[Dim].[Main Dimesion Attribute].[attribute].members} by

{exists([Dim].[Main Dimesion Attribute].[Main Dimesion Attribute].members,[Dim].[Main Dimesion Attribute].[Discriminating Attribute].[All "Dimesion Attribute"s])}
-
{exists([Dim].[Main Dimesion Attribute].[Main Dimesion Attribute].members,[Dim].[Main Dimesion Attribute].&[excluded Discriminating member])}

in case of color: replace: [color].[color].[color].members

by:

{exists([color].[color].[color].members,[color].[color].[All Colors])}
-
{exists([color].[color].[color].members,[color].[color].&[Black])}

You can drop the exist function when used in the WHERE clause and in some calculations. You won't be able to use visual totals as it is possible in a sub select.

Philip,

Edited by VHteghem_Ph Monday, April 16, 2012 2:39 PM

------------------------------------
Reply:

Hi Michael,

I tried Using the Query proposed By you in my Cube .
I have use exactly the same syntex in my Cube ,but I get error that"Syntex for Select is Incorrect"

wITH Member Measures. x as
SELECT [Measures].[Revenue] on 0

,{[City].[City].&[City2]}
* EXCEPT([Color].[Color].[Color],[Color].[Color].&[Black])

* {EXCEPT([Product].[Product].[Color],[Product].[Product].&[Prod2])}

* {EXCEPT([States].[States].[Color],[States].[States].&[State2] )} ON 1

FROM [Cube_NotIN]

Note: I want to create Calculated Member ,and Calculated Member in cube does not accept Select clause(If I am not wrong).

------------------------------------
Reply:

Hi Raunak,

Thanks for Reply.but While creating Calculated Member in Cube it does not accept "Select " or Could say we cant use the same MDX Query Mentioned by u to create Calculated Member.?

Hope I made u clear What I mean by above line .??

------------------------------------
Reply:

Hi MDX,

Thanks for the Reply.

But I am confused as how to use your approach(MDX syntex) in my Scenario.

------------------------------------
Reply:

You are correct that Member does not accept SELECT in it. Are you trying to get a total for all the measures, or just a list of the revenue for each measure?

If you want the sum of Revenue for the explicit ommissions, then you will want to SUM those sets so

WITH MEMBER [Measures].[X] AS

SUM(,{[City].[City].&[City2]}
           * EXCEPT([Color].[Color].[Color],[Color].[Color].&[Black])

           * {EXCEPT([Product].[Product].[Color],[Product].[Product].&[Prod2])}

          * {EXCEPT([States].[States].[Color],[States].[States].&[State2] )} , [Measures].[Revenue])

SELECT [Measures].[X] ON 0

FROM [Cube_NotIN]

If you want teh data to be at the individual levels then you don't need the calculated member at all.

------------------------------------
Reply:

Hi Mushtaq,

Do you any measure in your cube by name: Revenue?

if yes, there is no need to create another calculated member. Just use the systax I have used and let us know the outcome.

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog

------------------------------------
Reply:

Hi Michael,

Thanks that solves my Problem :)

------------------------------------
Reply:

No Problem - please just mark them as helpful or as the answer.

------------------------------------

Ms Support forum

Monday, February 28, 2022