Skip to Content
0

saved workbooks not working after changing query structure

Nov 10, 2017 at 04:31 AM

23

avatar image
Former Member

Dear All,

I need a urgent solution.

We have bex query, having a global structure in "columns" section

That is,the structure is having a technical name with selections as Jan YTD,FEB YTD etc for current year and Current year +1,Current year +2.

By mistake we removed the current year +1 and Current +2 selections and later we reverted CY+1 and CY+2.

Now, when the business users refreshes the saved workbooks in their local machin, it is not working .Showing "no applicable" data.

As a temporary solultion, we can re-attached the query and it works fine.

Now, bussiness users says, they have 100s of dumps having marcros attaches to the work books.We cant go with temporary solution.

So, Can anyone please guide me how to fix the query struture.

Please note that there is no change in the strcuture technical name.That is ,remove reference is not done.We just removed CY+1 and CY+2 from the structure and put the same back.

Regards

Pradeep

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers