Move Task Up and Down using Clarity WBS Layout

Use WBS (and refer my previous article in Clarity WBS)

1. Please use the below option to move up and down of tasks.

Assign Multiple Resources and Multiple Task using Clarity

Assigning Multiple resources and multiple tasks use WBS which is mentioned in the image.

Labor Hours for Reports in Clarity Time Slices Jobs

Clarity PPM Resource Management 'time' is stored in curves to represent the information over time as all resource management is dependent on time and changes in time. This facts impacts how the data can be sliced for reporting or portlet views of information. The curves are stored in Binary Large Object Files (
BLObs) in clarity PPM tables. Jobs in clarity called "TimeSlices" allow the data in the BLOB to read and stored into summary or time sliced buckets to be available for reporting.

Clear Caches using Clarity

Clear Caches using Clarity

Use below code to clear caches in the URL.

Security.Caches

Happy coding
Bala

Labor Hours for Reports

Clarity PPM resource management stored in Curves to represent the information over time, as all resource management data is dependent on time and changes in time. Curves are stored in BLOB's , Binary large object files in clarity PPM tables.

Jobs in clarity called Time Slices allow the data in Blob to be read and stored in to summary or time slice buckets and it's available for reports.

Happy coding in Clarity PPM
Bala

first object xml editor and it's

first object xml editor and it's 

Financial location clarity

Department first, then you can add location in clarity

With out the department you can't add location.

Project Upload Using XOG in Clarity

Project Upload Using XOG.

prj_projects_read
prj_projects_write

These two XOG need to use for XOG ing the project in to clarity.

We were facing one issue in one of the attribute called "proj_lifecycle_legd"

Error

Validation failure. Attribute: proj_lifecycle_legd. Cause: range

This is caused due to the length of the attribute in development and finally increased and got worked.

Happy coding 

Bala

Wibbitz Turns Articles into Easy-to-Digest Video Summaries

Wibbitz Turns Articles into Easy-to-Digest Video Summaries

If you don’t have a lot of time to spend on making a video for this purpose, you would probably want to try Wibbitz.

Basically, the idea behind Wibbitz is that it crawls the site and extracts important text details then converts the information to a video and audio presentation. The program then narrates your latest blog updates so visitors hear the latest updates and not just read it.

http://www.wibbitz.com/

nirsoft has all kind of free softwares for passwords and stuff

nirsoft has all kind of free softwares for passwords and stuff
http://www.nirsoft.net/

Facebook open-sources Presto (Faster than Hive)

Facebook is open-sourcing Presto, an SQL query engine that it developed in-house to help analysts, data scientists and engineers pick apart the information stored in its enormous data warehouses.

Development for Presto began in the fall of 2012 and was then released to all Facebook employees last spring. The system is now used by over 1,000 employees, running over 30,000 queries that include at least one petabyte of data on a daily basis. Facebook says it’s “ten times better” than alternatives such as Hive and Mad*Reduce in regards to CPU efficiency and latency for the majority of queries submitted by its employees.

“It currently supports a large subset of ANSI SQL, including joins, left/right outer joins, subqueries, and most of the common aggregate and scalar functions, including approximate distinct counts (using HyperLogLog) and approximate percentiles (based on quantile digest),” Martin Traverso, a software engineer at Facebook said.

ScalaR For Visualizing the Big Data like Google Maps

Almost all areas of science are moving to a more data-driven analysis pipeline, where large multidimensional datasets need to be explored and analyzed for possible insights. The process of exploring large datasets is inherently an interactive process, as the user will react to aspects of the data, which will in turn help determine future queries.

Unfortunately, many visualization interfaces were designed with the assumption that much, if not all, of the data to be visualized would reside in memory. As both the quantity and quality of the tools used to collect data have improved, datasets have continued to grow in size, and this assumption often no longer holds. However, interactivity necessitates low-latency access, and the latency required to fetch data from disk for each interaction with the interface is unacceptable.

To address the challenge of scaling visualization to Big Data, we have implemented a data visualization system called ScalaR that provides a web-based, map-style interface (think Google Maps) for viewing large data sets. We presented a paper about ScalaR at the First Workshop on Big Data Visualization held recently in Santa Clara, Calif.  The rest of this post summarizes the new approaches and methods to scaling data visualization that we are taking in ScalaR.

