How to sort a GRIDVIEW which has different datasources and you dont know which datasource will be binded when
I have a single gridview in a user control i am creating.
Data in the gridview depends on a wide selecting options availiable for a user.
GRIDVIEW is created depening on the Selection by the USER.
I have a single sorting method for the GRIDVIEW as I have only one GRIDVIEW control but the DATASOURCE varies depending on the user control.
I am trying to SORT the gridview but not able to SORT it any ideas how i can sort it.
This is the code i have written but my SESSION VARIABLE didnt get any table on that name.
MY GRIDVIEW ID IN .NET IS EmpListGridView
protected void EmpListGridview_Sorting(object sender, GridViewSortEventArgs e) { String sortExpression = e.SortExpression; String direction = String.Empty; if (sortdirection == SortDirection.Ascending) { sortdirection = SortDirection.Descending; direction = "DESC"; } else { sortdirection = SortDirection.Ascending; direction = "ASC"; } DataTable table = ViewState["EmpListGridView"] as DataTable; table.DefaultView.Sort = sortExpression + direction; EmpListGridview.DataSource = table; EmpListGridview.DataBind(); } public SortDirection sortdirection { get { if (ViewState["SortDirection"] == null) { ViewState["SortDirection"] = SortDirection.Ascending; } return (SortDirection)ViewState["SortDirection"]; } set { ViewState["SortDirection"] = value; } } kukdai
Error 2940
I am trying to convert a W2K3 machine from physical to virtual and I keep getting the error 2940 with the recommended action of "Ensure that the HTTP service and/or the agent on the machine [hyperv-server]installed and running and that a firewall is not blocking HTTPS traffic.". I have tried it now with 2 different hyperv boxes as the target server and neither box has its firewall running.
I have read a number of other threads here and on other sites concerning this but none of them have a solution. What is this complaining about and what do I need to do to fix it?
Thanks
Bert
Reply:
Steve Thomas, SSEE, Microsoft
App-V/MED-V/SCVMM/Server App-V/SCCM/AppCompat
http://blogs.technet.com/gladiatormsft/
The App-V Team blog: http://blogs.technet.com/appv/
The MED-V Team Blog: http://blogs.technet.com/medv
The SCVMM Team blog: http://blogs.technet.com/scvmm/
"This posting is provided "AS IS" with no warranties, and confers no rights. User assumes all risks."
------------------------------------
Reply:
No, sorry, I don't. It was quite a while ago but I may try again next week.
Bert
------------------------------------
Reply:
Here is the compete error message. Since it does run for 20 or 25 minutes before failing, it is highly unlikely that the HTTP service or a misconfigured firewall are causing the problem.
Error (2940)
VMM is unable to complete the requested file transfer. The connection to the HTTP server hyperv01.mydomain.com could not be established.
(Unknown error (0x80072ee2))
Recommended Action
Ensure that the HTTP service and/or the agent on the machine hyperv01.mydomain.com are installed and running and that a firewall is not blocking HTTPS traffic.
------------------------------------
Reply:
------------------------------------
Reply:
Hhmmm... I never thought of that. It certainly fits. I just tried doing this exact same P2V conversion the other day to a different hyperv box and received the exact same error. The error makes no sense since the transfer does work for a while and then fails. If HTTP really was missing, the conversion shouldn't even start. I'll have a look for that event.
Bert
------------------------------------
Bug: Crawled Property name is case sensitive and display name is worng
Hi everyone,
I've encountered something very annoying:
Let's say I have a crawled property named "level". When using Admin UI, I can see it is named "level". When using powershell I can see it's named "level". When I'm trying to pass it to a pipeline extension, it simply doesn't get caught.
I took a look at the spy, and saw that it is named LEVEL, with capital letters. In the pipelineextensability XML file, I capitalized the letters - and voila - it worked !
It's not new to me that pipeline extensions are case sensitive, but it's new to me that you can't trust the displayed name.
Amir
Reply:
Hi,
This is "known", and using either FFDDumper or Spy to check the casing inside the pipeline is extremely useful. But I agree, it would work equally well with case insensitive crawled property names in my opinion. I have seen the upper casing on all <meta> tags in HTML. What kind of crawled property did you see this on?
I suspect the display names stored in SharePoint to be lower cased.
-mikael
Search Enthusiast - SharePoint MVP/WCF4/ASP.Net4
http://techmikael.blogspot.com/
------------------------------------
Reply:
Hi,
Same here.. <meta> tags in HTML :)
Amir
------------------------------------
Reply:
Hi,
And meta tags for some reason are always upper case inside the pipeline :)
-m
Search Enthusiast - SharePoint MVP/WCF4/ASP.Net4
http://techmikael.blogspot.com/
------------------------------------
Thinking of Building a RAID 0 Array From Three or Four 480 GB SSDs - Your Thoughts?
At the moment on my Dell Precision workstation I have a 2 TB C: partition made from two spinning Western Digital RE4 1 TB drives. Performance is quite good, but there are some big operations on this powerful system that I find are still limited by drive throughput.
Specifically, things like Visual Studio-based software builds, which access many, many different files (not to mention write a lot of files) seem to be limited not so much by throughput as by the fact that so much head seeking has to take place to get the jobs done. And yes, my drives are defragged (automatically by Windows). Another drive-limited operation is my occasional use of Photoshop for graphics-intensive work on very large files, and still another is VMware virtual machine operation.
My current WD RE4 (spinning) drives have big RAM caches (which of course add together in RAID arrangement), but that's not nearly enough.
I have used about 800 GB of space on drive C: so far in 2+ years of hard Windows 7 use, so I may not need a full 2 TB capacity. I use D: (another large spinning drive) for storage of data that doesn't need super high speed access.
To increase throughput on this system, I've been looking at OCZ Vertex 3 VTX3-25SAT3-480G 2.5" MLC Internal Solid State Drives.
Specifically, I'm considering replacing my two current spinning drives with, say, three or four of these fast SSD puppies in order to put disk performance through the roof.
At the moment I have an on-motherboard RAID controller with 3 x SATA2 connectors to spare, though I believe getting a modern dedicated RAID controller with SATA3 ports will be a good idea, as these OCZ drives can outperform SATA2. I'm not sure which to get though.
What are your experiences in using multiple SSDs to make a large RAID 0 partition?
Actual experience would be very helpful here; I'm aware of a lot of information (and misinformation) about using SSDs in RAID. I welcome everyone's comments, but please refrain from speculation.
Thanks in advance!
-Noel
| Detailed how-to in my eBook: | Configure The Windows 7 "To Work" Options |
- Changed type Nicholas LiModerator Thursday, April 12, 2012 3:57 AM
SSIS with teradata as source and oledb destination error.
Teradata source has a field with time as datatype.
If i use datareader source for extracting data from the teradata source then the time field changes to DT_I8.
Can this issue be fixed in the SSIS package or change is required in the table definition itself.
Reply:
You can/should use the Data Conversion Transformation component to convert it back to the needed data type.
Oftentimes though a SSIS Expression is needed to make this happen and in this case a Derived Column Transformation shall be used instead.
See a short how to on the latter: http://blogs.msdn.com/b/mattm/archive/2010/08/04/string-to-date-conversion.aspx
Arthur My Blog
------------------------------------
Orchestrator to fix agent health issues
Hi All,
We have planned to use Orchestrator to fix agent health issues in our SCOM environment.
We wanted to check whether anyone has implemented a solution already [created a runbook for fixing agent health] so that we can re-use it instead of reinventing.
If someone is aware or having a solution already for fixing the agent health using orchestrator or Opalis, can you share it?
Regards
Prabhu
- Changed type Robert_Hearn Wednesday, May 9, 2012 5:01 AM general ask for solutions
Reply:
Anders Bengtsson | Microsoft PFE | blog at http://www.contoso.se
------------------------------------
Configuring claims and forms based authentication for use with an LDAP,SQL provider in SharePoint 2010
HI, I created a site in sharepoint 2010 with FBA Authentication. Now i want to configure with both SQL and AD LDS for same site collection.How i have to achieve this requirement?
Thanks for any help.
Thanks And Regards,
Rajesh M.
Rajesh
Reply:
Hi,
Do you want to use AD LDS for FBA? The AD LDS is used by SharePoint for Windows Authentication. If you configure FBA the log-in page will have drop-down options for claim based authentication (FBA) and Windows Authentication
Ajeet
------------------------------------
Reply:
Hi Ajeet,
What ever you are saying is correct, I understood. But i want to USe FBA with both AD & SQL for single site collection...Its my client requirement. Is it possible?
Rajesh
------------------------------------
Reply:
Hi,
In that case try to follow the steps as mentioned below and see if it works
1) Extend the existing web application
2) Disable the Windows authentication and enable the FBA and configure the web app to use AD
3) Customize the log-in page to provide a link to the extended web app if the user wants to log-in through FBA using AD
here I am unable to understand the proposed requirement since the windows authentication uses AD as a database then why to go for FBA in same site collection with AD.
Anyways
Please let me know if it helps!!!
Ajeet
------------------------------------
Reply:
Hi Thank you very much for your reply...I will follow your steps and inform to u
Rajesh
------------------------------------
Reply:
Here is the Article which walks through with step by step instructions on how to configure AD LDS with SharePoint 2010:
http://salaudeen.blogspot.in/2011/12/configuring-ad-lds-with-sharepoint-2010.html
------------------------------------
RRaS tells me to delete something that's not there???
Ok, I'm quite new at RRaS, but pretty experienced with the Windows Server platform. I installed RRaS and misconfigured it. After removing and reinstalling the damned thing, every time I right click the role and click Enable RRaS and configure, it says "Incoming Connections are enabled. To use RRaS, you must first open Network Connections and delete Incoming Connections." However, when I open up Network Connections, INCOMING CONNECTIONS IS NOT THERE!!!! It doesn't show up ANYWHERE!! netsh interface ipv4 show interfaces doesn't show it. I can't figure out why it is doing this and I need it to be fixed ASAP.
Any help appreciated,
CBiss
Reply:
Sounds like you or someone else in the past has created an inbound connection, such as for VPN or some sort of dialin access, but it's now hidden.
When looking at Network Connections, do you have under Folder View, show hidden connections set? You may have to set that in Control Panel, Folder Options.
What shows up in Device Manager if also opt to show hidden devices?
Ace Fekay
MVP, MCT, MCITP Enterprise Administrator, MCTS Windows 2008 & Exchange 2007 & Exchange 2010, Exchange 2010 Enterprise Administrator, MCSE & MCSA 2003/2000, MCSA Messaging 2003
Microsoft Certified Trainer
Microsoft MVP - Directory Services
Complete List of Technical Blogs: http://www.delawarecountycomputerconsulting.com/technicalblogs.php
This posting is provided AS-IS with no warranties or guarantees and confers no rights.
------------------------------------
Reply:
- Edited by Tiger LiMicrosoft employee Monday, April 9, 2012 7:43 AM
------------------------------------
Time Query, Queued and Expire in debug log DNS Server
In debug log there are values: Time Query, Queued and Expire
1/25/2012 2:16:01 PM 0E08 PACKET 000000001EA6BFD0 UDP Rcv 160.39.114.110 2e94 Q [0001 D NOERROR] A (5)bogus(0)
UDP question info at 000000001EA6BFD0
Socket = 508
Remote addr 160.39.114.110, port 49710
Time Query=1077016, Queued=0, Expire=0
What exactly mean "Time Query" Queued and Expire?
"Time Query" usually has growing value but sometimes occurs 0.
Queued and Expire have usually have value 0 but sometimes occurs value
- Changed type Tiger LiMicrosoft employee Wednesday, April 11, 2012 8:57 AM
Reply:
I don't know either………but some utilities form third parties may will help us to understand that :
http://www.fiberdownload.com/Download/25855/Win-DNS-Log-Analyser
More information :
http://www.tech-faq.com/monitoring-and-troubleshooting-dns.html
http://technet.microsoft.com/en-us/library/cc772774(WS.10).aspx
http://technet.microsoft.com/en-us/library/bb727009.aspx
Hope these help.
------------------------------------
Windows Backup
OS: Win 2008 R2 Ent x64
Purpose: Exchange 2010 Std + AD & DC
Destination: Win 2008 Std x86
Am using Windows backup VSS feature on the exchange server for daily backup. All was running fine and suddenly it was stopped. Checked all the services and network path. All are ok.
I have set a scheduled backup and get the following error.
System Reserved: The operation to back up the volume was stopped before the operation started running
C: The operation to back up the volume was stopped before the operation started running
System State: The operation was stopped. Detailed error: The volume shadow copy operation failed with error 0x800423F3. View the event log for more information
I googled the error and find that the C:\ needs to be marked as Active Partition. This server is configured for Raid-I. There is another partition which was created while installing the OS, its the system reserved partition which is already marked as Active. Now if I change the C:\ as active, will resolve my issue or will it cause any other issue while booting the server?
Also, after I get to see the backup failed message, The following two services are also stopped automatically:
Black level backup engine services
Volume Shadow copy
Please help.
Thanks in advance
Anand
Anand K
Reply:
Don't change the Active Partition, otherwise you're server won't boot anymore.
What are the errors in the event log??
Peter Van Keymeulen, IT Infrastructure Solution Architect, www.edeconsulting.be
------------------------------------
Reply:
As peter said you should provide us any error messages relating to this problem in Event Viewer.
Please look at the following thread for a potential resolution:
http://social.technet.microsoft.com/Forums/en-US/windowsbackup/thread/684f0372-cfd3-4d3e-94ec-e0294f92a7b5
And about the services you mentioned:
Black level backup engine services: This service starts automatically when you first execute the Windows Server Backup console or you are backing up using wbadmin command. It remains its status (although you close the console or finish using wbadmin command) until you restart the server or when it remains inactive for some times.
Volume Shadow copy: This service starts automatically when something needs this service functions. For example, when you start the Windows Server Backup console, this service start automatically. Please note that this service stops automatically when it remains inactive for some times. So in your case, its maybe normal.
Please feel free to let us know if you have any question or concern.
MTCNA, Security+, MCSA, MCTS, MCP
Please VOTE as HELPFUL if the post helps you and 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.
- Edited by R.Alikhani Tuesday, April 3, 2012 6:09 AM
------------------------------------
Reply:
Hi Guys, sorry for the late reply.
Well, the problem has been rectified. The solution was, when I ran the vssadmin list writers, I saw few of the writers were inconsistent and I got an advice to run the chkdsk, did that, restarted the server and ran the backup. Worked like charm.
Thanks for the support :)
Anand K
------------------------------------
Reply:
Thank you for sharing this tip.
Please VOTE as HELPFUL if the post helps you and 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.
------------------------------------
SCE Forum FAQs (For System Center Essentials)
Hi All,
This thread contains the Frequently Asked Questions on System Center Essentials. We consolidate them and post it here for your reference. If you have any further questions, please kindly start a new thread in that other community members, MVPs, and we can easily attend to your question and reply. Thanks for your understanding.
You may also find Q6~Q10 for System Center Essentials 2010 here.
Q1: Software deployed to “Add/Remove Programs” will be automatically installed.
Symptom:
A software package was deployed with the option "Publish package(s) to Add/Remove Programs" selected. But it does NOT appear in "Add/Remove Programs" on the clients. Instead, the software will be automatically installed when the clients check for Windows Updates.
Cause:
The GPO “Turn on recommended updates via Automatic Updates” is enabled. When this policy is enabled, Automatic Updates will install "recommended updates" as well as "important updates" from update service.
Resolution:
1. Click Start -> Run, type GPEDIT.MSC and press Enter.
2. Click Computer Configuration, click Administrative Templates, click Windows Components, and then click Windows Update.
3. In the details pane, double-click Turn on recommended updates via Automatic Updates.
4. Choose Disabled and click OK.
Q2: How to display the new computer name when a managed computer's name was changed?
Symptom:
A managed computer's name was changed but the computer is still displayed with its old name in Essentials console.
Resolution:
1. Go to the Administration pane, select Device Management -> Agent Managed, and find the computer in the list, right-click and select delete.
2. Manually run a discovery and it should find the computer with new name. The agent is already installed, so it will start reporting.
3. If it's not working properly, you can try running a Repair on the agent once it shows up in the Administration space.
Q3: How to remove a computer that is no longer available?
Symptom:
A computer has been removed from the domain. But the Essentials agent on the computer was not uninstalled. The agent still shows on the Essentials console in grey.
Resolution
The agent record can be deleted from the Administration space. To do it, follow the steps below:
1. Go to Administration space;
2. Select Device Management -> Agent Managed;
3. Select the machine that is no longer available;
4. Right Click on it and select "Delete".
Q4: Updates may be hidden and listed as "Not Installed".
Symptom:
When updates are deployed to client computers, a user with local administrator rights may hide certain updates to avoid having to install them. When the update deployment status for the computer is viewed, the hidden updates are listed as "Not Installed". And these updates will never be download and installed.
Resolution
You can deploy the updates with a deadline. An update with a deadline cannot be hidden on the agent.
If you have clients that have previously hidden updates, re-approve the updates with a deadline, which will override the hidden option and force the client to install the updates.
To approve updates for deployment:
- In the Essentials console, click Updates.
- In the Updates pane, select the category for which you want to approve updates.
- In the results pane, select the updates that you want to approve.
- Right-click the selected updates and click Approve.
- In the Approve Groups for Installation dialog box, specify the computer groups with the computers on which you want to install the update. You can do either of the following:
- Select one or more groups from the Computer Groups list.
- Click Create New Group to create a new computer group, if needed.
- Click Set Deadline and input a certain time.
Q5: “You have chosen to create a package that is larger than 100MB.”
Symptom:
When creating a new package for deployment, a popup window shows an information dialog: You have chosen to create a package that is larger than 100MB. It could take some time to complete the package creation process.
Cause:
You will see a dialog when you create a package that is over 100MB in size since the packaging and signing process can be time consuming. While it creates the package you won't be able to use Essentials for other tasks.
Resolution:
None. This is expected behavior. Check the “Do not show this message again” box to not see this message in the future.
Reply:
Hi All,
This thread contains the Frequently Asked Questions on System Center Essentials. We consolidate them and post it here for your reference. If you have any further questions, please kindly start a new thread in that other community members, MVPs, and we can easily attend to your question and reply. Thanks for your understanding.
You may also find Q6~Q10 for System Center Essentials 2010 here.
Q1: Software deployed to "Add/Remove Programs" will be automatically installed.
Symptom:
A software package was deployed with the option "Publish package(s) to Add/Remove Programs" selected. But it does NOT appear in "Add/Remove Programs" on the clients. Instead, the software will be automatically installed when the clients check for Windows Updates.
Cause:
The GPO "Turn on recommended updates via Automatic Updates" is enabled. When this policy is enabled, Automatic Updates will install "recommended updates" as well as "important updates" from update service.
Resolution:
1. Click Start -> Run, type GPEDIT.MSC and press Enter.
2. Click Computer Configuration, click Administrative Templates, click Windows Components, and then click Windows Update.
3. In the details pane, double-click Turn on recommended updates via Automatic Updates.
4. Choose Disabled and click OK.
Q2: How to display the new computer name when a managed computer's name was changed?
Symptom:
A managed computer's name was changed but the computer is still displayed with its old name in Essentials console.
Resolution:
1. Go to the Administration pane, select Device Management -> Agent Managed, and find the computer in the list, right-click and select delete.
2. Manually run a discovery and it should find the computer with new name. The agent is already installed, so it will start reporting.
3. If it's not working properly, you can try running a Repair on the agent once it shows up in the Administration space.
Q3: How to remove a computer that is no longer available?
Symptom:
A computer has been removed from the domain. But the Essentials agent on the computer was not uninstalled. The agent still shows on the Essentials console in grey.
Resolution
The agent record can be deleted from the Administration space. To do it, follow the steps below:
1. Go to Administration space;
2. Select Device Management -> Agent Managed;
3. Select the machine that is no longer available;
4. Right Click on it and select "Delete".
Q4: Updates may be hidden and listed as "Not Installed".
Symptom:
When updates are deployed to client computers, a user with local administrator rights may hide certain updates to avoid having to install them. When the update deployment status for the computer is viewed, the hidden updates are listed as "Not Installed". And these updates will never be download and installed.
Resolution
You can deploy the updates with a deadline. An update with a deadline cannot be hidden on the agent.
If you have clients that have previously hidden updates, re-approve the updates with a deadline, which will override the hidden option and force the client to install the updates.
To approve updates for deployment:
- In the Essentials console, click Updates.
- In the Updates pane, select the category for which you want to approve updates.
- In the results pane, select the updates that you want to approve.
- Right-click the selected updates and click Approve.
- In the Approve Groups for Installation dialog box, specify the computer groups with the computers on which you want to install the update. You can do either of the following:
- Select one or more groups from the Computer Groups list.
- Click Create New Group to create a new computer group, if needed.
- Click Set Deadline and input a certain time.
Q5: "You have chosen to create a package that is larger than 100MB."
Symptom:
When creating a new package for deployment, a popup window shows an information dialog: You have chosen to create a package that is larger than 100MB. It could take some time to complete the package creation process.
Cause:
You will see a dialog when you create a package that is over 100MB in size since the packaging and signing process can be time consuming. While it creates the package you won't be able to use Essentials for other tasks.
Resolution:
None. This is expected behavior. Check the "Do not show this message again" box to not see this message in the future.
nareshk banker
- Edited by NARESHK BANKER Monday, April 9, 2012 2:33 AM
------------------------------------
HE All
HAPPY EASTER, Everyone!!
Drew
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
Reply:
You too.
------------------------------------
sub-routine
Hi
2 Questions
Question 1
I want to build 21 of the same item for a project and schedule these, all 21 have the same steps approx 70 sub tasks. I can make the schedule for one item then copy it 20 more times and subsequently change the titles no problem. What I would like to know how can I make it so that if I modify the original task then all the others can do the same similar to using a sub routine in programming.
Question 2
IF i schedule welding machines in many tasks what is the best way of finding the optimum amount of welding machines to use I may need over 100 or more welding machines. up to now all I have done is increase the number in the resources till the line changes colour from red to black.
Reply:
Hi Slickdoggie,
Welcome to this Microsoft Project forum:)
1. Project has no built-in facility for doing this. It might be possible to create a vba routine which you would have to activate with every change. Not being a developer, it sounds like a complicated solution, and I would recommend that you re-post this part to the project developer forum, stating the project version and if you're using a server.
2. Make the welding machine a work resource and examine its resource graph to determine the maximum number Project has already calculated from the schedule you have produced. Increase the Max Units to this value. OR try levelling.
FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm
Hope this helps - please let us know how you get on :)
Mike Glen
MS Project MVP (97-11)
See http://tinyurl.com/2xbhc for my free Project Tutorials
------------------------------------
Reply:
Thanks Mike
I found the resource graph that appeared to be what I was looking for in Question 2. Ill just have to manually update the others at the moment.
------------------------------------
Reply:
You're welcome, :-)
Mike Glen
MS Project MVP (97-11)
See http://tinyurl.com/2xbhc for my free Project Tutorials
------------------------------------
Reply:
------------------------------------
DirectAccess client fails when another pc is connected to a home network
I work from home using my own laptop. My wife has recently come back from work with a laptop supplied by them which uses DirectAccess to get to their Intranet. I'm familiar with VPN but have never used DirectAccess myself.
We've noticed a really weird situation where whenever my laptop is connected to our home network her direct access client stops working. As soon as I disconnect it starts working again.
I've tried closing down everything I can think of that could be network related on my laptop (including killing network attached services to see if it makes any difference).
I just wondered if anyone might have any thoughts on how I could troubleshoot the situation. Her laptop is pretty locked down by her employer so I may be limited in what I can do to debug. I'm a developer rather than a network engineer, so go easy on me!
It probably doesn't help but we're using BT Infinity in the UK, using the supplied modem and router (home hub). We're both using Win7.
- Edited by Laughing John Tuesday, March 13, 2012 7:21 PM
- Changed type Tiger LiMicrosoft employee Monday, March 19, 2012 1:22 AM
Reply:
Hi John,
Thanks for posting here.
> We've noticed a really weird situation where whenever my laptop is connected to our home network her direct access client stops working.
Could we try to first reproduce that and troubleshoot with following the steps in the link below ? It is hard to narrow down the root cause with current symptoms description right now. What about the edge router, any special settings ?
Troubleshooting DirectAccess Problems
http://technet.microsoft.com/en-us/library/ee844139(WS.10).aspx
Thanks.
Tiger Li
Tiger Li
TechNet Community Support
------------------------------------
Reply:
Hi Tiger,
This has been resolved now, my wife's employer did something at their end and the problem appears to have gone away, but thanks for taking the trouble to reply.
LJ.
------------------------------------
MDX calculated members
HI,
I have simple cube with
Dimension Customer
Dimension Date (Year,Month)
Fact Sales =Sales quantity loaded monthly, all combinations of Customer and Month have its own record
Fact Sales Plan = Planned Sales quantity for next year loaded in december, all combinations of Customer and Month have its own record
So right now
In Fact Sales are sales for all customers from January 2011 to February 2012.
In Fact Sales Plan are planned sales for all customers from January 2012 to December 2012.
I need to create MDX calculated members, which answers questions below
- What is the tendency for rest of the actual year , so for today data=> ((Sales Jan+Feb2012)/(Sales Jan + Feb 2011)) * (Sales Mar-Dec 2011). So I need to get for all not finished months in actual year calculated sales quantity, coming from hypothesis, that Actual Year will be similar to last year
- What is status of reality vs plan for actual Year. So all finished months sales are compared to planned sales and next months are multiplied by this ratio. For my case in MaRch => (Sales Jan+Feb 2012)/ (Sales Plan Jan+Feb 2012) * (Sales Plan Mar-Dec 2012)
I am able to show then how much extra qty need to be sold to get the plan, and also to show them how to use writeback to change the plan.
Thanks a lot
Reply:
Volyn,
As a strategy for approaching these calculations:
1. I'd put a column in your dimTime dimension table to flag whether a month is "complete" or not. This will give you a way to pick out which months you should include in your SUM()/AGGREGATE() for actual, and which for forecast. Use the FILTER() function to then reference the flag in the time function (see the MDX below that uses filter() on some employee dimension to create a named set for similar example you can extrapolate from)
2. The crux of the problem from there is including the right months in the set for your SUM() functions for the various measures you need. See below MDX for an example of a "forecast from date" kind of measure. Also you'll probably be using PARALLELPERIOD to generate the comparison sets.
3. For the write-back, I'd use a separate measure group for that, one that only includes the user-entered forecast metric. Then you can add that or compare it to existing measures as needed in the MDX calc script.
The measures you'll be creating are not too difficult, but will just require a good comfort level with range operators (":", "LAG", "LEAD"), hierarchy navigation (PARALLELPERIOD, etc.), and various aggregation functions (SUM, AGGREGATE, etc.)
CREATE SET [Active Part-Time Consultants] AS
FILTER(
[Employee].[Employee Name].Members,
[Employee].[Employee Name].CurrentMember.Properties( "Employee Type" )='Part-time' AND
[Employee].[Employee Name].Properties( "Employee Status" ) = 'Active');
CREATE MEMBER CURRENTCUBE.[Measures].[Forecast Amount From-Date] AS
SUM(
TAIL(DESCENDANTS([Time].[Calendar Hierarchy].CurrentMember,[Time].[Calendar Hierarchy].[Day]),1).Item(0).Lead(1)
:TAIL([Time].[Calendar Hierarchy].[Day],1).Item(0)
,Measures.[Forecast Amount])
, FORMAT_STRING="$#,##0.00;$-#,##0.00"
, VISIBLE=1;
Rob Kerr SQL Server MVP CTO, BlueGranite
------------------------------------
Pantech UM185 Cricket Broadband Modem Not Compatable
- Changed type Niki HanModerator Tuesday, April 24, 2012 9:16 AM
Reply:
"A programmer is just a tool which converts caffeine into code"
------------------------------------
Good Book for Sharepoint 2010 Development
I am very new to sharepoint and I have not at all in sharepoint 2007. I have good experience in asp.net. Now I was looking for some good book which help me to learn sharepoint 2010. I found book for sharepoint 2010 but this thing is that those books are giving information Keeping mind that user is aware of sharepoint and had work in sharepoint 2007.
But I was looking for some book which will help me to understand throughly and which example or case study. So I can put my hands on it.
- Moved by Mike Walsh FIN Monday, February 7, 2011 9:50 AM SP 2010 questions go to SP 2010 forums (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
- Changed type Razi bin RaisMicrosoft employee Monday, February 7, 2011 10:36 PM More suitable for discussion
Reply:
The Wrox SharePoint 2010 Six-in-one book is meant for beginners: http://www.tinyurl.com/sixinone. It gives you an overview of different topics such as development, branding, workflow, search, etc. If you want to know specifically about a certain topic, there are more specialized books out there. Do you want to learn SharePoint developmet, or how to administer a SharePoint site, how to use a SharePoint site, or what?
Blog: blog.beckybertram.com | RSS | @beckybertram | SharePoint 2010: Six-in-One
------------------------------------
Reply:
------------------------------------
Reply:
Hi Milind,
I suggest you the book.
SharePoint 2010 Development with Visual Studio 2010 written by Carter, Scholl, Jaunsovec Publisher Addison Wesley.
Hope this book would server you purpose.
Regards
------------------------------------
Reply:
I would suggest the following
Beginning SharePoint 2010: Building Business Solutions with SharePoint (Wrox Programmer to Programmer)Real World SharePoint 2010: Indispensable Experiences from 22 MVPs (Wrox Programmer to Programmer)
SharePoint 2010 Development LiveLessons (Video Training): 10 Solutions Every SharePoint Developer Should Know How to Create
My SharePoint Blog
http://www.dhirendrayadav.com
------------------------------------
Office Mobile Services (OMS) sample project for web services implementation
Hi!
I'm looking for a complete implementation project of Office 2010 Mobile Service in VS 2008/2010. Office 2010 Mobile Service Guidelines only explain some sample methods.
I mean something like the following which has been used in the guidelines itself:
I've searched MSDN and CodePlex without success. Implementing the OMS isn't a straightforward project too.
Please do not refer to these links:
- http://msdn.microsoft.com/en-us/library/ff606754.aspx
- http://msdn.microsoft.com/en-us/library/ff606756.aspx
- http://msdn.microsoft.com/en-us/library/ff606755.aspx
Thanks...
User Profile Service Application error
When I click user Profile Service Application I get:
Error
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: 346c2595-6d5f-481e-aade-a185ac91f4d0
Date and Time: 4/7/2012 4:26:38 PM
When i check the log the below line is there:
UserProfileServiceImportStatisticsWebPart:LoadControl failed, Exception: System.MissingMethodException: Method not found: 'Boolean Microsoft.Office.Server.UserProfiles.UserProfileImportJob.get_IsSynchronizationRunning()'. at Microsoft.SharePoint.Portal.WebControls.UserProfileServiceImportStatisticsWebPart._LoadStatusAndSettings() at Microsoft.SharePoint.Portal.WebControls.UserProfileServiceStatisticsWebPartBase.LoadControl(Object sender, EventArgs e) 346c2595-6d5f-481e-aade-a185ac91f4d0
Reply:
http://sharepoint.nauplius.net
------------------------------------
Reply:
------------------------------------
Reply:
http://sharepoint.nauplius.net
------------------------------------
Reply:
------------------------------------
Reply:
Hi, there is a similar situation in this thread http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/b5628769-98e2-4074-86f7-f8c630ee5a79
HTH
Riccardo
------------------------------------
This one image makes me happier about Windows 8 than *everything* I've seen from Microsoft.
This image is from wikipedia: http://en.wikipedia.org/wiki/File:Windows8102MultiMonitorAndApp.png
Now maybe I've missed out on all the "Windows 8 for people who don't have tablets" presentations, but every Windows 8
demonstration I've seen to date has been about touch, Metro, and how you can pin two apps next to each other. All things that
made me concerned that Windows 8 wasn't really designed for non-touch multiple monitor setups. This one screenshot allays all that
fear, uncertainty, and doubt.
The Windows crew need to do more of this, and lay off the "touch touch touch and did we mention touch" thing.
Philo
Philo Janus, MCP Bridging business & Technology: @ http://www.saintchad.org/ Author: Pro InfoPath 2007 & Pro InfoPath 2010 Pro PerformancePoint 2007 Pro SQL Server Analysis Services 2008 Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010
- Edited by Philo Janus Tuesday, April 3, 2012 2:03 PM
Reply:
------------------------------------
Reply:
They're not interested in impressing people like us.
But we geeks are not without our capabilities to make things better.
Here's another image to warm your heart... I like it better than the one above because that stoopid big block of uselessness on the left is not there, and notice in particular the button in the upper-left corner.
-Noel
------------------------------------
No comments:
Post a Comment