This time I just want to share with you something new which I tried along with my team due to curiosity.
Objective: “Our Objective was to check whether we can submit the text data instead of numeric in PPS, by using Excel Add-In form.The reason is when we create the measure in the PPS its gets created as a float data type in the Model Database. We assumed that if we change the data type in database it should work”
What we did:We straight away went ahead and changed the data type of the measure in the Table in SQL Server 2005.
Conclusion: Hence we concluded that we cannot use PPS Excel add-in to enter text data as it has some built-in intelligence/Validation which gets fired when the submit button is hit and restricts user to do so.
I wanted to share this experience as I feel there would be lot many users like me who must be thinking why we can’t use the Excel add-in form to enter the Text data.
Will keep on updating you all with the new developments at our end :), till then cheers
Objective: “Our Objective was to check whether we can submit the text data instead of numeric in PPS, by using Excel Add-In form.The reason is when we create the measure in the PPS its gets created as a float data type in the Model Database. We assumed that if we change the data type in database it should work”
What we did:We straight away went ahead and changed the data type of the measure in the Table in SQL Server 2005.
- Processed the cube
- Created the Data Entry Form by using Excel Add-In by selecting the required dimensions and the Measure which we created as a Character Data Type.
- Created the Cycle in the Business modeler and published the form.
- Opened the data entry form as a assignment and we were able to see the yellow data entry region on the form. So far so good.
- We started entering the numeric and text values on the form as our assumption was it just submits the data in the database without doing any validation, because we have already changed the data type of the destination field
- But we were wrong. Excel Add-in immediately flashed the error message that only numeric data type was allowed.
Conclusion: Hence we concluded that we cannot use PPS Excel add-in to enter text data as it has some built-in intelligence/Validation which gets fired when the submit button is hit and restricts user to do so.
I wanted to share this experience as I feel there would be lot many users like me who must be thinking why we can’t use the Excel add-in form to enter the Text data.
Will keep on updating you all with the new developments at our end :), till then cheers
3 comments:
Hi Manish,
You can post textual data in PPS Data Entry Forms using the Annotation feature.
Thanks,
Ajay
Hi Ajay,
Thank for your comment.
If you see in the post I was refering to posting of text data in the Fact table (2nd Bullet point in What we did).
Annotations are the Comments which gets stored in A_ModelNanme_MeasureGroup table which is different from the fact table.
you give the comments in the Excel Addin by right clicking the cell and adding the comments.
These two are different scenario alltogether.
Thanks and Regards,
Manish
Hi Manish,
Wanted to contact you via Email but couldn't found your email in your Blog Profile.
Just wanted some clarification from you on Certification of PPS (Exam 70-556).
Basically I am a part-time (after Office hours at Home) learner of PPS and I am very much interested in clearing the Exam 70-556. I am working in a Company (Host Analytics) from part 7 Yrs which has its own CPM Product.
As you have already cleared this exam, if you can provide some guidance to me on which of the areas (I have the Exam Outline details) to focus and at which level depth to focus (as we can really configure some complex implementation).
Basically from the objective of clearing the exam if you can share some valuable thoughts that will be helpful.
You can contact me at ajay555@gmail.com
My Blog Info: http://ppsinfo.blogspot.com/
Looking forward to your reply.
Thanks
Ajay
Post a Comment