ScalaR is a data visualization system that provides a web-based, map-style interface (think Google Maps) for viewing large data sets.

Search Engine For Hadoop

Vertascale Announces SimpleSearch(beta), The Search Engine For Hadoop - See more at: http://www.toolsjournal.com/cloud-articles/item/1449-vertascale-simplesearch#sthash.i44tZugb.dpuf

Big Data software developer Vertascale has announced the opening of its private beta for the company’s inaugural product, SimpleSearch. The SimpleSearch software provides powerful real-time query and summary analysis capability for structured and mix-structured data stored in Amazon S3 or the Hadoop File System (HDFS).

SimpleSearch - The Search Engine For Hadoop is aimed at providing benefit to engineers, data scientists and business analysts looking for faster “time to answer” on Big Data, the company said.

While Hadoop has been successful in addressing the problems of Big Data storage and batch processing, Vertascale’s founders recognized early on that in order to democratize access to Big Data, users needed an intuitive ad-hoc query capability. Vertascale is based in Menlo Park, California, USA.

“Today’s problem is less about storing data and more about being able to actually find what you’re looking for in the data. Everyone working with Big Data is challenged by the ‘I don’t know what I don’t know’ problem, and the prohibitively long iteration cycles. SimpleSearch lets you find, explore and export large data sets quickly and easily in a way that’s scalable and cost effective,” said Vertascale CTO Geoffrey Hendrey.

Added Vertascale President James Ladd, “With the rapid adoption of Hadoop, companies that recognize the value inherent in their data are also looking for simplicity and speed in querying Big Data.”

Vertascale will be demonstrating SimpleSearch, The Search Engine For Hadoop, at the Innovators Pavilion P23 at Strata 2013 in Santa Clara, USA.

- See more at: http://www.toolsjournal.com/cloud-articles/item/1449-vertascale-simplesearch#sthash.i44tZugb.dpuf

BIG Data Increasing the speed

Graphics Chips Help Process Big Data Sets in Milliseconds: A new database tool dramatica

Visualizing Big Data in Milliseconds on Cheap Computers

An Overview of MapD (Massively Parallel Database)

MapD is a software system that is designed to run on a hybrid architecture of GPUs and CPUs. Every modern computer has at least one CPU, and increasingly computer CPUs are divided into more than one sub-processing unit, called cores. It is not uncommon, as of early 2013,

Known as MapD, or massively parallel database, the new technology achieves big speed gains by storing the data in the onboard memory of graphics processing units (GPUs) instead of in central processing units (CPUs), as is conventional. Using a single high-performance GPU card can make data processing up to 70 times faster.

What are the Parts available in Hadoop 1.0?

Hadoop consists of two pieces 

* Map Reduce

* HDFS 

*Map Reduce 

This is Processing part of data.

for example: Job will run and nodes will be created. 

*HDFS: Hadoop Distributed File System.

 This is storing part of the data.

Happy coding. 

Bala

What is the Apache Hadoop?

=> Solutions for Big Data. 
It's deals with complexities of High Volume, Velocity and  Variety of data.

=> Set of Open Source Projects. 

=>Transforms commodity hardware in to services that 

It's stores petabytes of data reliability
Allows huge distributed computations.

=>Key Attributes.

It's redundant and reliable.
Extremely powerful.
Batch processing centric.
Easy to program distributed applications.
It's run on commodity hardware.

Big Data

Everyone talking about Big data in the industry, This is one of the major growing industry world wide.I was attended few session about Big data from Microsoft and some other vendor. 

It's really interesting stuff and gives more value to business, and that is the reason am writing to share Knowledge in Big data to all. 

Big Data,

This is nothing but a massive structure and unstructured data can't handle in a normal relational database management and it require to handle 10's and 100's servers. 

Example:

Facebook data, Tweeter data.

Manual Filter Will not enable the Table list click option in Qlikview

Step 1

Right click the list box and click Lock The filter and then the default selection will change to Blue color.

Step 2: 

Right click the list box and go to properties 

in General table select "Override Locked Field"

Now in the chart control enable to handle the selection one record.

Happy Coding.
Bala

Drop variable after use in Qlikview Load Script

LET vFromdate=Now()
LET vToDate=Today()
///LOADD ****
//From Table


LET vFromdate=;
LET vToDate=Null();

Inline Query Using Qlikview

