Sunday, October 15, 2017

Smart View Query Designer Gets Emotional

Smart View and Query Designer

I can't recall ever seeing this 'Warning Box' before while using Smart View and creating Query Designer Worksheets, etc. 

So, here is a little blog post about it.


  



And it is a Sunday GAMEDAY with less than an hour before kick-off, so I better complete this short but loving post in time..

I was creating a few Ad-Hoc Essbase queries and wanted to take one of my analysis sheets and turn that into a nice dynamic Query Designer report.

So, I followed the steps that I normally do. I usually start with an Ad-Hoc Query first. Then let Smart View and the Query Designer do a bit of the heavy lifting and transform that sheet into a 'Query'. I applied the query and got the desired results that I wanted.

A part of my analysis required me to start over and so I went ahead and started deleting the worksheets from the workbook. When I was done, I went to save my work. Clicked Save. And then the error appeared..

Sometimes when working with Smart View, I have to admit, I am reminded of this wonderful Disney Movie, Inside Out and all of the emotions.














Good news is that it looks to only be a warning-suggestion. But it feels a bit sad or even angry that the Query Designer worksheets were missing. Sorry to upset you Smart View.



















Borderline anger?



I went ahead and clicked 'OK'. Closed the workbook, re-opened and everything worked just fine.



Glad to see that Smart View was only maybe giving me a suggestion or trying to remind me :)



Well, phew, glad this was a short post. Now time for me to grab a bite to eat and watch the game!



Friday, October 13, 2017

OAC Patch 17.3.5 - Version 12.2.1.1.107 Essbase & Cube Designer

Oracle Analytics Cloud Service (OACS) 17.3.5 is Available - apply the latest patch

This caveat to the latest patch was talked about a TON at OOW this year .. 
  • OAC 17.3.5 does NOT offer IDCS integration (targeted for next release)

Essbase Version 12.2.1.1.107 & Smart View Extension - Cube Designer





Along with this patch was an update to the Cube Designer Extension

Previous Cube Designer Extension - 12.2.1.1.106



New Cube Designer Extension - 12.2.1.1.107





OAC - DV


I know that there have been a few others that have posted about how to do this but I don't think it would hurt to continue to share how to be able to set up
OAC - Essbase as a Data Source in OAC - DV

It is really all about creating two (2) Access Roles on the OAC - Essbase-side

This is the Oracle Support document that is easy enough to walk through
OAC : How to create connection to Essbase from Visual Analyzer (VA) in Oracle Analytics Cloud (OAC) (Doc ID 2265410.1)


Once the roles are created you are then able to set up OAC - Essbase as a data source in OAC - DV, pretty cool! Happy visualizing 💭  👀
More posts on OAC DV coming soon.



My MLB Baseball Essbase cube in the cloud fun side project (Yes, that is what i consider something fun to work on nights and weekends when I am not doing work-work, creating dioramas, reading, listening to all sorts of Disney movies, songs, dancing, etc.) has been coming along very nicely.

I am looking forward to seeing what that data looks like in OAC DV now! 😎


More blog posts to follow

Thursday, August 31, 2017

OAC - Cube Designer 12.2.1.1.106


### -> 106 -- 106 -- 106 <- ###



12.2.1.1.106   --  Smart View Cube Designer Extension




Yes, just a few days ago I blogged about 105 (Cube Designer Extension 12.2.1.1.105)

and now ready to Update!




A few email exchanges and a few days later, here we are with another version AND with updates to features.


Let's take a look at a few of those additions




Outline Order - Outline Dimension Order

If you are building using the Cube Designer from scratch. When you click 'To Sheet' the Worksheets get created and the Outline Order is now auto populated, starting with the first dimension you typed into the Extension panel; Beginning with 1, 2, 3, etc.


If you have started by downloading/copying the cube workbook and deleted the number ordering, you can simply click on the 'To Sheet' button and the worksheet will get the Outline Order Numbering added directly into the worksheet "Essbase.Cube".




Application Properties section


Now added to the Cube Designer workbook is the ability to change the application level configuration settings (essbase.cfg settings). These at the moment are added manually and are required in a similar syntax/format as Substitution Variables; meaning Setting Name and Value in side-by-side cells.

via Cube Designer




via OAC Web (settings)





Text Lists



















