Home / Tech Tips (page 2)

Tech Tips

Five Cool Techniques to Keep up Your Sleeve to Design Visually Appealing and Dynamic Webi Reports

InfoSol Blog Tech Tip

First: To capture the value selected in Input Control/ Element Link in a cell Goal: Input Control and Element Linking are very frequently used WebI features to create highly interactive WebI reports or dashboards. The goal is to display the user selected option from the radio button/drop down/list box or ...

Read More »

Tech Tip: Content Validation for Reports Scheduled via Email

InfoSol Blog Tech Tip

Business(s) and their units send hundreds to thousands of emails out via report scheduling. Delivering the correct reports to the right person is mission critical for efficient business process. Currently, a recall email feature exists for incorrect emails sent within network, but the recipients are notified of the email recall. ...

Read More »

Tech Tip: DATETIME field format – Dealing with Milliseconds

InfoSol Blog Tech Tip

Tip: Error found at 00 Trick: Truncating datetime to seconds We recently worked with a customer to provide a solution to a datetime field in their PI SQL database (OSI) that was returning a SQL parsing error when using it in a query filter.  Specifically, the error stated “Error found ...

Read More »

How to pick up User Token or ID from HTTP Headers for use in a Dashboard

InfoSol Blog Tech Tip

Tip: How to pick up User Token or ID from HTTP Headers for use in a Dashboard. Trick: Use InfoBurst to inject the value into the dashboard. Figuring out security in your dashboards can often be one of the more difficult pieces to solve. Often times, we’re able to make ...

Read More »

Tech Tip: How to Skip Dataflows for Testing or Restarting a Job for Recovery

InfoSol Blog Tech Tip

Tip: How to Skip Dataflows for Testing or Restarting a Job for Recovery Trick: Use Bypass One of the greatest features of SAP Data Services is the ability to divert dataflows/workflows in a large workflow or job with multiple steps. This becomes very important when performing system testing or an ...

Read More »

Tech Tip: How to Document IDT Universe Information

InfoSol Blog Tech Tip

Tip: How to Document IDT Universe information Trick: Use Save as One of the features of IDT is to document all available setups that were performed on the business layer and data foundation of a .unx universe. In our example, we are going to document E-fashion Universe’s Business Layer. Prerequisites: ...

Read More »

Data Warehouse Design – Inmon vs Kimball Architecture

InfoSol Blog Tech Tip

We are living in the age of data revolution and more corporations are realizing the fact that to lead or in some cases to survive, they need to harness their data wealth effectively. The data warehouse, due to its unique proposition as the integrated enterprise repository of data, is playing ...

Read More »