Data1:
LOAD * INLINE [
    F1
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
];

>

Regex spliting the obs level in clarity

,regexp_substr(s_ndo.PATH,'[^/]+',1,6) OBSLevel6 ,regexp_substr(s_ndo.PATH,'[^/]+',1,5) OBSLevel5 ,regexp_substr(s_ndo.PATH,'[^/]+',1,4) OBSLevel4

Retrieving Multiple Roles through XOG out

<div dir="ltr" style="text-align: left;" trbidi="on"&rt; <div dir="ltr" style="text-align: left;" trbidi="on"&rt; <br /&rt; <nikudatabus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nonamespaceschemalocation="../xsd/nikuxog_read.xsd"&rt;</nikudatabus&rt;<br /&rt;   <br /&rt; <header action="read" externalsource="NIKU" objecttype="role" version="7.5"&rt;</header&rt;<br /&rt;   <query&rt;</query&rt;<br /&rt;  <filter criteria="OR" name="resourceId"&rt;CMS0001,CMS0002,BGUM_FO,APMDPASS,CMS0003,BGUM_US_Rolename,BGUM_US Rolename,CMS0004,CMS0005,CMS0071,CMS0006,CMS0007,CMS0066,CMS0008,CMS0009,CMS0010,CMS0011,CMS0012,CMS0013,CMS0014,CMS0015,CMS0016,CMS0017,CMS0018,CMS0019,PMD04599,CMS0020,CMS0021,CMS0022,CMS0023,ggggg,CMS0024,CMS0025,MS0026,CMS0068,CMS0027,CMS0028,CMS0029,CMS0030,CMS0031,CMS0032,CMS0033,CMS0034,CRS17157,CMS0035,MCS09573,CMS0036,CMS0063,CMS0037,CMS0038,CMS0067,CMS0039,CMS0062,CMS0040,CMS0070,CMS0041,CMS0042,CMS0043,CMS0044,CMS0045,CMS0069,CMS0046,CMS0047,CMS0048,CMS0049,CMS0050,CMS0051,CMS0052,CMS0053,CMS0054,CMS0055,CMS0056,CMS0057,CMS0058,CMS0059,CMS0060,CMS0072,CMS0061</filter&rt;<br /&rt;   </div&rt; <br /&rt; <br /&rt; Note: Don't give any gap in between resourceid.<br /&rt; <br /&rt; Happy Coding.</div&rt;

Week number display in VBA

Function GetPhilipsWeekYear(getDate As String)
Dim weeknumber As String
Dim YYYear As String
Dim mmmonth As String
Dim strDate As String

If getDate <> "" Then
' Getting the Week Number and Any format will convert to "mm-dd-yyyy"

strDate = Format(getDate, "mm-dd-yyyy")
weeknumber = Application.WorksheetFunction.WeekNum(strDate, 21)
' Getting the year from the date
YYYear = Year(getDate)
mmmonth = month(getDate)

If Len(weeknumber) = "1" Then
weeknumber = "0" & weeknumber
End If
            If ((weeknumber = "01") And (mmmonth = "12")) Then
            YYYear = YYYear + 1
            End If
            YYYear = Right(YYYear, 2)
            GetPhilipsWeekYear = YYYear & weeknumber
End If
End Function

Clarity Table Space

Clarity Table Space check for size of the memory

Log Files usage in clarity

Log Files usage in clarity

-          nsa-system.log   :- It is responsible for Niku system administrator.

-          nsa-niku.log :-It is about the niku User or application log from NSA.

-          pwr.log:-This is password reset log(Custom one)

-          admin.log:- This is Admin log of clarity application

-          app-niku.log:- This is application l

-          app-system.log:- This is system log for Application.

  Happy Coding

  Bala

Finding the Installation path for Clarity

Command prompt

Execute this commmand :


ECHO %Niku_Home%


Happy coding

Bala

MSP Is not opening

you can find the default attribute by using this table cmn_attributes table in the database.

  In future, if you receive this kind of issue, please go and check in MSPField table and should not be available any custom fields which is not available in cmn_attributes table.

                This issue I replicated by adding one more row with dummy value which is not available in cmn_attributes. I received the same issue and shown to Karthik (Support team).

                

Share point Introduction

Hierarchy of SharePoint Structure

