"I wish I knew Debbie,
I thought I was on the right track, but never got it to actually show up in the excel output.
Most of what I came up with was by trial and error, so I don't know if there is an official way to do it.
And I haven't…"
-
Clark Walliser
- Male
- San Jose, CA
- United States
- Blog Posts
- Discussions (8)
- Groups (1)
- Photos
- Photo Albums
- Videos
Clark Walliser's Discussions
SMI How to add a new expression to the layout page
7 Replies
I followed the instructions in another post to create a new expression for PY2ActitivityPer01 for 2 years back. Now I want to add it to a report. When I load the layout, the new expression is not…Continue
Started this discussion. Last reply by Clark Walliser Apr 17.
Clark Walliser's Page
Latest Activity
Clark Walliser replied to Clark Walliser's discussion SMI How to add a new expression to the layout page"Clark,
I have followed your steps for a 5 year trend and I only ever get the last year; never get data in PY1, PY2, PY3 or PY4; only PY5. What am I doing wrong?
Debbie Long"
"Clark,
I have modified the SQL statement in the Container, under Properties, Hints as follows:
<hints> <workertables> <table…"
Clark Walliser replied to Clark Walliser's discussion SMI How to add a new expression to the layout page"I'm just in the process of figuring this out myself. This is what I have found...
1. In the connector, drill down to the container you are using (for me it was Financial Reports).
2. Create the new expressions in the container.
3. For SMI to…"
Clark Walliser replied to Michelle Montgomery's discussion 5 Yr YTD Trend Report for MAS90"Hi Stephen,
I did what you suggested about copying the PYActivityPeriod01 to PY2ActivityPeriod1 and changing the expression to say @FISYEAR@ -2.
I have specifically entered data for 2 years prior, but the report still returns zero for the…"
Clark Walliser replied to Michelle Montgomery's discussion 5 Yr YTD Trend Report for MAS90"I have followed the information on this link to create an expression for the prior/prior year, and I show the field on the layout, but no data shows for it. I have added transactions in MAS90 GL and can see them there.
Any idea what I might be doing…"
Clark Walliser commented on Stephen Coull's group Sage ERP MAS Intelligence"Sue, I have looked on Sage U and did not find any advanced SMI courses available. If they are there, they are not easy to find."
Clark Walliser replied to Michelle Montgomery's discussion 5 Yr YTD Trend Report for MAS90"Hi Michelle,
I'm curious to know what your company ended up using, and if it has fulfilled expectations.
Do you think the SMI version 4.5 with reporting trees would have accomplished what you wanted?
"
Keith Govender replied to Clark Walliser's discussion SMI How to add a new expression to the layout page"You are on the right track!!"
Clark Walliser replied to Michelle Montgomery's discussion 5 Yr YTD Trend Report for MAS90"Hi Michelle,
Did you ever get resolution on the 5 Yr Trend Report in SMI?
I am trying to do a 3 year trend, but keep getting various errors.
Do you remember if there were any special tricks you figured out?
What do you think of Alchemex/SMI after…"
Clark Walliser replied to Clark Walliser's discussion SMI How to add a new expression to the layout page"Ok, I think I figured it out. Let me know if I am heading the right direction, or off a cliff... :)
Step 1. How to create the new expression fields
In the connector app, double click on the connector I am using (in this case the SOTAMAS…"
Keith Govender replied to Clark Walliser's discussion SMI How to add a new expression to the layout page"Hi Clark,
I am looking into this one for you.
Thanks!"
Clark Walliser posted a discussionSMI How to add a new expression to the layout page
I followed the instructions in another post to create a new expression for PY2ActitivityPer01 for 2 years back. Now I want to add it to a report. When I load the layout, the new expression is not available. How do I make it available?p.s. I am still looking for SMI training courses that go beyond modifying an existing report.Any suggestions?See More
"Hello Clark and welcome to the BI Community. For access to videos, user guides, data dictionaries and much more. Join the Sage ERP MAS Intelligence Group. Select Join Group now on the group page…"
Profile Information
- Alchemex Powers the Following BI Solution, Pick Yours
- Sage MAS Intelligence
- Website
- http://www.quanterasystems.com
- About Me:
- Senior Consultant working primarily with MAS applications.
- How long have you been using the above solution?
- 17 year
- Where did you hear about us?
- Invitation
Comment Wall (1 comment)
- At 11:41pm on August 8, 2011,
Ruth Gray said…
Hello Clark and welcome to the BI Community. For access to videos, user guides, data dictionaries and much more. Join the Sage ERP MAS Intelligence Group. Select Join Group now on the group page http://community.alchemex.com/group/sagemasintelligence
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
