Configuring ADFS for Single-Sign-On

Posted By Posted by: EPM Partners on March 27, 2013

Configuring Single-Sign-On using Active Directory Federated Services (AFDS v2.0) to EPMonDemand requires a number of configurations to be made on your AD infrastructure, this document details those steps. References http://technet.microsoft.com/en-us/library/hh305235(v=office.14).aspx   Configure relying party in ADFS Manually configure with the following settings: Name: EPMonDemand Profile: AD FS 2.0 Enable WS-Federation Passive protocol WS-Federation Passive URL: https://[customer].epmondemand.com.au/_trust/

Read More


Blog Posted In Blog Posted In: Blog, How to
Blog Posted In Comments Off on Configuring ADFS for Single-Sign-On

Use OLAP Data Connections for XL based reports

Posted By Posted by: Dan Stopher on March 27, 2013

Use OLAP Data Connections for XL based reports by Dan Stopher in How To, Reporting 27 Mar 2013  |  0 Comments How To: Use OLAP Data Connections for XL based reports EPMonDemand allows users to use access OLAP Data Connections to support default and custom Excel services reporting. Access is via Excel and is direct over the web

Read More


Blog Posted In Blog Posted In: Blog, How to, Reporting
Blog Posted In 

Issue: No Prompt for Document Check In Option in the Project Documents List

Posted By Posted by: EPM Partners on March 27, 2013

Issue: Users don’t get prompted to Check In a document after closing the document and saving changes to a sharepoint document library. Reason: By Default, Checked OUT option is disabled in the Project Document Library settings:) Objective: To enable the Checked Out option in the Project Document list so the user will be prompted to

Read More


Blog Posted In Blog Posted In: How to, SharePoint
Blog Posted In 

Requirement: Users Should be able to See their Own Projects only in a SSRS Report Parameter list

Posted By Posted by: EPM Partners on March 25, 2013

Environment: Project server 2010, MS SQL Server 2008 R2 non- SharePoint Integrated Mode Objective: To limit users to only be able to access their own Projects/Programs in SSRS Report Parameter. Solution: 1. Create a report dataset with below Query and set the data source connection string ProjectServer_Reporting Database.. SELECT     R.ResourceNTAccount, P.ProjectOwnerName, P.ProjectName FROM        MSP_EpmProject_UserView AS P

Read More


Blog Posted In Blog Posted In: Project Client, Reporting
Blog Posted In 

Sum Values Returned From LookupSet Function

Posted By Posted by: EPM Partners on March 13, 2013

The LookUpSet function returns objects or array of objects. Cannot use the default SUM function to sum the values returned. The following VB script needs to be added as a function in the report (Report > Report Properties > Code) Public Function SumLookup(ByVal items As Object()) As Decimal Dim suma As Decimal = 0 For

Read More


Blog Posted In Blog Posted In: How to
Blog Posted In 

Using LookupSet Function in SSRS Reports

Posted By Posted by: EPM Partners on March 5, 2013

Since any items in SSRS reports such as charts, tablix, tables etc can only be assigned to one dataset, I have found the LookupSet function quite useful to obtain data that may reside in other datasets. For Example DataSet1 fields: ID ProjectName ProjectDescription DateCreated DataSet2 fields: TimeByDay Weather Temperature A tablix is assigned to DataSet1

Read More


Blog Posted In Blog Posted In: How to
Blog Posted In 

Joining a Table with Keys from Separate Tables

Posted By Posted by: EPM Partners on March 1, 2013

When creating custom timesheet SSRS reports, it may be required to perform many complex queries with multiple joins to retrieve the desired dataset. We have come across a need to join a table to two separate tables using two separate keys. See example below: SELECT     * FROM         table1 LEFT OUTER JOIN table2 ON table1.ID = table2.ID

Read More


Blog Posted In Blog Posted In: How to
Blog Posted In