=>Share point Collection
      =>Site1
               =>List (Enable to attachment)
               =>Library (file < mandatory)

Out of box feature for work flow

- We can add only work flow which is having Sequential/State Machine by using Workflow foundation.

Nintex Workflow

This is used for enterprise work flow.

Info path

This will be used to create the forms.

Roles
- Site collection  Administrator
- Owner
- Member
- Visitor

Schedule link error in MSP – ShedLink MFC Application has stopped working.

Impact:

all users

Analysis

I have done nearly some 50 combination testing to find the root cause and have replicated the same issue today in the QA environment and found the root cause is custom field attribute which is “included in database table “mspfield” and not there as per guideline CA and may be some update happen unknowingly.

Root cause

There is a table called “mspfield” in database and found many custom fields are stored.

Work Around

Deleted all the custom fields in MSPField table, the attribute which is not available in “cmn_attributes” table.

Permanent solution

I am in the process of finding system or someone. who was added the custom fields in “mspfield” field.

           

Microsoft Project Issue with Clarity

We faced the below in our company and found that custom fields we need to delete in this table

MSPField table in database.

Impact:

All the users will face this issue.

Analysis

I have done nearly some 50 combination testing to find the root cause and have replicated the same issue today in the QA environment and found the root cause is custom field attribute which is “included in database table “mspfield” and not there as per guideline CA and may be some update happen unknowingly.

Root cause

There is a table called “mspfield” in database and found many custom fields are stored.

Work Around

Deleted all the custom fields in MSPField table, the attribute which is not available in “cmn_attributes” table.

Permanent solution

I am in the process of finding system or someone. who was added the custom fields in “mspfield” field.

          

Query to get the resource details based Hiearchial

select srm.Full_name,

srm.last_name,

srm.first_name,

srm.email,

srm.User_Id,

srm.date_of_hire,

(select prIsOpen from prj_resources pr where srm.id=pr.prid) openfortime, 

(select full_name from srm_resources where user_id=srm.manager_id)manager_name,

(select ndo.path OBS from prj_obs_associations poa,nbi_dim_obs ndo where srm.id=poa.record_id 

AND poa.unit_id=ndo.obs_unit_id

AND ndo.obs_type_id='5000010')"Resource OBS",

(select srm.full_name from prj_resources pr where PR.PRPRIMARYROLEID = srm.ID and srm.id=pr.prid) Role,

(select cmn.name from cmn_lookups_v cmn where cmn.language_code='en' and cmn.lookup_type='SRM_RESOURCE_TYPE' and srm.person_type=cmn.id) "Employment Type",

--decode(SR.IS_ACTIVE, 0, 'Inactive', 1, 'Active') "Active/Inactive"

decode(user_status_id, 201, 'inactive', 200, 'Active',202,'Lock') "Active/Inactive/Lock"

--CSU.USER_STATUS_ID

from srm_resources srm,

cmn_sec_users csu,

prj_resources pr,

prj_obs_associations poa,

nbi_dim_obs ndo

where csu.id=srm.user_id and user_status_id='200'

AND srm.id=pr.prid

AND srm.id=poa.record_id

AND poa.unit_id=ndo.obs_unit_id

AND poa.table_name='SRM_RESOURCES'

AND ndo.obs_type_id='5000010'

and poa.unit_id='5000009'

Check the open connection and port in windows for clarity

netstat -an is the command to verify the open connection and port.

443 is the port for HTTPS.
80 is http

CA Clarity PPM Connectors for SAP

Please find the detail information in this link.

http://www.excers.com/ca-clarity-ppm-connectors.html

CA Clarity PPM Connectors