Generate Generations (Generation Names/Naming) for each Dimension











































Happy to see the updates!!


Hope we see more updates, especially for the Hierarchy Tree View!



Sunday, August 27, 2017

OAC - Essbase version 17.3.3-926 Cell Information

This is the point in the weekend when I take a break and blog about how much fun I have been having. Going running. Or Walking. Okay, well maybe NOT. The Go No-Go decision will be coming up this week Friday, September 1st!! Think good thoughts everyone so that  >this guy< gets the green-light to start walking .. in the walking-boot!

But onto the other fun that I have been having this weekend. A little Cube Designer carry over from the last blog post as well as getting an Application:Cube built in OAC - Essbase! :)


I wanted to share a few fun items I found while building and validating data and OAC - Essbase features. Let's take a look.

First is the button for Member Information, take a look..







Wait, there is no more Member Information button! :)
It has now been transformed to a button called Cell Information!








With that, let's go ahead and click the button while our cursor is on a data cell.


















Pretty nice. You can edit the solve order directly from Smart View. Press the Edit button on the lower left. Make the desired change to the solve order. Click OK.


Now let's take a look what happens when the cursor is on a dimension/member cell




















Looks the same as it used to before, all of the member information for that dimension or member.
Information, Aliases, Attributes, Formula, UDA(s), etc.


If you are following the blog posts, maybe you are starting to see a trend or at least notice the cube that I am building .. it is a decent size cube (stats back to the first year in 1871) with the real data. And I am looking forward to more blog posts using this Essbase Cube in the Cloud with Data Visualization and BICS!

Hope to blog about those soon. Stay tuned.


Saturday, August 19, 2017

OAC - Cube Designer 12.2.1.1.105 SV11.1.2.5.710

YEAH! OAC - Essbase and the Cube Designer Ribbon and Extension


A new way to create and build Essbase cubes, is not just from Excel workbooks, but also with Smart View! :) This has been technically available and supported with recent versions going back in Smart View to version 11.1.2.5.620 mentioned in a prior post

So let me get this out of the way. The naming/numbering conventions are making me a little insane

  • Software Release OAC 17.3.3-926 plus patch number
  • Smart View 11.1.2.5.710 plus extension(s)
  • Cube Designer 12.1.1.105 extension


why? Oh Why? JUST WHY?


Well, onto the geeky portion of the post that starts now. Hope you enjoy the little bit of fun I added while working on this post.

Let's get started.




Virtual machine .. Windows 10 64bit



Machine started in a matter of seconds

Note: I already had done the download and installation of the latest version of Smart View 11.1.2.5.710 that recently came out in August-2017. Plus the Smart View Cube Designer Extension was previously installed and enabled

Time to launch Excel 2016 32bit. Done.

Let's verify the Version of Smart View



Beautiful. Let's take a look at the extensions.
Go to Smart View .. Options ..









Go to the Extensions tab on the bottom left



You may have more or less extensions, we are looking for and to make sure we have the 'Cube Designer' extension, which we do. Perfect.


The Cube Designer Ribbon




This post is going to focus on the Cube Designer and more posts to follow.

AND NOW .. for the main attraction. Cube Designer.




Make sure that you have an active Excel Workbook. Click the Cube Designer button to begin building an Essbase cube with the Wizard. Did someone say wizard?

Essbase Cloud Cube Designer. Slightly different name. Must be a version thing mentioned earlier ;)



And there you have it.

But we are not done just yet.

Why don't we continue to see what happens when we step through the extension window 'wizard' to build a cube.

Tabs across the top of the extension. Cube, Settings, Dimensions, Data, Calc



Add (enter) an 'Application Name'
Add (enter) a 'Cube Name'
Dimensions: where it says in italic-grey font 'Add Dimension' start typing your desired dimension name, hit enter/return and keep repeating until you have all your desired dimensions.

Pretty easy and straight forward so far.

Now at this point or really any point from now on you can click on the button 'To Sheet'



this little button starts the magic to begin or adds the magic once you have begun to build your cube in the workbook .. click it and see



Pretty slick so far.
And there are my wizards, I mean Dimensions to the worksheet named 'Essbase.Cube'

Next is 'Settings' or 'Cube.Settings'



As is, the Cube designer wizard builds a BSO cube as the default.
But that can be easily changed by manually typing ASO into the cell changing the Application Type manually or by simply unchecking the checkbox 'BSO (Block Storage Outline) and clicking our friend the button 'To Sheet'





Moving onto Dimensions. The Dimension names were added on the 'Cube' tab but the tab 'Dimensions' is now where the property types, build method and mode, generation information (used for Drill-Through), along with the fields that are desired for use in the build process




And don't forget about any UDAs that you might want to add, provide how many, or the Alias Table you want to use, check the checkbox





Next, time to add the magic potion .. I mean Data

Provide the name for your data. This is probably best to think of your data in datasets.
Actual. Budget. Forecast, etc. or in my example, Magic Potions















Onto the last tab in the wizard, Spells .. I mean Calc
Add any calcs as needed!




Now that you have stepped through the wizard. I want to look at 1 item quickly before this post is done. Dimensions. And specifically adding members and viewing them in a Hierarchy GUI TreeView fashion. Like EAS or for those still using AppMan (Application Manager and I know you are out there.. I have seen you for myself and nothing wrong if it still works..)

The Cube Designer on the ribbon has a button 'View Hierarchy'



For those that are familiar with cubes, multidimensional, non-relational (field-record-row) data. Maybe this is not entirely needed but a part of my cube builds it is nice to see from time to time what the resulting outline is going to look like..

So in the Dimension that I wanted to create, Harry_Potter I started to define what that hierarchy was going to be .. and added a few members manually.. take a look what happened when I clicked the 'View Hierarchy' button on the ribbon, I can see what the hierarchy looks like and even make edits from this GUI window, very nice!




I would like to add that it is nice to see the TreeView of the Hierarchy and the features that are there in this version. In future versions of the Cube designer, it would be nice most if not all of the dimension/member property information. Including the child/descendant count, Generation # & Level #, Member Formula(s),  the UDA(s), just to name a few.


So that is the OAC - Essbase Cube Designer Wizard in a nutshell .. look, this is me in a nutshell (Austin Powers) 😀


More blogging soon on the creation of the cube in OAC.
And then onto DV (Data Visualization) and maybe a little bit BICS!!!


p.s. Yes, I was in a car accident. Head on collision. Only me in my car. Only her in her car. As told to me on the accident site and also states in the police report. She was tired and fell asleep at the wheel. YIKES!! A LITTLE COMMON SENSE PEOPLE.. as a result >this guy< got a Broken Right Foot. Had Surgery 1-week later. Dr. says x-rays looked good 2-weeks after surgery. Surgery cast off, stitches out. Walking boot, YEAH.. but a big boo since i am still non-weight-bearing :( at least until my next doctor visit on September 1st.. wow, that still feels like a long ways away .. 

but I guess that just means more time on the nights and weekends to research on fun EPM and BI things going on, catch up on other fun things at work and oh what the hay.. download the free trial of the HBO NOW app on my iPad and start, yes start, watching Game of Thrones #GOT.. Season 1 done. Season 2 done. And just started on Season 3! Don't spoil it for me .. I do want to catch up to this season :)

Friday, August 18, 2017

Smart View Release 11.1.2.5.710

Ah, yes, another version of Smart View for Office released .. 11.1.2.5.710

I tweeted about it the other day.. the zip file here that downloads from OTN is nice enough to tell you which version you are downloading



but unfortunately after the unzip the installer still leaves you unsure as it is still the SmartView.exe



Well, onto other news.

The documentation for this version can be found here -> https://docs.oracle.com/applications/smartview/710/index.html

And let's see what new features there are

  • Change the Solve Order of Members in a Calculation
  • Calculation Trace
  • Audit Trail


Well then, all new features for OAC! Guess I know what this guy with a broken foot recovering from surgery and still not able to walk is going to be spending time doing this weekend ;)

.. a song starts playing in my head .. Are you down with OAC .. yeah you know me... might have dated myself. ENJOY!

https://youtu.be/qdeH7QhGiRg















More posts to come about this version, OAC and the Cube Designer!!
And maybe even a little DV and more


Friday, August 4, 2017

Kscope17 Gary Interviews Gary About "The SV++ Utility Ribbon"

I still enjoy being able to look back at how much Kscope each year has to offer!


