rahuls - Developer IT

Error : Member 'D-T-D' in the Period dimension has no value for the Period Type property

- by RahulS

Workaround for LCM EPMA deploy errors: Error : Member 'D-T-D' in the Period dimension has no value for the Period Type property. Error : Member name 'D-T-D' in the Period dimension is only valid when Period Type is set to 'DTS Time Period'. Error : Member 'W-T-D' in the Period dimension has no value for the Period Type property. Error : Member name 'W-T-D' in the Period dimension is only valid when Period Type is set to 'DTS Time Period'. Error : Member 'M-T-D' in the Period dimension has no value for the Period Type property. Error : Member name 'M-T-D' in the Period dimension is only valid when Period Type is set to 'DTS Time Period'. Error : Member 'Q-T-D' in the Period dimension has no value for the Period Type property. Error : Member name 'Q-T-D' in the Period dimension is only valid when Period Type is set to 'DTS Time Period'. Error : Member 'P-T-D' in the Period dimension has no value for the Period Type property. Error : Member name 'P-T-D' in the Period dimension is only valid when Period Type is set to 'DTS Time Period'. Error : Member 'S-T-D' in the Period dimension has no value for the Period Type property. Error : Member name 'S-T-D' in the Period dimension is only valid when Period Type is set to 'DTS Time Period'. Error : Member 'Y-T-D' in the Period dimension has no value for the Period Type property. Error : Member name 'Y-T-D' in the Period dimension is only valid when Period Type is set to 'DTS Time Period'. Error : Member 'H-T-D' in the Period dimension has no value for the Period Type property. Error : Member name 'H-T-D' in the Period dimension is only valid when Period Type is set to 'DTS Time Period'. Fix 1. Edit the Period dimension LCM artifact (Keep the back up of the file before editing.) 2. Delete the DTS members (for example as mentioned below) in the Period dimension hierarchy section. #root|D-T-D|True|||||||||||||||| #root|W-T-D|True|||||||||||||||| #root|M-T-D|True|||||||||||||||| #root|Q-T-D|True|||||||||||||||| #root|P-T-D|True|||||||||||||||| #root|S-T-D|True|||||||||||||||| #root|Y-T-D|True|||||||||||||||| #root|H-T-D|True|||||||||||||||| 3. Delete the DTS members (for example as mentioned below) in the Period member hierarchy section, D-T-D|True|||||||||||||||| W-T-D|True|||||||||||||||| M-T-D|True|||||||||||||||| Q-T-D|True|||||||||||||||| P-T-D|True|||||||||||||||| S-T-D|True|||||||||||||||| Y-T-D|True|||||||||||||||| H-T-D|True|||||||||||||||| 4. Then save the edited Period dimension LCM artifact. 5. Then try to import the Period dimension using LCM. 6. Then Validate/Deploy the Planning application still the same issue. PS: This issue is fixed in 11.1.2.2.

Read the article

LCM says Smart List import is complete but actually its not...Here are probable reasons

- by RahulS

First of all some basics of smart list: Administrators use Smart Lists to create custom drop-down lists that users access from data form cells. When clicking in cells whose members are associated with a Smart List (as a member property), users select items from drop-down lists instead of entering data. Users cannot type in cells that contain Smart Lists. Smart Lists display in cells as down arrows that expand when users click into the cells. Below link will give you more information on Smart Lists: http://download.oracle.com/docs/cd/E17236_01/epm.1112/hp_admin/enum_pg.html I got a simple query today, "The LCM process generates and indicates a status of "Complete", however, the 3,018 records do not appear in the Planning application. No error exists in the log to identify the problem." Things which can be checked in this case: 1. Spaces are not allowed in the Entry Name, 2. Spaces are allowed in the Entry Label, 3. The name must start with an alpha character or underscore, 4. Valid characters for the remaining part of the name must be alpha, numeric, or an underscore, 5. Enter a name that is unique within the smart list, 6. I am not sure about the limits but I have seen 22,000 members loaded fine, 7. ID for every entry should be unique, 8. IDs need not to be consecutive, Ex: It was go from 1 to 100 then 500 to 900 then 1900 to 4500 etc. While import .xml file using LCM there were no errors in the foundation and LCM migration logs, but when checked in the HyS9PlanningSysErr.log, few errors were found:Ex: The name Data_Coord_(Prod)_ACS is invalid, The name Sr_Dir_b+Medcd_Gvt_Rel_Sls_Mkt is invalid, The name entered is invalid. Enter a name that is unique within the smart list, Also, we can Load Smart List dimensions and Smart List dimension entries using the /DS:HSP_SMARTLISTS parameter in outlineload utility: OutlineLoad /A:acpt /U:admin /M /I:c:/smartlist_create1.csv /DS:HSP_SMARTLISTS /L:c:/OutlineLogs/outlineLoad.log /X:c:/OutlineLogs/outlineLoad.exc SmartList Name, Operation, Label, Display Order, Missing Label, Use Form Missing Label, Entry ID, Entry Name, Entry Label SL1,addsmartlist,SL1Label,,,,,, SL1,addEntry,,,,,,entry1,entrylabel1 SL1,addEntry,,,,,,entry2,entrylabel2 Cheers..!!! Rahul S. http://www.facebook.com/pages/HyperionPlanning/117320818374228

