on 06-21-2007 10:42 AM
Hey here i have a problem in layout in using VBA(visual basic for applications)...
i have created a layout using 5 keyfigures from cube and i included two calculated columns along with them, and am also using a variable for 0 calweek here, here when i execute the layout all the data for 5keyfigures gets aggregated but the data for the added two columns are not getting aggregated...i know i have to use VBA in solving this issue but i have no idea abt VBA, can anybody help me in solving this issue...i guess the first columns in the layouts should be the keyfigure from the cube...please help me in solving this issue
Hi Lavnaya,
Could you please explain in details what your intended VBA will do, then it will be easy for us to tell you how to write the code.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
My actual requirement is on using a variable for 0calweek...i mean i have created a layout where i use a variable to to see the data on weekly basis...i have created a variable to on 0calweek to see the selected weeks data...here in the layout i have created two calculated columns where this variable will not work for this two columns as its data is not coming from the cube...i have done layout for 26weeks...when i select from and to weeks between 1 to 6weeks all the data can been seen till6th week but the data for the two added columns is showing for all the weeks from 1 to 26th week...it is not getting aggregated to 6 weeks...i want to see selected data for those two columns data also....i guess you got my point...
Thanks in advance...
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.