This year I was asked to be interviewed at the Social Media Lounge by none other then Oracle ACE Gary Crisci, ODTUG Board Treasurer. And at the time of the interview I was not, but while at Kscope17 in San Antonio I was honored to be accepted into the Oracle ACE program! I too also volunteer with ODTUG as the EPM Community Leader. Gary C. and I talk about the Smart View ribbon utility SV++.
  • Why the ribbon/toolbar came to be
  • Where did it start from
  • What are a few features, functions, etc.
  • How can you build your own?
  • Or just download a fully developed solution here


YouTube video
https://youtu.be/B8v8KMBN8Dk
....

Sunday, July 9, 2017

Oracle Cloud ERP and Maxl?

Lately, working on being able to directly connect FDMEE to an Oracle Cloud ERP! Fun, new, different and exciting. Or nerdy geeky, you decide. But I do know that it means it is time to learn more. And post along the way to be able to help others that are also taking this journey...

Facts in this case:

-   Oracle Cloud ERP R11 (soon upgrading to R12) and we already know that there is an Essbase cube prior post
-   FDMEE on-prem 11.1.2.4.210



After finally getting the FDMEE .210 on-prem connection to our Oracle Cloud ERP source!!









I was hit with the fact that the connection type was EPM-to-EPM. What did that mean? It meant that the connection being made was to the Essbase GL cube in the Cloud ERP! Perfect!

But not so fast.


There is still work to do. Future posts on this, but I wanted to prove that it really is Essbase. And what is driving Calculations, Allocations, etc. in the ERP are being done in the cube. Those mentioned are being created via the EPM Workspace ;) and the Rule Designer! But keep in mind that these are being done against an Essbase ASO cube. There is no EAS, or as told to me (the names are [hidden]), ".. there is no outline ..". And by stated by a friend, "..if there is no outline, then it isn't Essbase.."



Now, that first statement by the unnamed makes me scrunch my face, tilt my head and shake sort of like the way that my beloved Boxer named Zeus used to do. (pictured left)

RIP buddy. I miss you and your mom misses you but not all of your dog hair .. which she said she is still finding to this day! 

How did you think that eating 11 baby pacifiers was a good idea?! 







I know, don't tell me, but I have a hunch that your furry sister Athena had something to do with it .. (pictured left)











Back to Oracle Cloud ERP.


In needing to get not only the Values and Hierarchies PUBLISHED in the ERP.
It was apparent that more of a true and full hierarchy was needed.
Similar to what we see in our EPM applications-cubes, etc.
And so, now it is time to attempt to add that to the Cloud ERP.

Once the desired hierarchy(s) are PUBLISHED in the ERP, they also need to be DEPLOYED in the GL cube as well. After the job-task to deploy is executed. This is what we see in the log.

---log#.log---------------------------------------
.
creating am with: Name: oracle.apps.financials.generalLedger.ledgers.essbase.publicModel.applicationModule.LedgerEssbaseAM Config: LedgerEssbaseAMLocal

Created Application module instance
.
PublishHierarchyVersions: Independent request for Publishing tree versions fro cubes, given COA ....
getParameterValue: Start
Trying to retrieve param key submit.argument1
Retrieved value for param submit.argument1 as: #
getParameterValue: End
PublishHierarchyVersions: COA ID : #
getParameterValue: Start
Trying to retrieve param key submit.argument2
Retrieved value for param submit.argument2 as: {name here}
getParameterValue: End
PublishHierarchyVersions: COA Name : {name here}
getParameterValue: Start
Trying to retrieve param key submit.argument3
Retrieved value for param submit.argument3 as: <Seg#>
getParameterValue: End
PublishHierarchyVersions: Segment Code : <Seg#>
getParameterValue: Start
Trying to retrieve param key submit.argument4
Retrieved value for param submit.argument4 as: <Seg#>
getParameterValue: End
PublishHierarchyVersions: Segment Name : <Seg#>
getParameterValue: Start
Trying to retrieve param key submit.argument5
Retrieved value for param submit.argument5 as: <Val>
getParameterValue: End
.
publishTreeVersions(): start
publishTreeVersions(): *******valueSetId= #    *****segmentCode=  <Seg#>  *******coaId=  #
publishTreeVersions(): *****valueSetCode= <Val>  *****SegmentName=  {name}  *****coaName=  {name}  ****** listOfInsertVersionIds=,  ****** listOfDeleteVersionIds=,<Val>,  ****** detailedValuesOnly=null