Excers’ CA Clarity PPM Connectors provide the ability to integrate CA Clarity PPM with other enterprise business systems such as your financial systems and HR systems. Our CA Clarity connectors are available for the leading ERP systems such as SAP, Oracle, PeopleSoft, and others. Our CA Clarity Connectors allow critical business data to be electronically passed between CA Clarity PPM and your financial and HR systems. They built on the concept of “enter the data once” in the appropriate system, and then electronically integrate the data between your business systems without additional manual entry of the same data. Improve data quality and integrity through the use of our CA Clarity PPM Connectors. Contact us today to learn about our CA Clarity PPM Connectors. Our CA Clarity PPM Consultants are available to assist you will any additional CA Clarity PPM integration needs. A Clarity PPM Report Package CA Clarity PPM Resource Management Report Package Excers’ CA Clarity PPM Resource Management Report Package is a set of Resource Management reports designed to help you analyze your resource capacity and utilization across your Projects, other Investments, and Departments. This Report Package contains is made up of Business Objects Crystal Reports that have been built on the concept of “Deploy it & Forget it”. The concept behind the development of these reports is to enable customers to quickly install, deploy, and uses them within the CA Clarity PPM Production environment. The CA Clarity PPM Resource Management Reports in this package were carefully design based on extensive experience gained from working with numerous CA Clarity PPM customers while helping them solve their Resource Management reporting needs. Features of our CA Clarity PPM Resource Management Reports include: Easily installed as part of your standard CA Clarity list of Business Objects Crystal Reports. Detailed Resource Utilization data by Resource and Resource Role. Detailed Resource Allocation data by Resource and Investments (Projects and other Non-Project Investment Objects). Detailed Percentage Utilization calculation based on Resource Availability and Investment Allocations. Resource Capacity data by FTE by department on a twelve (12) rolling timeframe. Detailed Resource Task Assignments. User Guide explaining how to use and run the reports. Benefits Install and already to use CA Clarity PPM Resource Management Reports. Easy to understand resource management data. Minimal setup required. Support and Training available from Excers. Contact us today to learn about our CA Clarity PPM Resource Management Report Package. Our CA Clarity PPM Consultants are available to assist you will any additional CA Clarity PPM reporting needs.

BEST Approach :Project Portfolio Management Tools

Please click on this below link for detail info.

http://www.prioritysystem.com/toolsabstract.html

Products Approach Examples About Terms of Use

Project Portfolio Management Tools: Which Approach is Best? — Abstract Printable version Project portfolio management (PPM) is a hot topic, and there is no shortage of advice on how to do it. Consulting companies and software vendors are offering tools for the job. Organizations can benefit considerably from improving the processes used to select and manage projects, but "caveat emptor," let the buyer beware. Much of the current advice on PPM is incomplete, inexact, or flat-out wrong. Available software provides good data management and reporting capabilities, but most current programs lack sound algorithms for identifying optimal project portfolios. Providing the wrong project recommendations is worse than providing no recommendations at all. The weak link for most tools is the lack of a quality decision model for recommending projects. This 7-part paper identifies available tools, describes the model that must be included within the tool if it is to make valid project recommendations, suggests criteria for evaluating tools, and offers recommendations for organizations interested in acquiring tools . Before purchasing a tool, buyers are advised to familiarize themselves with established theories for valuing projects and to reject tools that cannot be tailored to correctly apply these theories to their situations. Armed with understanding, organizations can avoid being "burned" by unsuitable and inadequate tools that are being pushed in the marketplace. Contents 1.   Tool Options 2.   Tool Differences 3.   Tool Costs & Risks 4.   Weak Link 5.   Decision Models 6.   Evaluating Tools 7.   The Best Approach

list of important columns in clarity database and tables.

First Name,
Last Name,
Email,
Resource ID,
Resource Manager (First name, Last Name)
OBS
Primary Role
Active
Open for Time
Date of Hire

select srm.Full_name,
srm.last_name,
srm.first_name,
srm.email,
srm.User_Id,
srm.date_of_hire,
(select full_name from srm_resources where user_id=srm.manager_id)manager_name,
(select ndo.path OBS from prj_obs_associations poa,nbi_dim_obs ndo where srm.id=poa.record_id
AND poa.unit_id=ndo.obs_unit_id
AND ndo.obs_type_id='5000010')"Resource OBS",
(select srm.full_name from prj_resources pr where PR.PRPRIMARYROLEID = srm.ID and srm.id=pr.prid) Role,
(select cmn.name from cmn_lookups_v cmn where cmn.language_code='en' and cmn.lookup_type='SRM_RESOURCE_TYPE' and srm.person_type=cmn.id) "Employment Type",
--decode(SR.IS_ACTIVE, 0, 'Inactive', 1, 'Active') "Active/Inactive"
decode(user_status_id, 201, 'inactive', 200, 'Active',202,'Lock') "Active/Inactive/Lock"
--CSU.USER_STATUS_ID
from srm_resources srm,
cmn_sec_users csu
where csu.id=srm.user_id and user_status_id='200'