Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
saimahasan
Partner - Creator III
Partner - Creator III

Bookmark not working for adhoc report

Hi All,

I need to create and use bookmarks for my adhoc report. But when i view the bookmark it shows some other selections with error : Error: error in expression.

Please suggest.

10 Replies
avinashelite

have you changed the data model ??

saimahasan
Partner - Creator III
Partner - Creator III
Author

No i have just added the dimension and measure tables. Rest its same. Bookmarks are working for other charts but not working only for adhoc

avinashelite

new dimension in the script or UI ...can you will with an example 

saimahasan
Partner - Creator III
Partner - Creator III
Author

I have created an excel with Dimensions and Measures. Loaded it in my data model and created my adhoc report. Now when i select anything in the adhoc report and mark it as bookmark, it does not give me the selected values when i reuse that bookmark.

avinashelite

I checked the its working for me..

Check this things once.

1.Make all the selections and go to bookmarks

2.In the Bookmarks option > select Include selections in Bookmarks

3.Check all the necessary things and one more thing if you had any single select in any list box retain that

if still it did not work , share the app let me check once

saimahasan
Partner - Creator III
Partner - Creator III
Author

Please find attached the sample file for bookmarks and the error i am getting.

Please suggest.

In this when you select any bookmark it shows author_name as default selection in current selection box.

avinashelite

Got the issue , this bookmark is working fine ...

because  you have used the on filed event  Trigger =If(GetFieldSelections(customer_first_name)='Franklin',' ') 

Go to document properties >Triggers > check the filed Event Trigger > customer_first_name

saimahasan
Partner - Creator III
Partner - Creator III
Author

Yes i have applied that trigger because i need it. My requirement is the same. I need to clear some fields on triggers and also use bookmarks. Please suggest

saimahasan
Partner - Creator III
Partner - Creator III
Author

Can we use alternate states in this scenario??