Posts

Showing posts with the label Sharepoint

Branding your SharePoint site in a super fast way - Emgage

Branding a SharePoint farm on premise or in O365 is an extremely time absorbing task. Recently found a few tools called emgage prime and emgage turbo which basically gives you customized UX branding solutions to make you get to what you want super fast and super easy....Just used it on a SP2016 farm a few days ago and the results were tremendous. A definite recommendation on the SP side of things.

Duplication of KPI's within PPS

Image
Has anyone ever come up with the of duplication of KPI related information after dragging and dropping two seperate KPI's within a scorecard......... well! I have. Now the issue is quite simple, I define two separate KPI's called KPI1 and KPI2. I define KPI1 in the following manner: After this step I define KPI2 in the following manner: Once I perform the following operations I basically define a scorecard dropping a dimension (eg: Brand) for this purpose and then drag KPI1 and then KPI2 ( Note:  KPI2 is the sibling of KPI1). The scorecard gets generated in the following fashion: Now if you notice the scorecard the Actual and Target is repeated for KPI2 even though KPI2 has the names defined as Test1 and Test2 respectively and the default values for KPI2 is empty for all rows of the slicing dimension. This issue is due to the fact that PPS did not recognize KPI2 as a valid sibling of KPI1 (This is indeed an issue with PPS and needs to be changed as soon as possible ...

SQL Server 2012 Power View Installation with Sharepoint 2010

Oh Oh (Jaane Jaana the song just came to my mind)..... Installing powerview on Sharepoint 2010 with SQL server 2012 turned out to be a nightmare. Since I was doing the install on my local m/c, things became more harder than usual as I do not have enough memory to scatter around. So let me explain the steps I went through and the effort I had to exert in playing around with PowerView.       I had SQL Server 2008 R2 installed with Sharepoint 2010 on my machine. Just for folks out there who do not want to uninstall their current SQL server version and especially if it is 2008, ensure that you install SQL Server 2008 SP2 before installing SQL Server 2012 (I am going to refer to it with the term "Denali" from this point on). If you do not install SP1 and SP2 prior to the Denali install you are in for one heck of a ride. Mark my words please do the installs prior to installing Denali. If you do install Denali without upgrading SQL server 2008 to SP2, ensure th...

Ajaxifying Sharepoint 2010

Just a quick note on how to ajaxify Sharepoint 2010:- 1. Download the code files from http://ajaxifymoss.codeplex.com/ 2. Update the location of stsadm to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN\stsadm in deploy.cmd and upgrade.cmd files respectively. 3. Open command prompt in admin mode and run the following command: STSADM.EXE -o addajax -url http://UNLT239/MOSS to ajaxify the site. In my case it is the above url, however you would need to specify STSADM.EXE -o addajax -url <sitename_to_be_ajaxified> Once this is done, navigate to the web.config file and ensure that you replace the version of your system.web.extension to 3.5. Also the following changes are extremely vital:- <httpHandlers> <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> <a...

Error while trying to run Report Builder 3.0 in Sharepoint 2010

Ran across an issue while trying to create using Report Builder 3.0:- ERROR DETAILS Following errors were detected during this operation. * [12/29/2011 12:47:47 PM] System.Deployment.Application.DeploymentException (Subscription) - Unable to install this application because an application with the same identity is already installed. To install this application, either modify the manifest version for this application or uninstall the preexisting application. - Source: System.Deployment - Stack trace: at System.Deployment.Application.SubscriptionStore.CheckApplicationPayload(CommitApplicationParams commitParams) at System.Deployment.Application.SubscriptionStore.CommitApplication(SubscriptionState& subState, CommitApplicationParams commitParams) at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc) at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri...

Sharepoint and SSRS configuration continued...

So my next step is to deploy the reports in sharepoint. Great! Except now you might run into the following issue: the full path must be less than 260 characters how would you go about resolving this-->simple follow the steps below.... 1. Create a document library with the document type being null. 2. Else go to the library section and select reports as the type of library. 3. The next step is to ensure that you give a valid name for the library (This is an easy one) so your format would be http:// /SiteName/LibraryName 4. Go back to your SSRS project properties. Make sure that the Target Data source folder and the Target Report Folder are configured with the following value as mentioned in step 3 :- http:// /SiteName/LibraryName 5. The TargetReportPartFolder need not be filled.... Its upto you. This foldercan be used to deploy to a sub library... 6. The TargetServerUrl would be http:// /SiteName 7. Make sure you point the TargetServerUrl to the right version of SQL server. Click dep...

Sharepoint & SSRS integration Issues

Recently started working with Sharepoint 2010. PPS and excel services seemed pretty simple on the onset. Now while trying to integrate SSRS with share point 2010, I ran into this issue: "Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages" Man--> this was a mind boggler. Let me explain what I tried to do in order to eliminate this issue and still did not work:- 1. Opened the RSManager Config file (located at C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer if you have a 64 bit OS) and then changed the following <AuthenticationTypes> <RSWindowsNTLM/> </AuthenticationTypes> and changed it to Kerberos mode: <AuthenticationTypes> <RSWindowsNegotiate/> (acts as a intermediary between NTLM and RSWindowsKerberos)) </Auth...