Read the article

Extracting the Layout of all the Data Forms from the Relational Database

- by RahulS

Today I came across a question from one of our clients that: "what members are used on each data form WITHOUT having to go through the report generated out of our Planning app". We worked with client on this and reached to a simple query. All the form related information is stored in the following tables: HSP_FORM HSP_FORMOBJ_DEF HSP_FORMOBJ_DEF_MBR HSP_FORM_ATTRIBUTES HSP_FORM_CALCS HSP_FORM_DV_CONDITION HSP_FORM_DV_PM_RULE HSP_FORM_DV_RULE HSP_FORM_DV_USER_IN_PM_RULE HSP_FORM_LAYOUT HSP_FORM_MENUS HSP_FORM_VARIABLES If we want to retrieve just the members included, we can concentrate on: HSP_OBJECT to get the Object_ID for form, Object_Type is 7 for forms. (Ex: Select * from HSP_OBJECT where OBJECT_TYPE = 7) HSP_FORMOBJ_DEF Find the OBJDEF_ID for a particular form HSP_FORMOBJ_DEF_MBR Use the above OBJDEF_ID to find the members: Here the Mbr_ID is the Id of the member and Query_Type is the Function like Idesc, Level0 etc and Sequce is you sequence, And the final table we can use is HSP_FORM_LAYOUT: Layout_Type: 0->Pov 1-> Page, 2->Row, 3->Col, DIM_ID is the dimension ID and Ordinal is position. Here is the Query: SELECT HSP_OBJECT.OBJECT_NAME AS 'Form', HSP_OBJECT_2.OBJECT_NAME AS 'Dimension', HSP_OBJECT_1.OBJECT_NAME AS 'Member', HSP_FORMOBJ_DEF_MBR.QUERY_TYPE FROM <DatabaseName>.dbo.HSP_FORM_LAYOUT HSP_FORM_LAYOUT, <DatabaseName>.dbo.HSP_FORMOBJ_DEF HSP_FORMOBJ_DEF, <DatabaseName>.dbo.HSP_FORMOBJ_DEF_MBR HSP_FORMOBJ_DEF_MBR, <DatabaseName>.dbo.HSP_MEMBER HSP_MEMBER, <DatabaseName>.dbo.HSP_OBJECT HSP_OBJECT, <DatabaseName>.dbo.HSP_OBJECT HSP_OBJECT_1, <DatabaseName>.dbo.HSP_OBJECT HSP_OBJECT_2 WHERE HSP_OBJECT.OBJECT_ID = HSP_FORMOBJ_DEF.FORM_ID AND HSP_FORMOBJ_DEF_MBR.OBJDEF_ID = HSP_FORMOBJ_DEF.OBJDEF_ID AND HSP_MEMBER.MEMBER_ID = HSP_FORMOBJ_DEF_MBR.MBR_ID AND HSP_OBJECT_1.OBJECT_ID = HSP_MEMBER.MEMBER_ID AND HSP_OBJECT_2.OBJECT_ID = HSP_MEMBER.DIM_ID AND HSP_FORM_LAYOUT.DIM_ID = HSP_MEMBER.DIM_ID AND HSP_FORM_LAYOUT.FORM_ID = HSP_FORMOBJ_DEF.FORM_ID AND ((HSP_OBJECT.OBJECT_TYPE=7)) ORDER BY HSP_OBJECT.OBJECT_NAME Concentrate on Test1 data form and Actual Layout of it as follows: Corresponding Query_type for few of the functions: 9 for Idesc, 3 for Ancestors, -9 for ILvl0Des, 8 for Desc, 4 for IAncestors Its just a basic idea you can do lot on the basis of this. Cheers..!!! Rahul S. http://www.facebook.com/pages/HyperionPlanning/117320818374228