publishTreeVersions()No. of  cubes to be updated 1
.

 ++++++++++++++++++++ publishTreeVersions():::  Application / Cube being updated: [App] / [db]
publishTreeVersions():::  Building Gen2 node :all dimension Values for dimension/valusetid/segmentSeq <Seg>
####################### publishTreeVersions()::: Maxl Command execution Start at Dt Mo Da HH:MM:SS UTC YYYY########
publishTreeVersions(): Executing cmd:alter application 'App' disable connects
publishTreeVersions(): Result:true
publishTreeVersions(): Executing cmd:alter application 'App' disable commands
publishTreeVersions(): Result:true
publishTreeVersions(): Executing cmd:alter system kill request on database 'App'.DB
publishTreeVersions(): Result:true
publishTreeVersions(): Waiting for requests to reach safe point.... 
publishTreeVersions(): Executing cmd:alter system logout session on database 'App'.DB
publishTreeVersions(): Result:true
publishTreeVersions(): Executing cmd:alter application  'App'  enable commands
publishTreeVersions(): Result:true
publishTreeVersions(): Executing cmd:alter database 'App'.db  unlock all objects
publishTreeVersions(): Result:true
publishTreeVersions(): Connecting to Cube now .... 
####################### publishTreeVersions()::: Maxl Command execution Finished and took 123.299 Seconds. ########
replaceAliasTableName() : cube outline is opened :: otl
.
 buildGen2DetailedlevelNode() : SQL string :
SELECT  ... 
FROM
WHERE
ORDER BY
.
 buildGen2DetailedlevelNode() : Building rulesfile for dimension ...:: <Dim>
#################################### 
buildGen2DetailedlevelNode() :Building rulesfile for dimension ...:: <Dim>
End and took 0.104 Seconds############################
 buildGen2DetailedlevelNode() : Rule file name  ... :: /tmp/SEGMENT.rul
.
 ####################################
.
buildGen2DetailedlevelNode(): START Building dimension  ... :: <Dim>
#################################### buildGen2DetailedlevelNode() :Dimenstion building for <Dim> Start
############################
buildGen2DetailedlevelNode() :Dimenstion building for <Dim> End and took 3.143 Seconds############################

<CUBE>App</CUBE>
    <DIMENSION>
        <DIMENSIONNAME>
        <OBJECT_ID></OBJECT_ID>
            <VALUESETCODE></VALUESETCODE>
.
.
buildGen2DetailedlevelNode()::: Building this  version completed.
 #################################### 
publishTreeVersions():: # ::Setting the dimension : <Dim> to MULTIPLE_HIERARCHY....
publishTreeVersions():: 2 ::Setting the dimension : <Dim> as LABEL ONLY....
publishTreeVersions():  Version details ::  Tree Code: <HIER>, Version Name: <VER> , Version ID : #
publishTreeVersions(): Updating/Creating Tree-Version :: <VER>
.
Clear the Generation Names - START
Clear the Generation Names - END
Setting the dimension Generation Name as : <Dim>
Gen2 as : Tree Filter
Gen3 as : Level Code
######################## publishTreeVersions(): end incremental build for dimension start at Dt Mo Da HH:MM:SS UTC YYYY  ###########################
######################## publishTreeVersions():  end incremental build for dimension <Dim>  END and took 15.625 Seconds ###########################
publishTreeVersions() : cube outline is opened :: otl6
publishTreeVersions() : cube outline is closed :: otl6
publishTreeVersions(): Executing cmd:alter database 'App'.DB  unlock all objects
publishTreeVersions(): Result:true
publishTreeVersions(): Executing cmd:alter application  'App'  enable connects
publishTreeVersions(): Result:true
publishTreeVersions():::  Building/deleting versions completed successfully for the cube
#################################### publishHierarchyVersions() :publishTreeVerCall End and took 178.933 Seconds############################
PublishHierarchyVersions: Versions published successfully for Chart Of Account : [COA] and Segment <Dim>
Publishing versions for the [COA]  completed

Releasing Root AM...
.
---log#.log---------------------------------end---


Yes, there are many typos in the actual log file itself. i.e. fro, Dimenstion

And yes, there IS an outline!!
It says so in the log .. "cube outline is opened :: otl" and many more references of an outline. There is a rule file! .rul and the Maxl to open, edit. Set the dimension as Multiple, Label Only, etc.

