Wasting Time? Time is wasted when:- A group of people must wait for one person.- A Team cannot readily access the same document or data.- A Task must be redone due to insufficient supervision.
'Horizontal' Software may be called a Suite - or a Platform. - It is very flexible & made to Create new information.- Can be used to create Vertical (specific) Applications.- An example would be 'Adobe Creative Suite'or MS Office.Vertical Software is developed for a specific set of Tasks.
The Platform is Broad & flexible by Design.- WYSIWYG Design tools for Novices autogenerates code.- Powerful Editors allow Experts to further customize.- Includes an underlying and thoroughly integrated database.- Robust, multiuser access without onerous fees.
Wasting Talent? Talent is wasted when:- An Expert is assigned a task that is suitable for a Novice.- A Novice is assigned a Task that way over his/her head.- A Novice that is eager to learn new skills is denied access.- Team members are pigeonholed. Latent talent, undeveloped.
There is another 'Great Divide' and that is the one between the Haves and the Have Nots. Younicycle is affordably priced for any business, not just the 'Fortunate 500'. Available as a SaaS (online) or as a Server package.
'Vertical' Software is often called an 'Application'. - It is typically developed for a specific set of tasks.- Is 'powered by' the underlying Horizontal Platform.- An example would be 'Recruiting' or 'Benefit Enrollment'.
Wasting Money? Money is wasted when:- Multiple software packages must be purchased.- Multiple licenses or 'seats' must be purchased for each.- Multiple user interfaces must be learned (extra training).
The Great Divide is Knowledge. If you have the required depth of Knowledge, you can accomplish difficult tasks but without it, you will either 'give up', assign or pay an Expert or purchase yet another limited use software application.
Cost? 1) Server package for $400. No limit on number of users.2) Online vsn (SaaS) = $480 per year (3 users).3) Custom programming from $25 to $75 per hour.
Many spokes. Younicycle's framework will allow you to create many types of Vertical Applications, defined only by your imagination. An Actuary - or a Recruiter, a Benefit Consutant or Insurance Carrier can create compelling, plug-in Solutions.
Need an Edge? Many possibilities:1) Create Customer Solutions & give to them for Productivity.2) Create and sell as a suppemental source of revenue.3) Create, give it away - but charge for added customization.4) Become a Partner. Sell Younicycle + your Solutions.
One wheel. We've designed the IT Vehicle so that:1) Experts can work side-by-side with Novices.2) WYSIWYG Tools auto generate complex code.3) Each 'mini-app' you create can be shared (or sold).
Getting there is the hard part ... but we've made the trip much easier. We have spent many years 'blazing a trail' and building the IT vehicle that can get you there, safely & affordably. Yes, it is easier - but Easy is a relative term.
Start here. Get there. It's a given that you want to provide superior service for your customers and always keep a responsible. technological edge. But how? Younicycle can give you that edge - & be white-labeled for your identity.
It's coming. Like it or not, your competitors are standing outside your customers' front door and can be invited in with a few clicks of a mouse. We have the high tech and you, the relationships. Let's talk while the sun is still out.
Personalizing your Employee Communications is critical whenever personal Knowledege is required. Use Retirement as an example. Why would an employee care about John or Jane Doe's retirement security? Meaningless, inaccurate information is not only irrelevant, it's dangerous. Do it right.
The 3 Steps for effective Employee Communications:1) Inform: Let them know it exists. Where? When?2) Educate Employees: What is it? How does it work?3) Personalize the content. John Doe is not real.
Employers: Collaborate internally, with us or other Vendors 1) We (or other Vendors) can provide Full service2) Do it yourself (DIY). You can always ask for help.3) Initial full service -> then DIY in the future.
Your Employee Benefits may be very Cool - but will be ineffective if they remain Hidden. Employee Benefit Statements help your Group understand & appreciate their Personal, Big Picture. We have more than 20 years of experience and know all the possible pitfalls.
Poor Henry. Overcome by events beyond his control.Approximately 3 minutes.
A Diagram of the 'Connections'
logo (image) placed on the Template
The Chart uses the same dataource & is placed on the template
Table (pebs_1)
Table (pebs_2)
joined
The 2 Tables are JOINED. The desired datafields selected and Casts, Expressions & other functions applied as appropriate.
A datasource is made on the Query.The datasource is like a 'mirror' of the Query and is now a floating layer of data -- accessible by Charts, Templates, Applications, etc.
An Action is created automatically that links the Query to the Datasource.
The XML for your Template is stored safely in your account.The Template loads the XML when launched.
Click the pdf icon. The XML is Saved - and pulls the datasource, merging it into the static template XML. The PDF is then processed on the server.
The Template
PDF
Developing a Rudimentary Benefit Statement: a Personalized PDF for Print
STEP 1
So the basic problem is we have data 'way over there' where it's not helping us a whole lot.
We could data enter all of that stuff in 7 additional columns, but that would be whacky. Imagine 7,287 employees in Table 'pebs_1' but only 6,814 in Table 'pebs_2'.
It would take 2 weeks to 'combine' -- and by then, 150 of them would have changed.Review what is below and you will be able to see how we JOINED the 2 Tables.
We could data enter all of that stuff in 7 additional columns, but that would be whacky. Imagine 7,287 employees in Table 'pebs_1' but only 6,814 in Table 'pebs_2'.
It would take 2 weeks to 'combine' -- and by then, 150 of them would have changed.Review what is below and you will be able to see how we JOINED the 2 Tables.
Click 'Queries' on the YTree. A list of Queries will show.
Click bs_1. The Query Editor will begin to load.
Click bs_1. The Query Editor will begin to load.
Part 3 (Join Tables)
Once again, review A Diagram of Connections.
Note that Queries can appear to be quite imposing & for those that have never dealt with SQL, downright intimidating.
The Younicycle Query Editor allows a Novice to use with a GUI, but also allows an Expert to directly type SQL.
The Younicycle Query Editor allows a Novice to use with a GUI, but also allows an Expert to directly type SQL.
Expressions give us the ability to write calculations. Many of these should be familiar and are similar in functionality to Excel. We make it as easy as possible and autmatically insert the Calculations inside of the Query.
Building a Datasource
Back
STEP 2
Notice the Tabs (Buttons) on the Left. The current Tab is Dataset Design and is where you can graphically JOIN Tables.
Click the little Green rectangle in between the 2 Tables and you'll see that is where you set the Type of JOIN (not shown on Image).
Notice that ee_id is the 'key'.... the common element.
Click the little Green rectangle in between the 2 Tables and you'll see that is where you set the Type of JOIN (not shown on Image).
Notice that ee_id is the 'key'.... the common element.
Time to Toot our own horn:
There is nothing like the Younicycle Query Editor in any SaaS on the Web.
It's the best. No doubt about it.
There is nothing like the Younicycle Query Editor in any SaaS on the Web.
It's the best. No doubt about it.
STEP 3
We only have 1 person in this Query, so we sure don't need Where, Group by, Having or Order by Clauses. We do encourage you to experiment!
The 'work' on this one is in the Expressions. See below.
Double click the one for 'ptw'.
The 'work' on this one is in the Expressions. See below.
Double click the one for 'ptw'.
After double-clicking 'ptw', you'll see the Expression Editor. This is not dissimilar from Filemaker, Access, Excel, etc.
You can create some very powerful Expression in this Editor.
You can create some very powerful Expression in this Editor.
Now click the SQL Tab. Whoa - where'd that all come from?
It was all automatically generated by clicking and typing in Expressions.
Even an Expert would hate to type all that stuff! You see - if 1 comma is wrong - the Editor would complain. The autogeneration of SQL is a big time saver - and anyone can learn.
It was all automatically generated by clicking and typing in Expressions.
Even an Expert would hate to type all that stuff! You see - if 1 comma is wrong - the Editor would complain. The autogeneration of SQL is a big time saver - and anyone can learn.
Now - Click the Tab for Test Query - and then Click 'Refresh'.
There it is. You're on a roll.
There it is. You're on a roll.
If you are a Person that enjoys Learning new skills, the SQL Editor is a Tool you'll love.
You DO learn for a simple reason: It gives you Feedback. You can see the results of your SQL 'Questions'.
The Editor also includes the ability to Update by Query and Delete by Query.
So -- tinker -- and learn.
You DO learn for a simple reason: It gives you Feedback. You can see the results of your SQL 'Questions'.
The Editor also includes the ability to Update by Query and Delete by Query.
So -- tinker -- and learn.