tag:blogger.com,1999:blog-8309062399611979884.post3996332105837183406..comments2023-05-11T05:57:50.013-07:00Comments on Essbase'ish Stuff: Custom Built Oracle/Hyperion Essbase ASO Aggregate ViewsAlexhttp://www.blogger.com/profile/12374457004018943119noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-8309062399611979884.post-88807074792753474282017-05-11T11:19:19.928-07:002017-05-11T11:19:19.928-07:00Hi,
I put in my information for my 30 dimension c...Hi,<br /><br />I put in my information for my 30 dimension cube. I put in my outline id. When I click 'Generate Aggregate View File' I get:<br /><br />6<br />1448389478<br />0<br />1<br />View length 11 does not match the dimension count 30<br />0.1<br />View length 11 does not match the dimension count 30<br />0.1<br />View length 11 does not match the dimension count 30<br />0.1<br />View length 11 does not match the dimension count 30<br />0.1<br />View length 11 does not match the dimension count 30<br />0.1kwhttps://www.blogger.com/profile/15988987036587891766noreply@blogger.comtag:blogger.com,1999:blog-8309062399611979884.post-33306490462090267622016-01-05T23:59:15.174-08:002016-01-05T23:59:15.174-08:00Very detail information. Thank you very much!!Very detail information. Thank you very much!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8309062399611979884.post-22740509217719883792014-07-21T09:53:01.327-07:002014-07-21T09:53:01.327-07:00I put in your recommended values and get same resu...I put in your recommended values and get same result:<br /><br />6<br />3767249413<br />0<br />1<br />Specified argument was out of the range of valid values.<br />Parameter name: Level 3 cannot be greater than the dimension Years max level 0<br />0.1<br />Specified argument was out of the range of valid values.<br />Parameter name: Level 3 cannot be greater than the dimension Years max level 0<br />0.1<br />Specified argument was out of the range of valid values.<br />Parameter name: Level 1 cannot be greater than the dimension Version max level 0<br />0.1<br />Specified argument was out of the range of valid values.<br />Parameter name: Level 1 cannot be greater than the dimension Years max level 0<br />0.1<br />Specified argument was out of the range of valid values.<br />Parameter name: Level 3 cannot be greater than the dimension Years max level 0<br />0.1<br />kwhttps://www.blogger.com/profile/15988987036587891766noreply@blogger.comtag:blogger.com,1999:blog-8309062399611979884.post-3170596010062891232014-07-21T01:50:13.578-07:002014-07-21T01:50:13.578-07:00For an outline with num_levels (1,3,2,1,1,4,5,4,9,...For an outline with num_levels (1,3,2,1,1,4,5,4,9,8,30) the maximum view you can build is (0,2,1,0,0,3,4,3,8,7,29). This is because the counting starts from 0 not 1. So if the dimension has 2 levels it means you can use 0 and 1, if it has 3 levels you can use 0,1,2 and so on.<br /><br />I found that sometimes I get the "1013176 Corrupt viewfile" message if I don't put the a newline of the last row or because of file encoding or CRLF vs LF line breaks. You might want check this.<br /><br />The last dimension looks like it has a few of attribute dims. Each attribute will create at least 2 levels on top of the existing levels. You just need to be aware of this when building agg views in order to get the best performance.Alexhttps://www.blogger.com/profile/12374457004018943119noreply@blogger.comtag:blogger.com,1999:blog-8309062399611979884.post-41502165470055444692014-07-19T13:40:53.598-07:002014-07-19T13:40:53.598-07:00I put my dimension in the tool and I get this when...I put my dimension in the tool and I get this when I process:<br /><br />6<br />3767249413<br />0<br />1<br />Specified argument was out of the range of valid values.<br />Parameter name: Level 3 cannot be greater than the dimension Years max level 2<br />0.1<br />Specified argument was out of the range of valid values.<br />Parameter name: Level 3 cannot be greater than the dimension Years max level 2<br />0.1<br />Specified argument was out of the range of valid values.<br />Parameter name: Level 1 cannot be greater than the dimension Version max level 1<br />0.1<br />Specified argument was out of the range of valid values.<br />Parameter name: Level 1 cannot be greater than the dimension Scenario max level 1<br />0.1<br />Specified argument was out of the range of valid values.<br />Parameter name: Level 3 cannot be greater than the dimension Years max level 2<br />0.1<br />kwhttps://www.blogger.com/profile/15988987036587891766noreply@blogger.comtag:blogger.com,1999:blog-8309062399611979884.post-90025195296780735842014-07-19T13:36:07.982-07:002014-07-19T13:36:07.982-07:00There was already a VF_FILE1 in the directory so I...There was already a VF_FILE1 in the directory so I saved it as VF_FILE2.csc<br /><br />OK/INFO - 1051034 - Logging in user [karthik@Native Directory].<br /> OK/INFO - 1241001 - Logged in to Essbase.<br /><br /> essmsh timestamp: Sat Jul 19 15:27:39 2014<br /><br />MAXL> execute aggregate build on database EXP_RPT.EXP_RPT using view_file 'VF_FILE2';<br /><br /> ERROR - 1013176 - Corrupt viewfile [VF_FILE2].<br /><br /> essmsh timestamp: Sat Jul 19 15:27:39 2014<br /><br /><br /> essmsh timestamp: Sat Jul 19 15:27:39 2014<br /><br />MAXL> query database EXP_RPT.EXP_RPT list existing_views;<br /><br /> view_id view_levels size_ratio_estimate query_cost outline_id size_ratio_actual size_cells size_kb <br />+-------------------------------------------------+-------------------------------------------------+-------------------------------------------------+-------------------------------------------------+-------------------------------------------------+-------------------------------------------------+-------------------------------------------------+-------------------------------------------------<br /> 0 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0/0 1 61678.66811329 3767249413 1 524906356 8681152<br /><br /> OK/INFO - 1241044 - Records returned: [1].<br /><br /> essmsh timestamp: Sat Jul 19 15:27:39 2014<br /><br />MAXL> logout;<br /><br /> User karthik is logged out<br /><br /> essmsh timestamp: Sat Jul 19 15:27:39 2014kwhttps://www.blogger.com/profile/15988987036587891766noreply@blogger.comtag:blogger.com,1999:blog-8309062399611979884.post-56731610786047997542014-07-19T13:34:39.644-07:002014-07-19T13:34:39.644-07:00How do I get this to work. I get:
MAXL> execu...How do I get this to work. I get:<br /><br />MAXL> execute aggregate selection on database EXP_RPT.EXP_RPT selecting 1 views force_dump to view_file 'VF_FILE1';<br /><br /> view_id view_levels size_ratio_estimate query_cost outline_id <br />+-------------------+-------------------+-------------------+-------------------+-------------------<br /> 0 0, 0, 0, 0, 0, 0, 0 1 61678.66811329 3767249413<br /><br /> WARNING - 1241024 - Possible string truncation in column 2.<br /> WARNING - 1241028 - Output column defined with warnings.<br /> OK/INFO - 1241044 - Records returned: [1].<br /><br /> essmsh timestamp: Sat Jul 19 15:06:02 2014<br /><br />MAXL> query database EXP_RPT.EXP_RPT list aso_level_info;<br /><br /> dimension num_levels <br />+-------------------+-------------------<br /> PrimeASO 1<br /> PeriodASO 3<br /> Years 2<br /> Scenario 1<br /> Version 1<br /> Lead Medical Fundin 4<br /> Cost Category 5<br /> Segment 4<br /> Product 9<br /> Legal Entity 8<br /> Expense Center 30<br /><br /> WARNING - 1241024 - Possible string truncation in column 1.<br /> WARNING - 1241028 - Output column defined with warnings.<br /> OK/INFO - 1241044 - Records returned: [11].<br />kwhttps://www.blogger.com/profile/15988987036587891766noreply@blogger.comtag:blogger.com,1999:blog-8309062399611979884.post-61897441307097360362014-06-02T03:38:42.742-07:002014-06-02T03:38:42.742-07:00Done. I actually used it with 20+ dims and it work...Done. I actually used it with 20+ dims and it works well.Alexhttps://www.blogger.com/profile/12374457004018943119noreply@blogger.comtag:blogger.com,1999:blog-8309062399611979884.post-66961504670388197452014-05-29T07:49:55.452-07:002014-05-29T07:49:55.452-07:00I'm trying to use this process on a cube with ...I'm trying to use this process on a cube with 32 dimensions - can the web app be updated to allow for scrolling so more dimensions can be added? Anonymoushttps://www.blogger.com/profile/12875329655941900190noreply@blogger.com