Make sure to check the checkbox to Deploy and be able to see your desired hierarchy(s) in your Cloud ERP Essbase cubes.

More posts on this subject.
Stay tuned.



DOUG - Detroit Oracle User Group

After going to Kscope17 this year I came back & started a Meetup group.

The name of the Meetup is DOUG - Detroit Oracle User Group!

https://www.meetup.com/DOUG-Detroit-Oracle-User-Group-Meetup/

















This is a group for anyone interested in anything and all things Oracle, EPM, Hyperion, OBIEE, Database, Big Data, Cloud & more. All experience levels are welcome. This group was started to meet other technology enthusiasts!

If you are in the metro-Detroit area, or even just in town for any reason and we are having a Meetup. Come and join us!

...
Are you ready to #GetInvolved with ODTUG? Want to start a Meetup near you?

Learn more here -> http://www.odtug.com/page/meetup




Friday, July 7, 2017

PSA - Microsoft Add-Ins Don't Load

- PSA -

This is a Public Service Announcement to all of you with Add-Ins in Microsoft Office products. More specifically 2016 and Add-Ins that don't or will not load when opening the program application (Excel, Word, etc).

It came to my attention that the add-in utility SV ++ that is available on this blog was not loading for some users 
- thank you Kyle B. & Peter.

Seems that there was an update issued by Microsoft. It was a security related patch and the fix can be found here but the curious part is that this was issued over a year ago, and then there was another update about 6-months ago. So, not really sure why no impact then .. and now all of a sudden. But no worries, hope this fixes the issue now if you run into it.

Below is the way to solve the issue per the superuser blog:

"With this update, we changed the behavior of Excel so that it will not load certain file types (including .xlam) when they are untrusted. The easiest workaround is to find the add-in that is causing you trouble, right-clicking on it in Windows Explorer, and checking Unblock"

"An easier approach is to simply place the add-in in a Trusted Location (in Excel, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations), such as the following folder, and load it from there:
C:\Users\%USER NAME%\AppData\Roaming\Microsoft\Excel\XLSTART"


Hope this PSA helps if you run into the issue.


Again, to learn more, you can visit here

This is a message from the cloud.

Saturday, June 10, 2017

Lowest Supported OAC Smart View Version

I was very excited to start to working with OAC .. Oracle Analytics Cloud - Essbase the other day!

In a prior blog post here I mentioned that the documentation had been updated in 11.2.5.700 with a section called -> 'Smart View and Oracle Analytics Cloud - Essbase'.

I was wondering what was the minimum version of Smart View that could be used (supported) for OAC. In doing research on a slightly different topic I happened to find out the answer. That answer is OAC is supported per the documentation on an earlier version of Smart View for Office, that being 11.1.2.5.620.

Good to know that 11.1.2.5.620 is the lowest version of Smart View that Oracle supports for OAC.

Have a great weekend!

New Features
https://docs.oracle.com/applications/smartview/620/SVSTW/toc.htm#smart_view_11125620_readme_145

Friday, June 9, 2017

Getting Ready For Kscope17

I CAN'T WAIT! I CAN'T WAIT! FOR KSCOPE17

According to my countdown app or the Kscope17 app, as of today we are only 15 days, 12 hours, 39 minutes and a handful of seconds away. Or rounding up to the day, only 16 days away! Or rounded down, 15! :)

In preparation, required documents have been loaded to the site. My slides, are approximately ~77.7% done to date plus or minus a few percent ;)

Not sure I am going to have a ton of time, but excited to get deeper into OAC - Essbase Cloud Service!




I already connected and was able to connect via Smart View and 'Install'ed the Cube Designer Extension!



There is now a static fixed Ribbon that always shows when Excel opens. I have submitted an Enhancement Request to make a slight edit to this feature and turn this into a contextual ribbon, similar to the other products (Essbase, HFM, Planning, OBIEE, etc.).




This is what the actual Cube Designer ribbon itself contains




And of course, @GaryCrisci created The Beverage Company (TBC) application everyone knows and loves, Sample Basic!

Also had to add the ASOSamp to the mix and there they are below.




More to come. I have visions of OAC and posts to follow this summer and beyond!

See you in San Antonio! @Kscope17