cancel
Showing results for 
Search instead for 
Did you mean: 

Need help in the using VBA in BPS

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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...