WP_Query Object
(
[query] => Array
(
[post_type] => Array
(
[0] => resource
[1] => post
)
[posts_per_page] => 9
[orderby] => publish_date
[order] => DESC
[paged] => 10
)
[query_vars] => Array
(
[post_type] => Array
(
[0] => resource
[1] => post
)
[posts_per_page] => 9
[orderby] => publish_date
[order] => DESC
[paged] => 10
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[meta_key] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] =>
[menu_order] =>
[embed] =>
[category__in] => Array
(
)
[category__not_in] => Array
(
)
[category__and] => Array
(
)
[post__in] => Array
(
)
[post__not_in] => Array
(
)
[post_name__in] => Array
(
)
[tag__in] => Array
(
)
[tag__not_in] => Array
(
)
[tag__and] => Array
(
)
[tag_slug__in] => Array
(
)
[tag_slug__and] => Array
(
)
[post_parent__in] => Array
(
)
[post_parent__not_in] => Array
(
)
[author__in] => Array
(
)
[author__not_in] => Array
(
)
[search_columns] => Array
(
)
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_post_term_cache] => 1
[update_menu_item_cache] =>
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] =>
[comments_per_page] => 50
[no_found_rows] =>
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
)
[relation] => AND
[table_aliases:protected] => Array
(
)
[queried_terms] => Array
(
)
[primary_table] => wp_443ttgh517_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
)
[relation] =>
[meta_table] =>
[meta_id_column] =>
[primary_table] =>
[primary_id_column] =>
[table_aliases:protected] => Array
(
)
[clauses:protected] => Array
(
)
[has_or_relation:protected] =>
)
[date_query] =>
[request] => SELECT SQL_CALC_FOUND_ROWS wp_443ttgh517_posts.*
FROM wp_443ttgh517_posts
WHERE 1=1 AND ((wp_443ttgh517_posts.post_type = 'post' AND (wp_443ttgh517_posts.post_status = 'publish' OR wp_443ttgh517_posts.post_status = 'acf-disabled')) OR (wp_443ttgh517_posts.post_type = 'resource' AND (wp_443ttgh517_posts.post_status = 'publish' OR wp_443ttgh517_posts.post_status = 'acf-disabled')))
ORDER BY wp_443ttgh517_posts.post_date DESC
LIMIT 81, 9
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 4965
[post_author] => 6
[post_date] => 2019-01-28 06:27:15
[post_date_gmt] => 2019-01-28 14:27:15
[post_content] =>
[post_title] => QuickLaunch for JD Edwards - Customizing your Sales Dashboard with Microsoft Power BI
[post_excerpt] => Adapting your dashboards to suit your business, from products to territories to divisional sales results, only QuickLaunch gives the power to get exactly what you want to run your dynamic sales operation. Watch this short video on how to customize your Power BI-based sales dashboards.
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => microsoft-power-bi-sales-data-discovery-for-jd-edwards
[to_ping] =>
[pinged] =>
[post_modified] => 2019-01-28 06:27:15
[post_modified_gmt] => 2019-01-28 14:27:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://preferredstrategies.com/?post_type=resource&p=4965
[menu_order] => 49
[post_type] => resource
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 4963
[post_author] => 6
[post_date] => 2019-01-28 06:26:30
[post_date_gmt] => 2019-01-28 14:26:30
[post_content] =>
[post_title] => QuickLaunch for JD Edwards with Power BI our Free Trial Walkthrough
[post_excerpt] => We would love to have you try the power of QuickLaunch for yourself which is why we offer a FREE trial. This comprehensive video will provide a walk through of the free trial so you can easily follow along and see just how easy it is to create amazing dashboards in minutes with Power BI.
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => power-bi-with-bi-quicklaunch-for-jd-edwards-free-trial-walkthrough
[to_ping] =>
[pinged] =>
[post_modified] => 2019-01-28 06:26:30
[post_modified_gmt] => 2019-01-28 14:26:30
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://preferredstrategies.com/?post_type=resource&p=4963
[menu_order] => 46
[post_type] => resource
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 4959
[post_author] => 6
[post_date] => 2019-01-28 06:25:37
[post_date_gmt] => 2019-01-28 14:25:37
[post_content] =>
[post_title] => Microsoft Power BI for JD Edwards Powered By QuickLaunch
[post_excerpt] => For you to get the most out of a modern reporting and analytics tool such as Microsoft Power BI you will need to translate the obscure data descriptions in JDE into a meaningful business glossary. QuickLaunch will do this and so much more.
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => microsoft-power-bi-for-jd-edwards-with-bi-quicklaunch
[to_ping] =>
[pinged] =>
[post_modified] => 2019-01-28 06:25:37
[post_modified_gmt] => 2019-01-28 14:25:37
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://preferredstrategies.com/?post_type=resource&p=4959
[menu_order] => 45
[post_type] => resource
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 4957
[post_author] => 6
[post_date] => 2019-01-28 06:24:34
[post_date_gmt] => 2019-01-28 14:24:34
[post_content] =>
[post_title] => An Introduction to QuickLaunch for JD Edwards Modern Reporting & Analytics
[post_excerpt] => Why do you need QuickLaunch if your business runs on JD Edwards and you are using or considering a modern reporting and analytics solution such as Microsoft Power BI? This 90 second videos explains why.
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => preferred-strategies-introduction-video
[to_ping] =>
[pinged] =>
[post_modified] => 2019-01-28 06:24:34
[post_modified_gmt] => 2019-01-28 14:24:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://preferredstrategies.com/?post_type=resource&p=4957
[menu_order] => 44
[post_type] => resource
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 4950
[post_author] => 6
[post_date] => 2019-01-28 05:31:08
[post_date_gmt] => 2019-01-28 13:31:08
[post_content] =>
[post_title] => The Definitive Guide to JD Edwards Self-Service Reporting & Analytics
[post_excerpt] => If your business runs on JD Edwards then you’ll know how important it is to make the data for your business available across your organization. This Definitive Guide will provide valuable information on all the key requirements to becoming data driven. From data access, governance and security to modern reporting and analytics and predictive modelling.
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => the-definitive-guide-to-jd-edwards-self-service-reporting-analytics
[to_ping] =>
[pinged] =>
[post_modified] => 2022-10-21 16:36:08
[post_modified_gmt] => 2022-10-21 23:36:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://preferredstrategies.com/?post_type=resource&p=4950
[menu_order] => 51
[post_type] => resource
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 4947
[post_author] => 6
[post_date] => 2019-01-28 04:59:50
[post_date_gmt] => 2019-01-28 04:59:50
[post_content] =>
[post_title] => Take IT out of JDE Reporting With Self-Service Analytics
[post_excerpt] => Preferred Strategies QuickLaunch™ is a packaged software accelerator designed to enable business users outside of IT to develop JD Edwards reports quickly using easily adopted, modern BI tools like Microsoft® Power BI, Tableau,® Qlik® and a host of others.
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => take-it-out-of-jde-reporting-with-self-service-analytics
[to_ping] =>
[pinged] =>
[post_modified] => 2021-06-30 19:38:15
[post_modified_gmt] => 2021-06-30 19:38:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://preferredstrategies.com/?post_type=resource&p=4947
[menu_order] => 52
[post_type] => resource
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 4094
[post_author] => 6
[post_date] => 2018-12-18 14:43:43
[post_date_gmt] => 2018-12-18 22:43:43
[post_content] =>
[post_title] => Becoming Data Driven with Modern BI Technologies
[post_excerpt] => There’s a goldmine of data inside your JD Edwards system. But data is just a series of ones and zeroes without the tools to turn it into information. How do you mine your data to obtain actionable insights in a timely manner? How do you make data available across your organization in a safe, governed way? And finally, how do you incorporate machine learning and predictive analytics to take your reporting and analysis to the next level?
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => becoming-data-driven-with-modern-bi-technologies
[to_ping] =>
[pinged] =>
[post_modified] => 2022-10-21 16:05:07
[post_modified_gmt] => 2022-10-21 23:05:07
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://preferredstrategies.com/?post_type=resource&p=4094
[menu_order] => 59
[post_type] => resource
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 3501
[post_author] => 6
[post_date] => 2018-12-11 22:47:37
[post_date_gmt] => 2018-12-12 06:47:37
[post_content] => We co-hosted a webinar with GSI which had an outstanding attendance. There were many excellent questions and we were not able to provide answers to all of them during the webinar. Here is the Q&A transcript.
Q. Do you have models created for the JDE Configurator (System 32?)
A. We do not currently have JDE Configurator (System 32) as an out-of-box module with QuickLaunch. Once your requirements related to JDE Configurator are identified, we can provide feedback and proposal on the effort to include this or determine where this fits on the QuickLaunch development roadmap.
Q. What is the difference in the QuickLaunch software vs the out of the box Power BI?
A. QuickLaunch translates the JDE data so that your Power BI visualizations make sense. Without QuickLaunch you're left writing the glossary translation, your users have to know things like Table F0101 is actually the address book.
Here are some other key points:
- Supports all the major JDE modules
- Translates complex JDE aliases into business-friendly names
- Dozens of pre-built reports & templates to deliver faster business insights
- Integrated data governance including calculated measures and KPI's
- Easily solves complex calculations such as aging and calendar-based events
- Integrate other data sources with your JDE data
- Simple deployment options-on premise, cloud or hybrid hosting
Q. Has Microsoft Power BI replaced the Business Objects BI software that was used few years back?
A. Short answer yes, in many companies. Power BI is a new classification of BI software that Gartner calls modern BI. The difference being that traditionally IT would use a tool like BusinessObjects to create reports upon request from the business, modern BI tools are designed to hide the complexity of these legacy tools to help business users gain the insights themselves without relying on IT. This not only shortens the time to value, it alleviates a constant interrupt driven operational process in IT.
Q. Can you please talk about the pricing of the tool and also if all of the JDE data is accessed real-time?
A. We offer various pricing options from subscription to perpetual license. The fees structure changes by the number of JDE modules being used with QuickLaunch and the connection method to your data (Direct Connect, Operational Data Store, Data Warehouse). We support 14 modules of JD Edwards out-of-box with QuickLaunch, so we are not pulling all JDE data into QuickLaunch, however, any data required for reporting and analytics with QuickLaunch can be added very quickly. Typically, customers will refresh their QuickLaunch Analysis Services Tabular Model/Cube on an hourly schedule, however, we have alternative ways customers can update it within a matter of minutes and be executed on demand, i.e. the Controller in month-end close can kick off a financial refresh of data and have JDE GL information loaded in the data model within a couple minutes. Our QuickLaunch Enterprise Data Warehouse (EDW) is updated within 5-10 minutes of JDE transaction data and we are currently rolling out a Direct Query Tabular Model over the EDW so once data is in EDW it can be read directly by Power BI.
Q. What versions of JDE are supported?
A. We support all versions of JD Edwards World and EnterpriseOne
Q. Can cube data be combined with other independent data-files within Power BI?
A. Yes, data can be imported into a Power BI report from a Tabular Data Model/Cube and related to other data sources. If a Power BI report is developed from a Tabular Cube in a "direct live" option, then it cannot be related to other data sources.
Q. What needs to be done to publish a dashboard within Sharepoint to make sure everyone can access/see the visuals?
A. QuickLaunch customers typically share Power BI reports via the Power BI Service (in the cloud) or on premise with the Power BI Report Server but if you want some information regarding Power BI with SharePoint, the information below may help, as well as looking at
sharepoint permissions management.
The way the feature works is simple. Follow the process below to use this feature.
1) Publish your Power BI report to your Power BI account
2) Get the URL to the report
3) Add the Power BI (preview) web part to your SharePoint Online page
4) Paste the URL of the report when prompted
5) To finish, save and publish your page!
Some other URL's to explore are below as well.
https://www.sharepointeurope.com/integrate-power-bi-reports-in-sharepoint-online/
http://www.axioworks.com/2018/02/using-power-bi-with-sharepoint-data-the-ultimate-guide/
Q. Is there a limit to the number of columns and rows in a table/ visualization and number of filters on one report?
A. None. Bring it on!
Q. The templates for security module are included ?
A. We do not have a module specifically for JDE Security, but we do configure our Tabular Model to reflect JD Edwards row security when that is required by the customer. Since we are already connecting to the JDE security tables it would be an easy addition if a customer would like to build reports over the JDE Security information.
Q. How do you handle fields that have been repurposed or User Reserved Fields as well?
A. Part of the QuickLaunch out-of-box configuration includes the renaming of JD Edwards Category Codes so if your BU Code 01 is Region, it will be labeled as Region instead of BU Code 01 or MCRP01. We also support Custom Tables, Tag Files, and other data outside JDE can be added to a QuickLaunch data model.
Q. Which version of PowerBI it used? what is architectural schema/ requirements for deployment?
A. Microsoft has an aggressive upgrade program with Power BI and we ensure that QuickLaunch works with each version. There are a number of ways to deploy QuickLaunch with PowerBI and this is dependent on your on-prem verses cloud deployment decisions. We work equally well in either environment or a hybrid which is becoming more common today, whereby JDE data is still operationalized on premises and data for Analytics, reporting and data science is mirrored on to a data lake or a cloud based data warehouse. Power BI in itself (Power BI Desktop and Cloud Service) doesn't have many requirements to get going other than setting up a Gateway connection to connect your reports in the cloud to your data on-premise, but to implement Power BI as and Enterprise solution we recommend using our SQL Server Analysis Services (SSAS) Tabular Mode to manage datasets on a BI server which becomes the governed source of truth for Power BI. There are some differences between SQL Server Enterprise and Standard Edition (Perspectives, Partitioning, and Instance sizes, etc.). Our QuickLaunch SSAS Data Model utilizes best practices and is the most optimized and affordable way to get Power BI running over JDE.
Q. How do you implement near real-time updates for your data warehouse product?
A. If you are running JD Edwards on SQL Server, we have developed QuickLaunch SQL Server Integration Services (SSIS) ETL Packages using incremental methodologies (Native CDC or Change Tracking) which run every 5 minutes or so to extract data from the JDE SQL DB transaction logs and update the changes in the EDW. Typically our EDW runs around with about a 10 minute lag behind JDE data. If you are running JD Edwards on iSeries or Oracle, we use third party replication software to mirror JDE data into an Operational Data Store (ODS) on SQL Server ever few minutes and then we run our QuickLaunch SQL (ODS) to SQL (EDW) SSIS ETL scripts to update the EDW. If you are unfamiliar with the role of SQL, you can look at blog posts from
Timescale that delve into this area and can provide more background.
Q. We have a number of custom tables in our instance of JDE, can QuickLaunch support those?
A. Yes, we support custom tables. We can add them as part of the initial rollout, but we also provide knowledge transfer to you so you can do it yourself in the future as well. Once the Custom Tables are added to the model and related properly to the other data in the model, it will be exposed to PowerBI for Analytics and Reporting.
Q. How do I know the data I am using with QuickLaunch is trusted?
A. Great question and critical for deploying a self-service data environment. If IT is not preparing the reports, there may be natural skepticism around the results a business user is generating and displaying with PowerBI. This is where QuickLaunch can help, by connecting to your source JDE data and translating the obscure table and field terms into comprehensible business glossaries, this will provide the assurance that the right data is being selected for analysis. Other complex calculations such as KPI's and measures, calendering, calculated values are all handled by QuickLaunch leaving nothing to chance or interpretation. When asked "where did you get this data?" the response is QuickLaunch on JDE so it is considered trusted by IT and across the org. We also document the lineage of each field in the Data Model back the source JDE field so people know where the data has originated from.
Q. Are we going to get a copy of the slides or do we need to screenshot each slide...?
A. Please find a link to the slides
here
[post_title] => How to Build JDE Dashboards in Minutes – and Get Noticed! Webinar Q&A
[post_excerpt] => We co-hosted a webinar with GSI which had an outstanding attendance. There were many excellent questions and we were not able to provide answers to all of them during the webinar. Below is the Q&A transcript.
[post_status] => publish
[comment_status] => closed
[ping_status] => open
[post_password] =>
[post_name] => how-to-build-jde-dashboards-in-minutes-and-get-noticed-webinar-qa
[to_ping] =>
[pinged] =>
[post_modified] => 2021-06-18 22:51:38
[post_modified_gmt] => 2021-06-18 22:51:38
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://preferredstrategies.com/?p=3501
[menu_order] => 16
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 4003
[post_author] => 6
[post_date] => 2018-11-15 23:36:40
[post_date_gmt] => 2018-11-16 07:36:40
[post_content] => We conducted a survey of JD Edwards users with a focus on their respective reporting and analytics environments. Access this whitepaper to see a summary of our survey results and conclusions.
[post_title] => JD Edwards Reporting & Analytics Survey Highlights
[post_excerpt] => We conducted a survey of JD Edwards users with a focus on their respective reporting and analytics environments. Access this whitepaper to see a summary of our survey results and conclusions.
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => jd-edwards-reporting-analytics-survey-highlights
[to_ping] =>
[pinged] =>
[post_modified] => 2022-10-21 16:39:26
[post_modified_gmt] => 2022-10-21 23:39:26
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://preferredstrategies.com/?post_type=resource&p=4003
[menu_order] => 63
[post_type] => resource
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 9
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 4965
[post_author] => 6
[post_date] => 2019-01-28 06:27:15
[post_date_gmt] => 2019-01-28 14:27:15
[post_content] =>
[post_title] => QuickLaunch for JD Edwards - Customizing your Sales Dashboard with Microsoft Power BI
[post_excerpt] => Adapting your dashboards to suit your business, from products to territories to divisional sales results, only QuickLaunch gives the power to get exactly what you want to run your dynamic sales operation. Watch this short video on how to customize your Power BI-based sales dashboards.
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => microsoft-power-bi-sales-data-discovery-for-jd-edwards
[to_ping] =>
[pinged] =>
[post_modified] => 2019-01-28 06:27:15
[post_modified_gmt] => 2019-01-28 14:27:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://preferredstrategies.com/?post_type=resource&p=4965
[menu_order] => 49
[post_type] => resource
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 112
[max_num_pages] => 13
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] =>
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] =>
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] => 1
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] => 1
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] =>
[is_post_type_archive] =>
[query_vars_hash:WP_Query:private] => 876a96ea8592b725ff8aa1f771bbf0f4
[query_vars_changed:WP_Query:private] =>
[thumbnails_cached] =>
[allow_query_attachment_by_filename:protected] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)
[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)
)
Product Literature
The Definitive Guide to JD Edwards Self-Service Reporting & Analytics
If your business runs on JD Edwards then you’ll know how important it is to make the data for your business available across your organization. This Definitive Guide will provide valuable information on all the key requirements to becoming data driven. From data access, governance and security to modern reporting and analytics and predictive modelling.
Product Literature
Take IT out of JDE Reporting With Self-Service Analytics
Preferred Strategies QuickLaunch™ is a packaged software accelerator designed to enable business users outside of IT to develop JD Edwards reports quickly using easily adopted, modern BI tools like Microsoft® Power BI, Tableau,® Qlik® and a host of others.
Webinar
Becoming Data Driven with Modern BI Technologies
There’s a goldmine of data inside your JD Edwards system. But data is just a series of ones and zeroes without the tools to turn it into information. How do you mine your data to obtain actionable insights in a timely manner? How do you make data available across your organization in a safe, governed way? And finally, how do you incorporate machine learning and predictive analytics to take your reporting and analysis to the next level?
