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'