Enthusiastic innovator, SAS BI evangelist, author & hired gun, pursuing design tips, programming tricks & other sundries to share.
BASE SAS, SAS BI, SAS STPs, SAS VA
I was thinking since it was a calculated measure that the hierarchy would understand based on the date value. I'm guessing that is not what is working from your answer. 😞
... View more
This might work .... you can create a computed column with a formula something like this formula. I'm assuming the values Transaction Date and Product Sale Price. $YTD IF ( ( Year (TransactionDate) = Year(DatePart( NOW()) ) ) AND ( DayOfYear(TransactionDate) <= DayofYear(Datepart(NOW()) ) ) ) RETURN Product Sale Price ELSE 0 Message was edited by: Patricia Aanderud
Then you could Sum the $YTD value or create an aggregated calculation from it.
... View more
Hi! I'm excited that this group was started! I love the black jelly beans! It's great when I can find someone who hates them - no fighting over the precious few available. Tricia
... View more
Here's a blog post I wrote about using date range prompts - it might help you figure out where the issue is: http://www.bi-notes.com/2011/12/prompts-how-do-i-use-a-date-range-prompt/
... View more
Check Angela's blog post that shows how to work with the metadata - specifically she shows the stored processes - but this can be expanded to other metadata. Various ways of locating components of stored processes
... View more
Grandhi4: Angela and I have contributed a lot of free content to the SAS community. Check the SAS Global Forum Proceedings, SAS Community, and even our blogs. BI Notes Blog/ Real BI for Real Users - SAS BI tips, lessons learned, problems and successes SAS Global Forum Proceedings SAS Community Good luck as you pursue your career. Tricia
... View more
Scott: Here's a link to the site where you can download the table of contents: http://www.bi-notes.com/the-50-keys-to-learning-sas-stored-processes/ Two of the chapters discuss using stored processes with the BI tools and the web. The other information would be useful to learning how to write stored processes and giving you some ideas of the many ways these can be used. Tricia
... View more
Scott: When the code runs in the background - it allows the user to break away from the Web Browser session. Else if you started running the stored process and closed the browser -- then your STP stops. Long running STPs obviously creates a great chance that the user will close the browser without realizing what he/she did. I'm blogging about STP topics at Business Intelligience Notes for SAS BI Users and have co-authored a one-spot reference book about learning Stored Processes that discussing topics such as this one. Tricia
... View more
Tej: In the newly released The 50 Keys to Learning SAS Stored Processes book this example along with other ways to use stored processes with the SAS BI clients are shown step-by-step. Hope this helps, Tricia
... View more
With some careful processing you can add HTML and even JavaScript to a stored process. It can be tricky to learn but does add to the robustness of the stored process. You can find SAS Global Forum papers which describe the techniques. However, in the newly released "The 50 Keys to Learning SAS Stored Processes" book you are guided through the process of adding HTML code or JavaScript code to a stored process. Using simple code, we build on each example until you have created a form that allows a user to upload a file that can be uploaded. The book also shows many tips and tricks for writing and debugging stored processes. Hope this helps, Tricia
... View more