Read the article

Can't save data for a member in a data form

- by RahulS

Implied sharing is an old thing everyone knows the reasons and solutions of that, still little theory about that: With Essbase implied sharing, some members are shared even if you do not explicitly set them as shared. These members are implied shared members. When an implied share relationship is created, each implied member assumes the other member’s value. Essbase assumes (or implies) a shared member relationship in these situations: 1. A parent has only one child 2. A parent has only one child that consolidates to the parent In a Planning form that contains members with an implied sharing relationship, when a value is added for the parent, the child assumes the same value after the form is saved. Likewise, if a value is added for the child, the parent usually assumes the same value after a form is saved.For example, when a calculation script or load rule populates an implied share member, the other implied share member assumes the value of the member populated by the calculation script or load rule. The last value calculated or imported takes precedence. The result is the same whether you refer to the parent or the child as a variable in a calculation script. For more information have a look at: http://docs.oracle.com/cd/E17236_01/epm.1112/hp_admin_11122/ch14s11.html Now the issue which we are going to talk about is We loose data on save even when the parent is dynamic calc and has a single child. A dynamic calc parent to a single child: If we design the form with following selection: In the data form we will find parent below the member and this is by design whenever you make a selection using commands to select all the member below parent, always children will appear before the parent: Lets try to enter data, Save it Now, try to change the way we selected members Here we go: Now the question again why this behavior: 1. Data from Planning data form passes to Essbase row by row, 2. Because in data form the child member appears before the parent, 3. First, data goes to Essbase for child (SingleStoreChild), 4. Then when Planning passes the data for parent there was #Missing or No data, 5. Over writes the data to #missing. PS: As we know that dynamic calc members are calculated on the fly they are not allocated with any memory in the Essbase, here the parent was dynamic calc and it was pointing to same memory as child in the background, when Planning was passing data to Essbase for second row it has updated the child with missing data.(Little confusing, let me know if you need more explanation) 6. As one of the solutions just change the order of appearance of parent and child. Cheers..!!! Rahul S. https://www.facebook.com/pages/HyperionPlanning/117320818374228

Read the article

How do I retrieve a success message in Magento?

- by Raul

How do I retrieve a success message in Magento? Array ( [core] => Array ( [_session_validator_data] => Array ( [remote_addr] => 192.168.151.102 [http_via] => [http_x_forwarded_for] => [http_user_agent] => Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.70 Safari/533.4 ) [session_hosts] => Array ( [technova2] => 1 ) [messages] => Mage_Core_Model_Message_Collection Object ( [_messages:protected] => Array ( ) [_lastAddedMessage:protected] => Mage_Core_Model_Message_Success Object ( [_type:protected] => success [_code:protected] => Your review has been accepted for moderation [_class:protected] => [_method:protected] => [_identifier:protected] => [_isSticky:protected] => ) ) [just_voted_poll] => [visitor_data] => Array ( [] => [server_addr] => -1062692990 [remote_addr] => -1062693018 [http_secure] => [http_host] => technova2 [http_user_agent] => Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.70 Safari/533.4 [http_accept_language] => en-US,en;q=0.8 [http_accept_charset] => ISO-8859-1,utf-8;q=0.7,*;q=0.3 [request_uri] => /~rahuls/sextoys/index.php/review/product/list/id/169/ [session_id] => 21bq2vtkup5m1gtghknlu1tit42c6dup [http_referer] => http://technova2/~rahuls/sextoys/index.php/review/product/list/id/169/ [first_visit_at] => 2010-06-16 05:49:56 [is_new_visitor] => [last_visit_at] => 2010-06-16 06:00:00 [visitor_id] => 935 [last_url_id] => 23558 ) [last_url] => http://technova2/~rahuls/sextoys/index.php/review/product/list/id/169/ ) ) After posting the review I want to display the message: "Your review has been accepted for moderation". It appears in the $_SESSION array, but how do I fetch it? Please help. Thanks in advance.

Read the article

How to get reviews success message in magento?

- by Raul

Developer IT